You can easily do that in PROC REPORT using a COMPUTE statement with a GROUP variable, once you manage to get it in the correct location in your data set, which was your original question. Has that been resolved?
If yes, here's an example from a previous question a few weeks ago.
data test;
infile cards truncover;
input GROUP_VAR $ brand $ Freq Freq1 COUNT;
datalines;
SUB1 A 2 3 8
SUB1 B 3 5 4
SUB1 C 4 6 2
SUB2 D 5 1 1
SUB2 E 6 5 8
SUB2 F 7 7 9
;
run;
proc tabulate data=test;
class group_var brand / order=data missing;
var freq freq1 count;
table group_var=''*brand='', freq*sum='' freq1*sum='' count*sum=''/misstext='';
run;
proc report nowd data=test;
col group_var brand freq freq1 count;
define group_var / group noprint format=$8.;
define brand/order;
define freq/ sum;
define freq1 / sum;
define count / sum;
break before group_var / skip;
compute before group_var/
style={cellheight=8pt font_size=12pt just=left};
line group_var $100.;
endcomp;
run;
@sams54156 wrote: Hi Astounding , Thanks for the reply . Yes I my program is Producing output like Product Object Type Attribute Should_Be Actual Baseline Product1 SAMPLE1 FLAT 56 TESTED TESTED NO SAMPLE2 FLAT 22 NONTESTED TESTED NO SAMPLE3 OVAL 32 TESTED TESTED YES But I am still trying to produce an output like Product Object Type Attribute Should_Be Actual Baseline Product1 SAMPLE1 FLAT 56 TESTED TESTED NO Product1 SAMPLE2 FLAT 22 NONTESTED TESTED NO Product1 SAMPLE3 OVAL 32 TESTED TESTED YES I am able to store “product1” in a variable but in proc print it gets printed as first observation instead I want its get printed before all observation not as a separate observation .
... View more