topic Re: Divide the month and year in seperate columns in SAS Programming

Divide the month and year in seperate columns

Smitha9 — Tue, 11 Oct 2022 12:59:35 GMT

Hi,
I have a dataset
DOB
10/10/2003
07/29/1980
03/26/1978

I want a data test which has a separate column of month(text) and year.
DOB month year
10/102003 October 2003
07/29/1980 July 1980
03/26/1978 March 1978

Thank you in advance

Re: Divide the month and year in seperate columns

PeterClemmensen — Tue, 11 Oct 2022 13:10:11 GMT

Try this

data have;
input DOB :mmddyy10.;
format DOB mmddyy10.;
datalines;
10/10/2003
07/29/1980
03/26/1978
;

data want;
   set have;
   month = put(DOB, monname. -l);
   year  = year(DOB);
run;