Convert into date

[Aman4SAS]

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]

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]

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