## Date Conversion

Solved
Occasional Contributor
Posts: 12

# Date Conversion

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.

Accepted Solutions
Solution
‎07-10-2016 04:19 AM
Super User
Posts: 8,115

## Re: Date Conversion

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
;``````

All Replies
Super Contributor
Posts: 324

## Re: Date Conversion

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;``````

Solution
‎07-10-2016 04:19 AM
Super User
Posts: 8,115

## Re: Date Conversion

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
;``````
☑ This topic is solved.