topic Re: Proc SQL: Combine Multiple Row Values into One Column/Row in New SAS User

Proc SQL: Combine Multiple Row Values into One Column/Row

RRRR5 — Sun, 14 Oct 2018 08:48:21 GMT

Hi All,

This should be pretty simple but I'm having difficulty figuring it out.

I have the following input :

and required output in following format.

Any help would be appreciated!!!

Thanks!

Kurt_Bremser — Sun, 14 Oct 2018 09:25:39 GMT

Start with

proc transpose
  data=have
  out=want
;
by id;
id type;
var amount count;
run;

and see how far that gets you.

Kurt_Bremser — Sun, 14 Oct 2018 09:28:10 GMT

Note that a wide dataset will be a PITA in further processing. See Maxim 49.