BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Hi ,

Can you guys please help me out how to set the page size of an excel sheet using ods tagsets.excelxp options

and can you please tell me what is the default size of a page using ods tagsets.excelxp.

ex:

If the default page size is A3 and i what it to be changed to A4...

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

Hi:

  This worked for me. See screen shot. Then use DOC='HELP' info in log to set margins, headers, etc.

cynthia

options papersize='A4';

  

ods tagsets.excelxp file='c:\temp\want_a4.xml' style=sasweb
    options( Sheet_name = 'wantA4' Orientation = 'landscape' doc='help');

proc report data=sashelp.class(obs=5) nowd;
  column name age sex height;
run;

ods _all_ close;


want_a4_inside_excel.png

View solution in original post

4 REPLIES 4
Cynthia_sas
SAS Super FREQ

Hi:

  This worked for me. See screen shot. Then use DOC='HELP' info in log to set margins, headers, etc.

cynthia

options papersize='A4';

  

ods tagsets.excelxp file='c:\temp\want_a4.xml' style=sasweb
    options( Sheet_name = 'wantA4' Orientation = 'landscape' doc='help');

proc report data=sashelp.class(obs=5) nowd;
  column name age sex height;
run;

ods _all_ close;


want_a4_inside_excel.png
krishnaboosireddi
Calcite | Level 5

Thanks for your help and its working..........

boschy
Fluorite | Level 6

Here at my site we set OPTIONS PAGESIZE = 'ISO A4' in the SAS autoexec program, because the default is 'LETTER', a US paper size standard.

We shouldn't have to because the locale should default it to A4 (non-US). No matter...setting it explicitly avoids problems between platform and SAS version upgrades. 8-)

ScottBass
Rhodochrosite | Level 12

I assume you mean OPTIONS PAPERSIZE:

1    OPTIONS PAGESIZE = 'ISO A4';

             --------

             18

ERROR 18-12: Option value for SAS option PAGESIZE must be between 15 and 32767.

2    OPTIONS PAPERSIZE = 'ISO A4';


Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 5832 views
  • 2 likes
  • 4 in conversation