SAS Reporting

[75063]

Hi all,

I have a data frame as below - 

data test;
input brand $ Freq Freq1 COUNT;
datalines;
A 2 3 8
B 3 5 4
C 4 6 2
D 5 1 1
E 6 5 8
F 7 7 9
;
run;

To insert blanks at multiple locations in the observations i use this code. 

data want;
set test;
output;
if _n_=3 or _n_=5;
call missing (of _all_);
output;
run;

proc print data=want;
Run;

Is there a procedure to introduce sub headings in place of the blanks - as shown in the desired output. 

Thank you!

[75063]

If i am using this code - 

data want;
set test;
if brand ="C" or brand= "E" then do;
output;
brand = 'Title' ;Freq = .; Freq1=. ; COUNT=.;
output;
end;
else output;
run;

Then I am getting the same title 'Title' for both the observations. However, I would like to have two different titles                          ("Title1" and "Title2" ) in the two locations. 

Please suggest. 

Thank you!

[VDD]

This will give you what you are asking for.  There are better ways to do this, but here is a simple fix:

data want;

length brand $25;

set test;

if brand ="C" or brand= "E" then do;

output;

if brand = "C" then do brand = 'This is the first title ' ;Freq = .; Freq1=. ; COUNT=.; end;

else if brand = "E" then do brand = 'This is the second title ';Freq = .; Freq1=. ; COUNT=.; end;

output;

end;

else output;

run;

[75063]

Thank you for your reply. 

I have used the following to get my desired outcome.  

data test;
input brand $ Freq Freq1 COUNT;
datalines;
A 2 3 8
B 3 5 4
C 4 6 2
D 5 1 1
E 6 5 8
F 7 7 9
;
run;

data want;
if 0 then set test;
if _n_=1 then do;
call missing(of _all_);
output;
end;
set test;
output;
run;

data want2;
set want;
if brand =" " then do;
output;
brand = 'Title1' ;Freq = . ; Freq1=.; COUNT=.;
end;
if brand = "D" then do;
output;
brand = 'Title2' ;Freq = . ; Freq1=.; COUNT=.;
output;
end;
else output;
run;

However, I can see that your solution is better. Thank you again.  

[Reeza]

I posted the solution in your previous post using PROC REPORT. Please do not post your question multiple times.