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
Please note the misspelling in this statement:
RBREAK AFTER/ SUMMAIZE OL SKIP;
Did you check your SAS log for errors? SUMMAIZE should be SUMMARIZE.
Also how can you
BREAK AFTER PROV_ID/ summarize OL SKIP;
When PROV_ID is not listed in the COLUMN statement?
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.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.