topic Re: PROC TABULATE or PROC REPORT in SAS Programming

PROC TABULATE or PROC REPORT

mlogan — Tue, 31 May 2016 15:11:54 GMT

Hi All,

I am tryinh to create a report student's grade with two image at the top (school logo) and bottom (signature). Can you please suggest me if I should go for PROC REPORT or PROC TABULATE or any other option. I would appreciate if you can show me a sample code/link from internet/sas community page. Thanks.

Re: PROC TABULATE or PROC REPORT

RW9 — Tue, 31 May 2016 15:47:02 GMT

Well, you should be able to do it with eiher. My preference is to always create a dataset which looks like the output required then proc report that quite basically as then you can validated that dataset and store it etc. but that is personal preference. Look at the SAS documents on the two, and try some things out, see what your happy with.

Re: PROC TABULATE or PROC REPORT

Ksharp — Wed, 01 Jun 2016 02:24:54 GMT

It is more suited for proc report . I think Cynthia is good at making report. Maybe She could give you some advice.

Re: PROC TABULATE or PROC REPORT

Ksharp — Wed, 01 Jun 2016 02:51:56 GMT

Here is an example.

data class;
 set sashelp.class;
run;
proc sort data=class;by name sex;run;



ods _ALL_ CLOSE;
ods pdf file='/folders/myfolders/xx.pdf';
ods escapechar='~';
options nobyline nodate;
title1 '~S={preimage="/folders/myfolders/temp.png"}';
title2 'Student Report';
title3 "StudenName: #byval1     Sex: #byval2";
proc report data=class nowd;
by name sex;
column name sex age weight height;
define name/noprint;
define sex/noprint;
run;
footnote1 '_________________';
footnote2 'Signature';
ods pdf close;