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

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

tom16 — Wed, 12 Oct 2011 00:51:03 GMT

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,

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

art297 — Wed, 12 Oct 2011 01:01:04 GMT

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;

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

Tom — Wed, 12 Oct 2011 01:04:53 GMT

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

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

tom16 — Fri, 21 Oct 2011 13:42:41 GMT

Tom / Art,

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

Thanks Again,

Tom