Using the character variable you do have PERIOD, assign an arbitrary SAS DATE variable, using the INTNX function supplying the numeric portion of your PERIOD value as the third argument - choose a starting date, possibly at the beginning of the current year: Some sample code is provided below, for illustration.
data _null_;
format StartDate yymmdd10.;
StartDate = INTNX('year',today(),0);
PdArg3 = Input( Substr('P2',2) , 2.); /* create INTNX third arg to increment date */
Attrib SamplePdStartDate format=yymm7. label='Time ID DATE var';
SamplePdStartDate = INTNX('month',StartDate,PdArg3);
putlog _all_;
run;
Scott Barry
SBBWorks, Inc.
Suggested Google advanced search argument, this topic/post:
+"enterprise guide" +"time id" +date +forecasting site:sas.com