Mar 18, 2006 #1 letssas Technical User Joined Mar 18, 2006 Messages 1 Location US a dataset looks like this: obs id var1 var2 1 a 12 30 2 b 14 31 ... how to output max values of var1 and var2 with id or obs numbers using PROC means? how to do this using PROC SQL? thanks.
a dataset looks like this: obs id var1 var2 1 a 12 30 2 b 14 31 ... how to output max values of var1 and var2 with id or obs numbers using PROC means? how to do this using PROC SQL? thanks.
Mar 19, 2006 #2 ChrisW75 Programmer Joined Dec 22, 2003 Messages 727 Location AU You don't need proc means. Code: data outpt; set inpt; * either of these methods work *; maxval = max(of var1-var3); maxval = max(var1,var2,var3); run; Upvote 0 Downvote
You don't need proc means. Code: data outpt; set inpt; * either of these methods work *; maxval = max(of var1-var3); maxval = max(var1,var2,var3); run;