topic Re: SAS Reporting in SAS Programming

SAS Reporting

75063 — Fri, 31 Aug 2018 03:43:14 GMT

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!

Re: SAS Reporting

75063 — Fri, 31 Aug 2018 03:32:59 GMT

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!

Re: SAS Reporting

VDD — Fri, 31 Aug 2018 04:25:13 GMT

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;

Re: SAS Reporting

Reeza — Fri, 31 Aug 2018 04:32:06 GMT

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

Re: SAS Reporting

75063 — Fri, 31 Aug 2018 16:50:28 GMT

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.