topic Re: COmbine two colomn group wise in SAS Programming

COmbine two colomn group wise

Tejaswini3 — Sun, 20 Nov 2022 06:55:23 GMT

I want to combine below table.

In table is as

ColA	ColB	ColC
India	Yes	15
India	No	17
Europe	Yes	13
Europe	No	20

Output should be

ColD	ColC
India
Yes	15
No	17
Europe
Yes	13
No	20

Kindly suggst SAS code

Re: COmbine two colomn group wise

Kurt_Bremser — Sun, 20 Nov 2022 08:35:46 GMT

Since a dataset with this layout is useless for further analysis work, I ask again (like in your other thread): is this supposed to be a report? And how is such a report to be distributed?

Re: COmbine two colomn group wise

Tejaswini3 — Sun, 20 Nov 2022 09:25:45 GMT

After generation of final table. Need to use report statment for report generation.

Re: COmbine two colomn group wise

Kurt_Bremser — Sun, 20 Nov 2022 13:27:39 GMT

There is no REPORT statement, but there is a REPORT procedure.

You can use PROC REPORT directly off your dataset:

data have;
input
  ColA $
  ColB $
  ColC
;
datalines;
India Yes 15
India No 17
Europe Yes 13
Europe No 20
;

proc report data=have;
column cola colb colc;
define cola / group noprint;
define colb / group;
define colc / analysis;
compute before cola / style=[textalign=l];
  line cola $8.;
endcomp;
run;