Creating lead

[SAScph]

Hi

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]

What does your data look like?

[SAScph]

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

[Kurt_Bremser]

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]

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.