topic Re: Time series in SAS Programming

Time series

dennis_e — Tue, 22 May 2018 15:21:51 GMT

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.

Re: Time series

novinosrin — Tue, 22 May 2018 15:32:49 GMT

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;

Re: Time series

novinosrin — Tue, 22 May 2018 15:30:57 GMT

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;

Re: Time series

dennis_e — Tue, 22 May 2018 15:51:26 GMT

Thank you -- Can't wait to try this later.

Re: Time series

PGStats — Tue, 22 May 2018 19:10:33 GMT

If yearMonth is a number then convert to a SAS date with

ymDT = mdy(mod(YearMonth,100), 1, int(YearMonth/100));
format ymDT yymmd.;

Re: Time series

dennis_e — Thu, 24 May 2018 17:54:30 GMT

Thank you.