topic Re: Transpose and summarizing data with SAS SQL in SAS Programming

Transpose and summarizing data with SAS SQL

Agent1592 — Sun, 15 Jan 2017 21:22:18 GMT

I have the following table:

How do I summarize the data so I have one row per ID (want table).

art297 — Sun, 15 Jan 2017 21:32:24 GMT

Do you need to do it using proc sql? Proc transpose was made for such tasks:

proc transpose data=have out=want (drop=_:);
by id;
id type;
var ratio;
run;

HTH,

Art, CEO, AnalystFinder.com

Agent1592 — Sun, 15 Jan 2017 22:31:05 GMT

Thank you art.