thank you @SASKiwi very much! That resolved my problem! I appreciate your help!   ... View more

All SAS procs use row wise elimination. So unless you're running models with different variables you're going to have the same base sample every time. If any variable indicated in the PROC (not necessarily used, eg listed in CLASS but not included in MODEL) is missing a value that whole row is eliminated. ... View more

@hashman Thank you for your explanation! You also mentioned in the post that we can fill with not only single values. Let's say I want to create winsorized variables based on a set of variables at their 1st and 99 percentile. I've read each variable's 1st and 99 percentile with output. If I want to use the sasfile statement to fill values in the output file, should I first transpose it to the long format to retain values? I was using %macro and call execute for winsorizing, but I also want to try with the sasfile statement. What's your suggestion?   proc means data=mydata p1 p99; var ch_score1-ch_score100; output out =sum p1=lower1-lower100 p99=upper1-upper100; run;   ... View more

First, you have to appreciate that this is a different error message.  The cause would be something different than what happened the first time.     Second, if you ran this on sashelp.class, that confirms that the code you ran is different than what you posted.  I would check for other differences, especially a missing equal sign.  It could be on a missing equal sign when defining the macro (on the %macro cap statement), or it could be a missing equal sign when calling the macro (in the construction of the variable STRING).   ... View more

Hi, Rick,   Thank you very much for your explanation! I see where I got confused. I appreciate your patience!   ... View more