SAS Date Format

[psrajput]

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 · Accepted solution]

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]

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.