DATA Step, Macro, Functions and more

Convert into date

Reply
Super Contributor
Posts: 265

Convert into date

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

PROC Star
Posts: 7,360

Re: Convert into date

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;

Super User
Super User
Posts: 6,499

Re: Convert into date

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

Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 0 likes
  • 3 in conversation