topic Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format in SAS Programming

SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

adrfinance — Thu, 21 Nov 2019 13:28:18 GMT

I have a variable called qy that looks like:

2008 Q1
2008 Q1
2009 Q2
2009 Q2
2009 Q3
2009 Q4
2009 Q4
2009 Q4

How can I set it in proper SAS format?

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

PeterClemmensen — Thu, 21 Nov 2019 13:30:35 GMT

What do you consider a 'proper' SAS format?

Also, is this a character variable?

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

adrfinance — Thu, 21 Nov 2019 13:34:14 GMT

How do I view whether it is a character variable?

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

PeterClemmensen — Thu, 21 Nov 2019 13:35:51 GMT

in the "Alphabetic List of Variables and Attributes" section of the output from

proc contents data=YourDataSetHere;
run;

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

adrfinance — Thu, 21 Nov 2019 13:37:18 GMT

It says it is a character

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

PeterClemmensen — Thu, 21 Nov 2019 13:43:03 GMT

Ok. Do like this then

data have;
input qy $&;
datalines;
2008 Q1
2008 Q1
2009 Q2
2009 Q2
2009 Q3
2009 Q4
2009 Q4
2009 Q4
;

data want;
    set have;
    dt=input(compress(qy), yyq7.);
    format dt date9.;
run;

Result:

qy      dt
2008 Q1 01JAN2008
2008 Q1 01JAN2008
2009 Q2 01APR2009
2009 Q2 01APR2009
2009 Q3 01JUL2009
2009 Q4 01OCT2009
2009 Q4 01OCT2009
2009 Q4 01OCT2009

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

adrfinance — Thu, 21 Nov 2019 13:44:58 GMT

My initial dataset has over 8000 rows but when I run your code it gets reduced to only 10 rows.. Why is this the case? How can I fix it?

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

PeterClemmensen — Thu, 21 Nov 2019 13:46:37 GMT

What does your log say?

Re: SAS - set quarter/year (written in YYYY QQ format) in proper SAS format

ballardw — Thu, 21 Nov 2019 17:45:07 GMT

@adrfinance wrote:

My initial dataset has over 8000 rows but when I run your code it gets reduced to only 10 rows.. Why is this the case? How can I fix it?

Copy the code with the messages from the LOG. Paste into a code box opened on the forum using the {I} icon.

Why? Need code and info that will be in the log.