topic Date Conversion in SAS Programming

Date Conversion

gnrslasher37 — Sat, 09 Jul 2016 09:22:22 GMT

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.

Re: Date Conversion

KachiM — Sat, 09 Jul 2016 11:39:39 GMT

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;

Re: Date Conversion

Tom — Sat, 09 Jul 2016 11:56:38 GMT

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
;