data
ex1; input x y z $ age date;
datalines; 1 2 hello 13 10/21/1946
4 5 ARRIVEDERCI 56 11/12/1997
-9999 . goodbye 69 11/12/2007
;
run; proc print data=ex1; run;
***没有informat: sas 不懂10/21/1946是一个日期值, 所以date variable全是missing***;
data
ex2; input
x y z $ age date; informat
date mmddyy10.; datalines
; 1 2 hello 13 10/21/1946
4 5 ARRIVEDERCI 56 11/12/1997
-9999 . goodbye 69 11/12/2007
;
run
; proc
print data=ex2; run; ***使用informat后, DATE has values, but these values are numbers, 看起来难看;
data ex3; input x y z $ age date;
informat date mmddyy10.; format
date yymmdd10.; datalines
; 1 2 hello 13 10/21/1946
4 5 ARRIVEDERCI 56 11/12/1997
-9999 . goodbye 69 11/12/2007
; run
; proc
print data=ex3; run; ***INFORMAT can also help you modify the length of charaters and change -9999, -999 as missing values.
***FORMAT can help you print the age not like 13, 56, 69 but 'Young', 'Old', 'Old'; Please see my next post.