Add a Column of months to time series data set

[Kboukaabar]

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>

[Astounding · Accepted solution]

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.;