COmbine two colomn group wise

[Tejaswini3]

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

[Kurt_Bremser]

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?

[Tejaswini3]

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

[Kurt_Bremser]

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;