Hi all,
Today, after using proc expand to generate a variable, afterwards, I receive the note that the created variable is uninitialized.
The code is
proc expand data=agg_amihud_ew method=none;
convert _FREQ_=lag_freq / transformout= (lag 1);
run;
data agg_amihud_ew_f;
set agg_amihud_ew;
agg_amh_ew_final=agg_amh_ew_country*_FREQ_/lag_freq;
run;
The note is
28 proc expand data=agg_amihud_ew method=none; 29 convert _FREQ_=lag_freq / transformout= (lag 1); 30 run; NOTE: The data set WORK.DATA18 has 127 observations and 7 variables. NOTE: PROCEDURE EXPAND used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 31 32 data agg_amihud_ew_f; 33 set agg_amihud_ew; 34 agg_amh_ew_final=agg_amh_ew_country*_FREQ_/lag_freq; 35 run; NOTE: Variable lag_freq is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 7 at 34:37 120 at 34:44
When I read the log, I see it is because the proc expand creates a new dataset (DATA18) having different name with the original one(agg_amihud_ew), Could you please help me to sort it out (force PROC EXPAND create the new dataset replace the original one with the same name)?
Warm regards.
As always, read the documentation
You need to use the OUT= option to set the name of the output dataset.
As always, read the documentation
You need to use the OUT= option to set the name of the output dataset.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.