topic How to combine numeric year and month into one column as a date format? in SAS Procedures

How to combine numeric year and month into one column as a date format?

dbwindyxiaosi — Mon, 07 Jun 2021 14:53:15 GMT

Hi guys,

My data SUMDATE is like below: I want to combine year and month into a single date column as "monyyyy" (Mar2011 as example). year and month are all numeric.

year	month	cases
2011	1	34
2011	2	44
2011	3	56
2011	4	45
2011	5	33
2011	6	44
2011	7	55
2011	8	66
2011	9	32
2011	10	52
2011	11	54
2011	12	56
2012	1	58
2012	2	60
2012	3	62
2012	4	64
2012	5	66
2012	6	68
2012	7	70
2012	8	72
2012	9	74
2012	10	76
....more lines	....	.....

What I want is like this:

date1	cases
Jan2011	34
Feb2011	44
Mar2011	56
Apr2011	45
more lines.....	......

Any help would be appreciate!!!

Re: How to combine numeric year and month into one column as a date format?

PaigeMiller — Mon, 07 Jun 2021 14:56:33 GMT

data want;
    set have;
    date1=mdy(month,1,year);
    format date1 monyy7.;
    drop year month;
run;

Re: How to combine numeric year and month into one column as a date format?

dbwindyxiaosi — Mon, 07 Jun 2021 14:59:30 GMT

Thank you!!!!