The SAS Output Delivery System and reporting techniques

its possible to add more then two tables in none excel sheet.

Reply
Contributor
Posts: 32

its possible to add more then two tables in none excel sheet.

Hi,

 

Its possible to add more then two tables in none excel sheet (xlsx format).

Eg. I have 2 tables and need to display in one excel sheet. it's possible or not. If possible then how?.

 

 

Super User
Super User
Posts: 7,977

Re: its possible to add more then two tables in none excel sheet.

Posted in reply to Shantaram

Yes it is possible.  In pre 9.4 days, and probably still, the best method is ods tagsets.excelxp + proc report:

https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

This doesn't create a native Excel file, but an XML file that Excel can read and interpret, but gives great flexibility and formatting.

 

Then there is libname excel - which is newer (9.4), and creates native files.  It didn't seem as flexibile or useful to me though at the moment:

http://www2.sas.com/proceedings/sugi31/024-31.pdf

 

There are other methods, but I would go with the above first.  Proc export tends to be a best guess, DDE is far to old to be used etc.

Super User
Posts: 5,433

Re: its possible to add more then two tables in none excel sheet.

Posted in reply to Shantaram

Another option would be to use Add-in for MS Office, where the Excel report pulls data from SAS. And you can design your Excel report exactly the way you wish.

Data never sleeps
Super User
Posts: 19,833

Re: its possible to add more then two tables in none excel sheet.

Posted in reply to Shantaram

In SAS 9.4 there's also ODS Excel, similar to ODS tagsets which does generate a native excel file. 

 

Proc of export and XLSX will also support multiple sheets in SAS 9.4+ 

Contributor
Posts: 32

Re: its possible to add more then two tables in none excel sheet.

Hi,

please find attachment for more details.

table one # New Appointments fixed 

teble two # Meetings scheduled (due).

i want both in same sheet.


test.jpg
Super User
Posts: 5,433

Re: its possible to add more then two tables in none excel sheet.

Posted in reply to Shantaram

@Shantaram, you've had already received some input.

So the next step is that you explore those options - and then return with any relevant follow-up questions if necessary.

Data never sleeps
Contributor
Posts: 32

Re: its possible to add more then two tables in none excel sheet.

Hi Linush,

 

I got your point but i want output in one page not in two diffrent pages.

Super User
Posts: 19,833

Re: its possible to add more then two tables in none excel sheet.

Posted in reply to Shantaram

ODS tagsets.excelxp file='sample.xml' options(sheet_interval=none);

 

proc print data=sashelp.class;

 

proc print data=sashelp.air;

run;

 

ods tagsets.excelxp close;

 

Change the file destination to somewhere that makes sense for you and open the resulting file in Excel. 

SAS Super FREQ
Posts: 708

Re: its possible to add more then two tables in none excel sheet.

Hi

 

check out the ODS EXCEL destination

 

code will look similar to

 

ods excel file="c:\temp\sample.xlsx" options(SHEET_INTERVAL=  'NONE');

proc print data=sashelp.class;
  where sex = "F";
run;

proc print data=sashelp.class;
  where sex = "F";
run;

ods excel close;

Bruno

Ask a Question
Discussion stats
  • 8 replies
  • 534 views
  • 0 likes
  • 5 in conversation