BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
vnreddy
Quartz | Level 8
ods _all_ close;
ods noproctitle;
                      
* Create a text file;



ods listing file = "&sas_drv.:/SASFILES/Daily.txt";
ods escapechar='^';

options nodate nonumber orientation=landscape;
* Create the contents page from the dataset using proc report;
proc report data=final nowd split='~' noheader headskip spacing=2 ls=142;
/*    List columns to be use in the report;*/
   column order_date order_code;
   define order_date/display "Date" left width = 10; 
   define 'order_code'n/display "Order_code" left spacing=2;
   run;

ods listing close;

Hi,

 

I am generating output as text file, could someone help me with options how to avoid the up arrow shown in below image. I know when the data starts in next page this arrow is coming.

I am using proc report to generate text file.

 

vnreddy_0-1664389003231.png

 

Thanks & regards,

vnreddy

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

Try adding this before your PROC REPORT step, or on the PROC statement itself, to set the page size to be as large as possible.

 

options ps=max;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

View solution in original post

5 REPLIES 5
PeterClemmensen
Tourmaline | Level 20

Show us your code 🙂

vnreddy
Quartz | Level 8
Hi,

I have included the code i am using
ballardw
Super User

And what program are you using to view that text file? That might be a "feature" of that program indicating a "continued from previous page" or similar.

vnreddy
Quartz | Level 8
Hi,

I have included program i am using
ChrisHemedinger
Community Manager

Try adding this before your PROC REPORT step, or on the PROC statement itself, to set the page size to be as large as possible.

 

options ps=max;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1010 views
  • 1 like
  • 4 in conversation