Date Conversion

[gnrslasher37]

Hi,

i have the date in 20070102 numeric format, i want this into SAS format so that i get the month out of this date. I am happy to

know if there is another way as well without first formatting into SAS.

Thanks.

[KachiM]

I guess you want first to change the numeric to SAS date and then get the MONTH from the SAS date. Here is one way.

data _null_;
dt =  20070102;
date = input(put(dt,8.),yymmdd10.);
month = month(date);
put date = month =;
run;

[Tom · Accepted solution]

If you have the number 20,070,102 and you want to treat the digits from the hundreds and thousands place as a month then just use some arithmetic to get the value.

data x;
  input number comma10.;
  month = mod(int(number/100),100);
  put (number month) (=);
cards;
20,070,102
20131201
;