topic Re: proc print PDF 90 degree counterclockwise orientation in SAS Programming

proc print PDF 90 degree counterclockwise orientation

superbug — Fri, 28 Apr 2023 15:33:55 GMT

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!

Re: proc print PDF 90 degree counterclockwise orientation

Reeza — Fri, 28 Apr 2023 16:59:59 GMT

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

Re: proc print PDF 90 degree counterclockwise orientation

superbug — Fri, 28 Apr 2023 17:26:22 GMT

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

Re: proc print PDF 90 degree counterclockwise orientation

Quentin — Fri, 28 Apr 2023 17:32:06 GMT

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.

Re: proc print PDF 90 degree counterclockwise orientation

superbug — Fri, 28 Apr 2023 17:34:53 GMT

@Quentin Thanks for your comments.

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

Re: proc print PDF 90 degree counterclockwise orientation

Quentin — Fri, 28 Apr 2023 17:39:50 GMT

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.

Re: proc print PDF 90 degree counterclockwise orientation

Tom — Fri, 28 Apr 2023 18:26:09 GMT

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

Re: proc print PDF 90 degree counterclockwise orientation

superbug — Fri, 28 Apr 2023 18:37:40 GMT

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

Re: proc print PDF 90 degree counterclockwise orientation

Reeza — Fri, 28 Apr 2023 20:27:48 GMT

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.