Date-Format: yyyy

[Konkordanz]

Hi,

I want to import a date-column that contains the year (yyyy). How is it possible, to import this data with a date format instead of this char-format? Thank you for helping me!

data test;
FORMAT                
year $CHAR22.;

input year ;
datalines;
[...]

[Kurt_Bremser · Accepted solution]

Just remove the FORMAT statement. SAS will automatically read this as numeric. To make a SAS date value out of it, you have to use the MDY function and decide which day of the year you want to assume.