How to join two observations? 1

[coguser17]

For example using the data set

-----------------------
_stat_ region count
-----------------------
N 123 564
MEAN 234 221
MAX 233 123
MIN 345 675
STD 765 111


How can we convert it into

---------------------------
_stat_ region count
---------------------------
N 123 564
MEAN 234 221
MAX, MIN 233,345 123,675
STD 765 111

 

[ChrisW75]

You want to use a "retain" statement. This allows you to hold values between observations. Couple this with an "output" statement to control what observations get written out.
Full doco on these is available at

http://support.sas.com/onlinedoc/913/docMainpage.jsp