topic Re: informat year and quarter in SAS Forecasting and Econometrics

informat year and quarter

econfkw — Wed, 12 Sep 2012 03:43:18 GMT

The format of my data is 199201- first quarter of 1992. How do I input it?

data raw;

infile cards;

input var1 ;

cards;

199201;

run;

What should I put after var1? Is there any SAS informat that works?

thanks

Re: informat year and quarter

Keith — Wed, 12 Sep 2012 07:59:28 GMT

There isn't a standard SAS informat for your data, so one way is to convert the existing data to an informat that SAS can read in. You will need to read Var1 as character for the SUBSTR function to work. Basically I'm just inserting a Q after the 4th number, which then puts it in the YYQ7 informat.

data raw;

infile cards;

input var1 $;

var2=input(cat(substr(var1,1,4),'Q',substr(var1,5)),yyq7.);

format var2 date9.;

cards;

199201

;

run;

Re: informat year and quarter

Tom — Wed, 12 Sep 2012 11:36:26 GMT

Or just

substr(var1,5,1)='Q';

Re: informat year and quarter

econfkw — Wed, 12 Sep 2012 12:31:45 GMT

OK. got it. No SAS informat works for 199301. I can only find yyQ.w informat. Since the original file is excel, I did it by using '&' to combine them.

How can I change the status to 'answered'?

thanks

Re: informat year and quarter

Keith — Wed, 12 Sep 2012 12:42:51 GMT

Good spot Tom, since the leading 0 for the quarter is optional.