I was able to implement this and it worked! Thanks to all for the suggestions and @Tom for the ultimate solution, they were helpful to me learning how to use the macro language in my analyses!
... View more
Sure sounds like you are trying to accomplish something like:
proc summary data=fam (where=(kid eq 1));
var tot_recom non_recom;
by pedid;
output out=want (drop=_:) sum=;
run;
Art, CEO, AnalystFinder.com
... View more
