SAS Data Step 2 Programming.pptVIP

* Column PUT Syntax: Formatted PUT Syntax: Named PUT Statement Syntax: PUT variable start-column -- end-column @ | @@; PUT pointer-control variable format. @ | @@; PUT pointer-control variable= format. @ | @@; * FILE Statement Specifies the current output file for PUT statements Syntax file-specification : external-file‘: specifies the physical name of an external file fileref :specifies the fileref of an external file. log: a reserved fileref that directs the output that is produced by any PUT statements to the SAS log print fileref(file) FILE file-specification options * Options DELIMITER= quoted string‘ : specifies an alternate delimiter (other than blank) to be used for LIST output. It is ignored for other types of output (formatted, column, named). Example data _null_; set tmp.demog; file c:\ABC\demog.txt delimiter=|; put subjid races age sex smoke ht wt; run; * MOD :writes the output lines after any existing lines in the file. data _null_; file c:\ABC\demog.txt delimiter=|; subjid races=WHITE; age=50; put subjid races age; run; data _null_; file c:\ABC\demog.txt mod delimiter=|; subjid races=BLACK; age=75; put subjid races age; run; * * Content Variable Attributes Reading SAS Data Sets Creating, Dropping and Keeping Variables Conditional Processing Advance: How to Write Lines to an External File (Self-study) Exercise * Exercise 1 – LOCF (Vertical) LOCF (Last Observation Carry Forward) is a generally used method to impute missing values in clinical trials. We have a raw data file LOCF.txt under the directory C:\ABC\case_study. After reading in as SAS dataset, it look likes below. We need to replace the missing values with previous non-missing value within each SUBJID and VSTEST. Exercise 1 * * Exercise 2 We have an dataset under the directory C:\ABC\case_study. Following is the snapshot of it. We wan