how do I read date and month to create SAS data set

[tom16]

Hi,

I have .csv file with 3 million records to create sas data set.

In this file date values are mention as following: only year and month:

1999MAY

2001JAN

2002FEB

1979DEC

how can I read this YYYYMMM date value to create SAS data set with mmddyyyy format as following:

05-01-1999

01-01-2001

02-01-2002

12-01-1979

Thanks,

[art297]

If I understand your question correctly, I think the following describes your data and a possible solution:

data have;

  input date $;

  cards;

1999MAY

2001JAN

2002FEB

1979DEC

;

data want(drop=indate);

  format date mmddyy10.;

  set have (rename=(date=indate));

  date=input(indate||"01",anydtdte19.);

run;

[Tom · Accepted solution]

You will need to read as a string and switch the year and month position.

data want ;

  input cdate $7.;

  date = input(substr(cdate,5,3)||cdate,monyy7.);

  format date mmddyy10.;

  put date ;

cards;

1999MAY

2001JAN

2002FEB

1979DEC

run;

05/01/1999
01/01/2001
02/01/2002
12/01/1979

[tom16]

Tom / Art,

Thanks for your answer. This solve my problem. program working like charm,,,,,

Thanks Again,

Tom