topic Re: SAS DATES in SAS Programming

SAS DATES

rakeshvvv — Mon, 23 Nov 2015 15:01:00 GMT

I Have SAS dataset with the following variables. ID AND DATE IN YYYYMMDD format..

100030006 2015-10-06
100030006 2015-09-03
100030006 2015-08-19

I would like to output in the following way..with additional variable for day,month, year...

100030006 2015-10-06 6 10 2015
100030006 2015-09-03 3 9 2015
100030006 2015-08-19 19 8 2015

Can some one help on this.......

Thanks

Re: SAS DATES

RW9 — Mon, 23 Nov 2015 15:09:28 GMT

Assuming your date is actual a SAS numeric yymmdd. format variable then:

d=day(<your_date>);

m=month(<your_date>);

y=year(<your_date>);

If its not then you need:

y=year(input(<your_text_date>,yymmdd10.));

etc.

Re: SAS DATES

AbhiD — Mon, 23 Nov 2015 15:12:30 GMT

let me know if this works for you

data test;
input id dt;
attrib
dt informat = YYMMDD10. format= YYMMDD10.;
dt_day = day(dt);
dt_Mon = Month(dt);
dt_Yr = Year(dt);
datalines;
100030006 2015-10-06
100030006 2015-09-03
100030006 2015-08-19
;

run;

Re: SAS DATES

Steelers_In_DC — Mon, 23 Nov 2015 15:17:47 GMT

Here you are:

data have;
informat id $9. date yymmdd10.;
format id $9. date yymmdd10.;
input id date;
cards;
100030006 2015-10-06
100030006 2015-09-03
100030006 2015-08-19
;

data want;
set have;
day = day(date);
month = month(date);
year = year(date);
run;

Re: SAS DATES

Karansareen — Tue, 24 Nov 2015 09:20:55 GMT

Hi,

You can try the following code:

data One;
informat ID $9. date yymmdd10.;
format ID $9. date yymmdd10.;
input ID date;
cards;
100030006 2015-10-06
100030006 2015-09-03
100030006 2015-08-19
;
run;

data Result;
set one;
day = day(date);
month = month(date);
year = year(date);
Desired_Result=catx(' ',day,month,year);
run;
proc print;
run;