Getting YEAR from datadate.

[nzrdufiu]

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 · Accepted solution]

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]

Yes, it works. Thank you.

[Kurt_Bremser]

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

[nzrdufiu]

Thank you.