id option not working in proc report

thanikondharish — Fri, 13 Dec 2019 17:15:37 GMT

ods rtf file='D:\harish_resume\testing.rtf' ;
proc report data=sashelp.cars nowd;
column origin make type msrp ;
define origin/id order ;
run;
ods rtf close ;

after generating rtf file first page has origin value but next page hasn't origin value .

id : should print every page

Re: id option not working in proc report

ballardw — Fri, 13 Dec 2019 18:35:38 GMT

The ID option comes into play when you have more columns than will normally fit on a page. The ID variables are then duplicated for the extended rows so you can identify which row is extended into a another "block" of table output.

Consider the output of from this:

ods rtf file='D:\harish_resume\testing.rtf' ;

proc report data=sashelp.cars nowd
  colwidth =15 ;
define origin/id order ;
run;
ods rtf close;

Which will have the output for all of the variables and the width will exceed the width of a page. So the all of the tables with the first variables will be displayed and then the extended output will appear afterwards with continued variables.

Since the ID variable is Origin and the default order of the data without a columns statement has Make, Model and Type appear to the left of the ID variable all of those are repeated. From the documentation for ID:

An ID variable and all columns to its left appear at the left of every page of a report. ID ensures that you can identify each row of the report when the report contains more columns than fits on one page.

You likely don't want an ID variable as an order variable due to the way order variables are used.

I am not sure what you are attempting to accomplish. Maybe you want a PAGE variable??

Re: id option not working in proc report

Ksharp — Sat, 14 Dec 2019 10:08:09 GMT

Generally , ID option is company with PAGE option .

proc report data=sashelp.cars(obs=10) nowd;
column origin make type msrp ;
define origin/id order ;
define msrp/display page;
run;

topic id option not working in proc report in SAS Programming

id option not working in proc report

Re: id option not working in proc report

Re: id option not working in proc report