proc print PDF 90 degree counterclockwise orientation

[superbug]

 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]

Isn't that portrait orientation but it'll show as upright in PDF but print as desired?

[superbug]

@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.

Thanks!

[Quentin]

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.

[superbug]

@Quentin Thanks for your comments.

The desired format was produced by another software. I need to replicate the results using SAS.

[Quentin]

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.

[Tom]

---

@superbug wrote:

@Quentin Thanks for your comments.

The desired format was produced by another software. I need to replicate the results using SAS.

---

Why would you want to replicate a mistake?

[superbug]

@Tom It is not a mistake. Once SAS produce the desired format, it will replace the other software. 

[Reeza]

The format is desired when printed, Adobe just displays it for the viewer more appropriately. If the intent is to print out the report it will meet requirements. If the intent is for viewable data online then push back and have the requirement to be updated to make sense.