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: 
anjicam
‎02-19-2019
  • 12 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Proc export or ODS EXCEL

by Meteorite | Level 14 in SAS Enterprise Guide
‎01-01-2019 03:15 PM
‎01-01-2019 03:15 PM
Hello This does all what you want /*https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-export-or-ODS-EXCEL/m-p/523599#M32752*/ /* Importing sheet */ proc import file="/folders/myfolders/Excel/file1_01JAN2019.xlsx" out=work.test replace dbms=xlsx; sheet="sheet1"; run; proc import file="/folders/myfolders/Excel/file1_01JAN2019.xlsx" out=work.test2 replace dbms=xlsx; sheet="sheet2"; run; /* your code steps here*/ /*writing to sheets*/ ods excel file="/folders/myfolders/Excel/file2_01JAN2019.xlsx" options(sheet_interval= "proc" sheet_name="sheet1" embedded_titles='on' embedded_footnotes='on'); Footnote "Footer1"; proc print data=work.test noobs; run; ods excel options (sheet_name="sheet2"); Footnote "Footer2"; proc print data=sashelp.class noobs; run; ods excel close; ... View more

Re: PROC EXPORT OR ODS EXCEL

by SAS Super FREQ in SAS Programming
‎12-27-2018 03:09 PM
‎12-27-2018 03:09 PM
Hi: I think there's a suboption to turn gridlines on INSIDE the table, if that's what you're referring to. However, if you are referring to the fact that the gridlines outside of the table do not show, I believe that is Excel using the background from the style overlaid on top of the gridlines. If you want to make the background go away, I believe you need to change the style template. Or, if you truly only want the data without ANY style (colors or fonts) at all, then move to PROC EXPORT or LIBNAME XLSX methods of getting your data from SAS into Excel. Cynthia ... View more

Re: How to Export two datasets data to specific range/cells in Excel

by Super User in New SAS User
‎12-15-2018 11:53 AM
2 Likes
‎12-15-2018 11:53 AM
2 Likes
Your range is only two columns and two rows.  How are you going to fit that dataset into that range? Also try just setting the upper left hand corner on RANGE. ... View more

Re: Placing Multiple Tables in Same Excel Sheet via ODS

by Calcite | Level 5 in ODS and Base Reporting
‎12-15-2018 08:10 AM
‎12-15-2018 08:10 AM
Hi @BCNAV, I am facing the same problem that you posted here. I am really searching answer for this Question so long ago. Could you please answer me if you done that. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-19-2019 02:18 AM
Quick links