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,
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
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;
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
Tom / Art,
Thanks for your answer. This solve my problem. program working like charm,,,,,
Thanks Again,
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.