Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

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

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,


Accepted Solutions
Solution
‎10-11-2011 09:04 PM
Super User
Super User
Posts: 7,070

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

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

View solution in original post


All Replies
PROC Star
Posts: 7,486

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

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;

Solution
‎10-11-2011 09:04 PM
Super User
Super User
Posts: 7,070

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

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

Occasional Contributor
Posts: 13

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

Tom / Art,

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

Thanks Again,

Tom

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 148 views
  • 3 likes
  • 3 in conversation