topic correct SAS informat for dates of the form YYYYMMDD? in SAS Programming

correct SAS informat for dates of the form YYYYMMDD?

mediaeval — Mon, 28 Jan 2013 12:02:05 GMT

I have dates stored in a numeric variable of the form YYYYMMDD, with no separator between the day month and year parts. An example is 20090629. I wish to store it in a SAS date field. I am using the following line:

xPolSD = Input(PolSD,yymmddn8.);

but which is giving me an error. I have also tried using

xPolSD = Input(PolSD,yymmdd8.);

which also gives an error.

What is the correct SAS informat to use in this instance?

Re: correct SAS informat for dates of the form YYYYMMDD?

LinusH — Mon, 28 Jan 2013 12:28:07 GMT

You need to put your date first, so it becomes a string.

Re: correct SAS informat for dates of the form YYYYMMDD?

Jagadishkatam — Mon, 28 Jan 2013 12:48:46 GMT

As @Linus rightly suggested please convert the numeric value to character and try the below code

data have;

date="20090629";

new_date=input(date,yymmdd8.);

format new_date date9.;

run;

Thanks,

Jagadish

Re: correct SAS informat for dates of the form YYYYMMDD?

LinusH — Mon, 28 Jan 2013 13:07:14 GMT

I think you are confusing Mediaeval by treating the date as a constant, not as a column

Re: correct SAS informat for dates of the form YYYYMMDD?

Jagadishkatam — Mon, 28 Jan 2013 13:19:08 GMT

Thank you for your feedback.

hope the below code will be more understandable

data have;

input date $;

new_date=input(date,yymmdd8.);

format new_date date9.;

cards;

20090629

;

run;

Thanks,

Jagadish