topic SAS Date Format in SAS Programming

SAS Date Format

psrajput — Wed, 08 Jul 2020 15:11:45 GMT

Hi,

I have pulled out the date in this format:

DATE9.

And then was also able to convert into YYMMN.:

202006

But my ultimate goal is to get the following numeric date format:

20200600

That's how data is available.

Thanks in Advance.

PaigeMiller — Wed, 08 Jul 2020 15:15:00 GMT

Dates, by definition,cannot have a day of the month of 00.

So, you could add the zeros on the end via concatenating character strrings

want = cats(put(datevariable,yymmn6.),'00');

ballardw — Wed, 08 Jul 2020 15:26:56 GMT

One way to create such a dangerous value is a custom format:

proc format;
picture dayzero (default=8)
low-high = '%Y%0m00' (datatype=date)
;
run;

data _null_;
   date = '05Jun2010'd;
   put date dayzero.;
run;

but I have a suspicion that you may be leaving something out.