Is there an easy way to convert a combined year and month value to a SAS DATE?
I have the following data, and wanted to use some of the SAS Time Series methods
There is a number for year, but it also has a two digit number for month combined. The data are in an Excel format.
Here is asample of the data:
The first variable is January in the year 1895. PCP is the total precipitation for that month.
YearMonth PCP
189501 6.89
189502 2.94
189503 5.66
|
The data go up to December 2017.
I would like to be able to total up all the PCP for a year, plot it -- then plot the next year’s total PCP, etc all the way up to 2017.
may this demo help? Mind you! ---The sasdate value will revert to first of the month though
data have;
input YearMonth PCP;
cards;
189501 6.89
189502 2.94
189503 5.66
;
data want;
set have;
k=put(YearMonth,8. -l);
sasdate=input(k,yymmn6.);
format sasdate date9.;
run;
or just:
data have;
input YearMonth PCP;
cards;
189501 6.89
189502 2.94
189503 5.66
;
data want;
set have;
sasdate=input(put(YearMonth,8. -l),yymmn6.);
format sasdate date9.;
run;
If yearMonth is a number then convert to a SAS date with
ymDT = mdy(mod(YearMonth,100), 1, int(YearMonth/100));
format ymDT yymmd.;
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.