topic Convert into date in SAS Programming

Convert into date

Aman4SAS — Sat, 09 Nov 2013 19:29:54 GMT

can anyone suggest me how can i store it as date or number..

even when i export it in excel still its having prob.

please suggest

data test;

x="M02";

y=2000;

z=strip("01"||"/"||strip(substr(x,2,3))||"/"||trim(put(y,best4.)));

run;

looking for z variable as a date or number

art297 — Sat, 09 Nov 2013 20:08:07 GMT

Functions are your friends .. learn about as many of them as you can. e.g.:

data test;

format z date9.;

x="M02";

y=2000;

z=mdy(input(substr(x,2,3),2.),1,y);

run;

Tom — Sat, 09 Nov 2013 23:08:19 GMT

INFORMATs are fun also.

data test;

x="M02";

y=2000;

z=input(cats(y,substr(x,2)),yymmn6.);

format z date9.;

put (_all_) (=/);

run;

x=M02

y=2000

z=01FEB2000