topic Re: formatting from number to date in SAS Programming

formatting from number to date

Unstefan — Thu, 21 Sep 2017 13:16:51 GMT

Hello

I'm working on a data which has numeric variable in the following way.

20061213
20061213
20061213
20061214

I tried converting it in to date format by using following code.

data TEST;

set recnou.rec19sep17;

format dtmep date8. ;

where CDFPRO='P';

keep nocont cnp dtmep unpaid;

run;

I'm getting following output.

********
********
********
********
********
********
********
********
********

can any one please tell me the reason for the above output and how do I rectify the problem.

i want the date to be mm/dd/yyyy

Thank you

Re: formatting from number to date

LinusH — Thu, 21 Sep 2017 13:27:14 GMT

If you have readable dates as numeric without a format, you need to transform the values.
First use put () to a text string, ind use input() to do the conversion using a specific informat that matches your current date format.

Re: formatting from number to date

PaigeMiller — Thu, 21 Sep 2017 13:29:53 GMT

You can't format it as a date because for that to work, the number has to be a legitimate SAS date value, in other words, it must be the number of days since Jan 1, 1960. Try this UNTESTED CODE

newvar=input(put(dtmep,$8.),yymmdd8.);
format newvar date8.;

Re: formatting from number to date

Unstefan — Thu, 21 Sep 2017 13:29:12 GMT

i solve it right this

data TEST;

set recnou.rec19sep17;

DATE2 = INPUT(PUT(Dtmep,8.),yyMMDD8.);

FORMAT DATE2 MMDDYY10.;

where CDFPRO='P';

keep nocont cnp date2 unpaid;

run;