cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rafa
‎12-06-2021
  • 3 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Create different XLS files named after the groups in the BY statement

by Calcite | Level 5 in New SAS User
‎10-30-2018 03:29 PM
‎10-30-2018 03:29 PM
Dear all, Hope you're doing OK 🙂 I come to you because of the following: I need to generate a different XLS file for each group in a BY statement. Also important: the name of each file should be the corresponding category from the BY statement. As of now, I'm working with the following code: ods tagsets.excelxp file='multisheet.xls' style=statistical options( sheet_interval='bygroup' ); proc sort data=PRUEBA_COM out=class; by attribute_4; run; proc print data=class; by attribute_4; run; ods tagsets.excelxp close; (Code obtained from: https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data) That code gives me a sheet from each BY group (which is fine) and the name of each sheet is "attribute_4=xxxx" (which is also fine). The thing is they all are in a single file ("multisheet.xls"). So, my questions are as follows: 1) Do you know of any other way to generate single XLS files and name them after their BY category? 2) If not, is there a way to re-import this Excel file ("multisheet") and split the sheets afterwards in different XLS files named after each sheet's name? Thank you! ... View more

Re: Creating several different ODS outputs from a PROC FREQ

by Calcite | Level 5 in ODS and Base Reporting
‎11-13-2013 01:44 PM
‎11-13-2013 01:44 PM
Thank you very much! This works just fine for what I need to do. I can work around a way to solve the name issue (since it is sorted, I could link the variable name given by the newfile=bygroup statement with the actual value in a separate table). If I find a SAS solution to it, I'll post it here as well. :smileygrin: ... View more

Creating several different ODS outputs from a PROC FREQ

by Calcite | Level 5 in ODS and Base Reporting
‎11-13-2013 12:15 PM
‎11-13-2013 12:15 PM
Dear all: I just joined the community and I hope to learn and share with you as much as possible. I have one question to start: I need to create as many reports as categories are in the BY statement of a PROC FREQ (there will be around 30), and export the PDF output as an individual PDF file (this is, one PDF file for each category in the BY statement). So far, I've come to this syntax, which exports only an aggregated file instead of for each category in the BY statement: ODS PDF STYLE=Styles.SASweb FILE='C:\S1_out.pdf'; PROC FREQ DATA=WORK.Labels_Export_CMS; TITLE "Finalized Cases"; TABLES IntervierName*DispositionCode / nocol nopercent; WHERE status=2; BY Supervisor; RUN; ODS PDF CLOSE; Ideally, I would need to do this as efficient as possible (hopefully, not making one syntax as the one above for each of the 30 cases), since I'll need to generate this information from the same database (same structure, new information), weekly. Thank you very much. Rafa ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-06-2021 11:58 PM
Likes given to
View All
Quick links