this worked well, Mike, thank you. best, Brent ... View more

Thank you, Peter, that worked well. -Brent ... View more

Brent,  Tom was clearly first, deserved the correct answer tag, and I have more than enough points as it is.  I was simply offering a way to accomplish the task of passing values from one's code to a macro as that question gets asked repeatedly.  Regardless, thanks for the recognition. ... View more

Hi ... the default behavior of PROC MEANS (and SUMMARY) is to ignore missing values for variables in a CLASS statement (both numeric and character).  So, a WHERE data set option is not needed to leave out observations with missing IDs.  You have to be proactive to have missing CLASS values included ... data x; input id x @@; datalines; 1 10 1 20 2 20 2 30 . 40 . 50 ; run; proc means data=x noprint nway; class id; var x; output out=y mean=x_mean; run; proc means data=x noprint nway missing ; class id; var x; output out=z mean=x_mean; run; DATA SET Y: NO MISSING OPTION id    _TYPE_    _FREQ_    x_mean 1       1         2        15 2       1         2        25 DATA SET Z: MISSING OPTION ADDED id    _TYPE_    _FREQ_    x_mean .       1         2        45 1       1         2        15 2       1         2        25 ps  If the object is to produce a data set, why not just use SUMMARY where NOPRINT is the default  ... proc summary data=x nway; class id; var x; output out=y mean=x_mean; run; ... View more