Learning Tips for SAS
Thursday, March 20, 2008
Title, footnote, label, format, where
›
data pilotdata; infile 'D:\SAS_Data\pilot.txt'; input ID $ 1 -6 firstname $ 7 - 19 lastname $ 20 - 34 jobcode $ 35 - 41 sal...
PUT, INPUT, and SUBSTR
›
/* input() function ---------------------Convert to Numberic newVar = INPUT(oldVar, format); put() function -----------------------Conve...
Read missing values
›
/* By default - FLOWOVER; It will go next value and pick next value. This example shows missing the last two values - 3.4 and 3.5 (OUTPUT) O...
Proc Contents
›
To explore the descriptor portion of a SAS data set and list of variables and attributes Proc Contents Data = work.pilotdata; Run; Use the _...
Monday, March 17, 2008
PROC PRINT LABEL-SPLIT, WHERE
›
CONTAINS - selects observations that include ? the specified substring. where LastName ? 'LAM'; OUTPUT: (LAMBERT, BELLAMY, and ELAM ...
Saturday, March 15, 2008
PROC PRINT - NOOBS option
›
proc print data=test noobs; The PROC PRINT step prints the data set, which contains one observation and three variables. The NOOBS option su...
Thursday, March 13, 2008
Work with SAS dates and times
›
SAS Date Value - Jan. 1, 1960 SAS stores date value as numeric values while SAS date is stored as numbers. SAS stores dates and times as sin...
‹
›
Home
View web version