Grouping rows

[Saleem]

Hi Team,

I have data set called Test in this data set we have many column but I need Few column Total.

IDMs                     Total Suppliers                 Bank data complete 

Not Required        1277                                No                   22,830

One IDM                   70                               Yes                     1699

Two IDMs           23,115                               Total                   24,529

Zero IDMs                 67

Total                    24,529

could you please help me how to create this data sets.

Thanks in advance

[LinusH]

So your data set to left is what you have?

It looks like a report. Try to get hold of the original/underlying data.

As general tip: you could probably make use of user defined formats.

You apply them in your report program (like PROC REPORT or PROC TABULATE) and it will group your rows "automatically".

https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/236-29.pdf

[PaigeMiller]

This looks more like an Excel file than a SAS data set. In a SAS data set, there would be the same number of rows for each column.

Can you please actually SHOW US the SAS data set as it appears on your screen? (In this case, a screen capture is fine)