Proc SQL: Combine Multiple Row Values into One

[Agent1592]

I have the following data: How can I collapse these two rows into 1 using the SQL procedure:

ID	Type	Rate	Amt	Trend	event	final	carryover	comment
1	A	2						Text1
1	B	0.7		decreasing	0.625			Text2

[LinusH]

Why limit yourself to SQL?
Also how do you want to collapse since there are different values in the same column?
Pls provide a want data set.

[Agent1592]

I do not necessarily need SQL. I just want to count the number By Type: This is my want table.

ID	Count Number of Type
1	2

[PeterClemmensen · Accepted solution]

Like this?

data have;
   input ID Type $ Rate Amt $ Trend :$20. event	final	carryover comment $;
   infile datalines dlm = ',';
   datalines;
1,A,2  , ,          , , ,     ,Text1
1,B,0.7, ,decreasing, , ,0.625,Text2
;

proc sql;
   create table want as
   select ID
         ,count(ID) as Count label = 'Count Number of Type'
   from have
   group by ID;
quit;

[PeterClemmensen]

I agree with @LinusH, but if you absolutely have to do this in sql you have to make the decision of what value you want in eg Type and Rate? 🙂