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>
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.;
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.;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.