Help using Base SAS procedures

prepare YEAR for interpolation

Reply
Super Contributor
Posts: 395

prepare YEAR for interpolation

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.

Super Contributor
Posts: 1,636

prepare YEAR for interpolation

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;

Super Contributor
Posts: 395

Re: prepare YEAR for interpolation

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

Super Contributor
Posts: 1,636

Re: prepare YEAR for interpolation

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;

Ask a Question
Discussion stats
  • 3 replies
  • 100 views
  • 0 likes
  • 2 in conversation