topic Re: Proc Print doesn't produce any results except a title in SAS Programming

Proc Print doesn't produce any results except a title

GN0001 — Wed, 10 May 2023 23:23:25 GMT

Proc report Data=libname.thisdata NOWINDOWS Headline headskip;
column id  LNAME FNAME BIRTH_DATE GENDER group status;
Define group/ Group 'Grouped by something';
BREAK AFTER PROV_ID/ summarize OL SKIP;
RBREAK AFTER/ SUMMAIZE OL SKIP;
Define status/ Across;
TITLE 'today title';
run;

Hello team,

This code does not give any errors, but it doesn't provide any results either. It only displays title in the result tab of SAS eg 7.0.

Regards,

Blue blue

Re: Proc Print doesn't produce any results except a title

SASKiwi — Wed, 10 May 2023 23:51:34 GMT

Please note the misspelling in this statement:

RBREAK AFTER/ SUMMAIZE OL SKIP;

Did you check your SAS log for errors? SUMMAIZE should be SUMMARIZE.

Re: Proc Print doesn't produce any results except a title

Tom — Thu, 11 May 2023 02:31:17 GMT

Also how can you

BREAK AFTER PROV_ID/ summarize OL SKIP;

When PROV_ID is not listed in the COLUMN statement?

Re: Proc Print doesn't produce any results except a title

ballardw — Thu, 11 May 2023 16:08:33 GMT

Why is the subject "Proc Print" when the code shown is "Proc Report"?

Where is LOG. Just because it doesn't show errors the log still is likely to show something about why no output is generated. So include the LOG with ALL the code, notes and messages associated with the procedure call.

Nothing like seeing something like this to clarify why no output was generated:

26
27   proc report data=junk;
28   run;

NOTE: No observations in data set WORK.JUNK.
NOTE: No observations in input data set.

Run a report on an empty set => empty report.

So, show the log.