topic How to covert MMM YYYY to iso format? in SAS Programming

How to covert MMM YYYY to iso format?

DmytroYermak — Mon, 21 May 2018 09:55:09 GMT

Hi all,

Could you please advise how to convert mmm yyyy into iso format.

data have;
  input cdate $10.;
  datalines;
Mar 2017
;
run;

I badly need the date in iso format: 2017-03

Thank you!

Re: How to covert MMM YYYY to iso format?

jklaverstijn — Mon, 21 May 2018 11:40:07 GMT

If you want to keep your date as a character value than this would do the trick:

length sdate $8;
sdate=put(input(cdate, monyy8.), yymmd8.);

The SAS ISO formats always display the date. In your specific case it looks like you can get away with a more common date format.

In general I would recommend to read up on how SAS deals with dates as they are usually stored as numeric values and formatted in a desired form when presenting the value in a report or such. A good start would be the online docs.

Hope this helps,

-- Jan

Re: How to covert MMM YYYY to iso format?

BrunoMueller — Mon, 21 May 2018 12:44:51 GMT

I suugest to use the ANYDTDTE informat, this will give you a SAS date value, that can be used for many things, see example below

data have;
  input 
    @1 cdate $10.
    @1 sasDate anydtdte.
  ;
  
  sasDate2 = sasDate;
  
  format sasDate yymmd7. sasDate2 date9.;
  datalines;
Mar 2017
;
run;

Re: How to covert MMM YYYY to iso format?

DmytroYermak — Mon, 21 May 2018 13:05:59 GMT

Thank you, Jan! I did not find the monyy8. format, now I will be aware.

Re: How to covert MMM YYYY to iso format?

DmytroYermak — Mon, 21 May 2018 13:08:32 GMT

Thank you, Bruno. The same with anydtdte. format ) - I never heard. This forum is really useful.