topic Re: Creating lead in New SAS User

Creating lead

SAScph — Mon, 13 Apr 2020 08:21:06 GMT

I want to create a lead for next days observations in my varmax model. Not for forecasting but for predicting. How can this be done?

PeterClemmensen — Mon, 13 Apr 2020 08:37:04 GMT

What does your data look like?

SAScph — Mon, 13 Apr 2020 08:59:03 GMT

its daily visitors and weather variables. I want to see if next days weather can determine next days visitors

Kurt_Bremser — Mon, 13 Apr 2020 09:01:03 GMT

Post a data step with datalines that reflects your dataset. Tell us which variables need to get a lead, and under what criteria (groups?)

Astounding — Mon, 13 Apr 2020 16:11:17 GMT

Since you've provided the idea of what your data looks like, I can provide the idea of what the program would look like.

data want;
   set have;
   set have (firstobs=2 keep=visitors weather rename=(visitors=nextday_visitors weather=nextday_weather));
run;

Since the final observation has no values for "next day", it should be thrown out. This program happens to accomplish that.