I have the following programming codes to create lags and lead value:
proc sort data=main
out=sorted; by permno fyear; run;
proc expand data=sorted out=sorted method = none;
by permno;
id fyear;
convert idiorisk = idiorisk_lag1 / transformout=(lag 1);
convert idiorisk = idiorisk_lag2 / transformout=(lag 2);
convert idiorisk = idiorisk_lag3 / transformout=(lag 3);
convert idiorisk = idiorisk_lag4 / transformout=(lag 4);
convert idiorisk = idiorisk_lead1 / transformout=(lead 1);
convert idiorisk;
run;
there is a view that ' method=none ' is not appropriate for time series data. Is that true?
i attach my data for your reference, the result looks fine.
Since you are not really doing 'expanding' per se, for your purpose, using '' method=none ' is appropriate.
Regards,
Haikuo
Since you are not really doing 'expanding' per se, for your purpose, using '' method=none ' is appropriate.
Regards,
Haikuo
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.