topic Re: prepare YEAR for interpolation in SAS Procedures

prepare YEAR for interpolation

podarum — Wed, 14 Dec 2011 15:54:46 GMT

I'm trying to make YEAR (eg. 2007) as a year so I can use it in proc expand for interpolation. doing YEAR YEAR4.; just converts it to a sas date year.. I want it to be left as 2007 as a date.

prepare YEAR for interpolation

Linlin — Wed, 14 Dec 2011 16:06:07 GMT

Do you want something like this?

data have;

informat date mmddyy10.;

format date mmddyy10.;

input date;

year=year(date);

cards;

12/10/2011

12/11/2010

12/10/2009

;

proc print; run;

Re: prepare YEAR for interpolation

podarum — Wed, 14 Dec 2011 16:41:28 GMT

All I have in the cards is :

cards;

2011

2010

2009

;

Do I create a mock MONTH and mock DAY .. remember I need to intrapolate.

Thanks

Re: prepare YEAR for interpolation

Linlin — Wed, 14 Dec 2011 17:01:12 GMT

Do you want something like this?

data have;

format date mmddyy10.;

input year;

date=mdy(1,1,year);

cards;

2011

2010

2009

;

proc print; run;