The code below provide me landscape orientation
options orientation=LANDSCAPE topmargin=0.25in bottomargin=0.25in rightmargin=0.25in leftmargin=0.25in; ods listing close; ods pdf file="....\Result_SAS.pdf" ; proc print data=summary noobs; id pd; by id ; var v1 v2 v3; pageby id; run; ODS pdf close; ods pdf; run;
use the code above, I got the table presented as below in PDF
But I need the table in the produced PDF show as in the picture below
Any help would much appreciated!
@Reeza Thanks much for looking into my question!
The desired is when you view an portrait orientation table after 90 degree counterclockwise rotation.
I opened the PDF generated using the code in Adobe. In view-->rotation view-->counterclockwise, I got the desired format.
I am wondering how to get the desired format using SAS.
I don't see a way to do this. But it also seems like an unusual thing to want to do.
I think the output you want is landscape, but rotated as you say so that when you view it in a PDF viewer, it is sideways.
If you're viewing this on a screen, why would you want to view it sideways, instead of as a landscape page? Note also that most PDF viewers have a rotate option, so user would be able to rotate it as they like. Similar to how if you print a hard copy, you can rotate it however you like.
You might want to submit a ballot item (https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas) to suggest SAS add an option to allow perhaps a rotation argument for the ORIENTATION option.
You might need to consider writing the PDF from SAS, with the desired table in landscape, and then using a PDF editor to rotate the page. Adobe has a free web tool: https://www.adobe.com/acrobat/online/rotate-pdf.html
Hopefully someone else will know a good SAS-only solution.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.