topic Re: Disply data by proc report in Graphics Programming

Disply data by proc report

subh — Thu, 06 Aug 2015 04:19:30 GMT

Hi,

I have one sas input table with three column(x y and z).(example below)

X Y Z

---------------------------

11 market 22

33 market 44

55 market 77

I need to display like below(In a single coumn REPORT) by proc report in ods rtf

REPORT

--------------

market

Please help me how to do the sas code for this.

Thank You.

Re: Disply data by proc report

ballardw — Thu, 06 Aug 2015 14:59:37 GMT

I'm not sure if Proc Report will let you do something like that without lots of headaches.

But this may help:

data _null_;

file print;

set have;

if _n_= 1 then put "Report"; /* I'm skipping the underline as there's enough system dependencies

I don't want to add complexity at this point*/

put x;

put y;

put z;

end;

Re: Disply data by proc report

Cynthia_sas — Thu, 06 Aug 2015 16:00:00 GMT

Hi: First of all, the SAS/GRAPH forum is not the correct place to post a PROC REPORT question. But neither PROC PRINT nor PROC REPORT would produce a report like this without restructuring the data. If the OP wants an RTF output file, then they might consider using either a program like yours or something like this for a report.

Cynthia

** Method 1 Use File PRINT ODS;

ods rtf file="c:\temp\restructure_data_null.rtf";

data _null_;

title '1) Use DATA step';

length repcol $50;

set sashelp.class(keep=name sex height);

file print ods=(variables=(repcol));

repcol = '~~~~~~~~~~';

put _ods_;

repcol = name;

put _ods_;

repcol = sex;

put _ods_;

repcol = put(height,4.1);

put _ods_;

run;

ods rtf close;

** Method 2 Use PROC REPORT;

data restruct;

length repcol $50;

set sashelp.class(keep=name sex height);

varord = 0;

repord = _n_;

varord +1;

repcol = name;

output;

varord+1;

repcol = sex;

output;

varord + 1;

repcol = put(height,4.1);

output;

run;

ods rtf file="c:\temp\restruct_report.rtf";

proc report data=restruct nowd;

title '2) Use PROC REPORT with restructured data';

column repord varord repcol;

define repord /order noprint;

define varord / order noprint;

define repcol/ display;

compute before repord / style=Header;

line '~~~~~~~~~~';

endcomp;

run;

ods rtf close;