topic Getting YEAR from datadate. in SAS Data Management

Getting YEAR from datadate.

nzrdufiu — Sun, 28 Aug 2016 19:57:52 GMT

I have datasets as follows:

GVKEY DATADATE

0111 19740131

0111 19740231

0111 20150131

I want to create new variables--year and month from the datadate. What would be the code both in data step and in proc sql?

Thank you.

Shmuel — Sun, 28 Aug 2016 20:14:46 GMT

In case DATADATE is a character variable do:

year = input(substr(datadate,1,4),4.);

month = input(substr(datadate,5,2),2.);

In case the variable is numeric do:

year = int(datadate/10000);

or year = input(substr(put(datadate,8.),1,4),4.);

month = input(substr(put(datadate,8.),5,2),2.);

in case datadate is a date variable with predefined format of yymmdd8. then

year = year(datadate);

month = month(datadate);

nzrdufiu — Mon, 29 Aug 2016 02:21:04 GMT

Yes, it works. Thank you.

Kurt_Bremser — Mon, 29 Aug 2016 06:38:05 GMT

Please mark your question as solved (accept @Shmuel's post as solution)

nzrdufiu — Fri, 10 Feb 2017 03:20:55 GMT

Thank you.