1 / 8

Use of ODS tagsets.excelxp to create Excel type files

Use of ODS tagsets.excelxp to create Excel type files. Douglas Staddon Senior Statistical Programmer Oct 2011. Contents. How to create an XLS file using tagsets Tagset options Possible uses of tagsets/Excel Case study using CDISC pilot study Pros and Cons Summary questions.

rwoodson
Download Presentation

Use of ODS tagsets.excelxp to create Excel type files

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Use of ODS tagsets.excelxp to create Excel type files Douglas Staddon Senior Statistical Programmer Oct 2011

  2. Contents • How to create an XLS file using tagsets • Tagset options • Possible uses of tagsets/Excel • Case study using CDISC pilot study • Pros and Cons • Summary questions

  3. How to create an Excel file using Tagsets ods tagsets.excelxp file="&path./sashelp.xml" style=sasweb ; proc print data=sashelp.class noobs ; run; ods tagsets.excelxp close; SASHELP.XML

  4. Excelxp options: quick help and sheet name ods tagsets.excelxp file="&path./sashelp03.xml" style=sasweb; ** quick help info written to the log **; ods tagsets.excelxp options (doc=‘quick'); ods tagsets.excelxp options (SHEET_NAME="Age le 12"); proc print data=sashelp.class noobs ; where age le 12; run; ods tagsets.excelxp options (SHEET_NAME="SASHELP.CLASS" autofilter='yes'); proc print data=sashelp.class noobs ;run; ods tagsets.excelxp close;

  5. Possible uses of tagsets/Excel • Create XLS file derived data specifications • Create XLS file of MedDRA/ WHODRUG dictionary comparisons • Review data: • Create XLS file of database – tabs per domain • Look at possible protocol deviations • Create XLS file of database per patient per domain • Fix data errors

  6. Case study using CDISC pilot study • 306 patients in 17 domains • XLS file per patient – separate tabs per domain • Files ranged from 64kb to 3062kb – total 493Mb • Took 23 minutes

  7. Pros and Cons • Large files: Open and Save As actual XLS files • 90%+ reduction in size

  8. Summary: ODS tagsets.excelxp • How to create an XLS file using tagsets • Tagset options - quick help, sheet name, filtering • Possible uses of tagsets/Excel • Case study using CDISC pilot study • Pros and Cons Just try it! Any Questions?

More Related