topic Re: Add a Column of months to time series data set in Statistical Procedures

Add a Column of months to time series data set

Kboukaabar — Thu, 01 Feb 2018 04:28:52 GMT

I have a time series data set in excel, 60 rows, that I uploaded in SAS On Demand Studio. I need to add a column for months containing Jan through Dec. Since 60 months, it means 5 years which means each month has to be written 5 times. For example Jan at 1st row, then at 13th row, etc...and on. I could go back to my excel file and do it and then upload into SAS the newly modified file. I wonder if I could do this within SAS without deleting, modifying and uploading>

Re: Add a Column of months to time series data set

Astounding — Thu, 01 Feb 2018 06:05:12 GMT

It's almost certain that you would be better off constructing MONTH as a numeric variable taking on values 1 through 12. That's fairly easy:

data want;

set have;

month + 1;

if month = 13 then month = 1;

run;

If you want to print MONTH, and see it in a different form, you can always create a format.

proc format;

value mm 1='Jan' 2='Feb' 3='Mar' 4='Apr' 5='May' 6='Jun' 7='Jul' 8='Aug' 9='Sept' 10='Oct' 11='Nov' 12='Dec';

run;

Then when printing, apply the format:

format month mm.;