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 Calcite | Level 5 in SAS Programming
‎12-27-2018 01:13 PM
‎12-27-2018 01:13 PM
Thanks for the answer. Could you please also tell how to have gridlines instead of whited out all the remaining rows n columns ... View more

Re: PROC EXPORT OR ODS EXCEL

by Calcite | Level 5 in SAS Programming
‎12-27-2018 12:55 PM
‎12-27-2018 12:55 PM
Thank you Cynthia. thank you somuch. ... View more

Re: PROC EXPORT OR ODS EXCEL

by Calcite | Level 5 in SAS Programming
‎12-27-2018 04:25 AM
‎12-27-2018 04:25 AM
Hi, i m using SAS ENTERPRISE GUIDE (version: 9.04.01M2P07232014) ... View more

PROC EXPORT OR ODS EXCEL

by Calcite | Level 5 in SAS Programming
‎12-26-2018 10:32 PM
‎12-26-2018 10:32 PM
Hi Everyone! Below is one of the challenge im facing now.   Existing scenario: There is Excel template file placed in common folder. This template file contains two sheets (sheet1, sheet2).  Both the sheets contains only Variable Names but no records. Also this Template sheet have Footer information which will be displayed only when we do PRINT PREVIEW of excel. Current SAS Code using DDE concept and this template file, writes work dataset data to 2nd sheet of template (not in Sheet1) After exporting SAS data to excel using above DDE concept, this file will be stored to another Folder with another name with datestamp. Now the output excel file contains  two sheets ( sheet1 - only variables ,no data ; Sheet2 - both variables and data records) . Also contains Footer information. Expected Scenario: I need to achieve above scenario without USING DDE CONCEPT in SAS ENTERPRISE GUIDE (version: 9.04.01M2P07232014) I can do this using PROC EXPORT or ODS EXCEL. but the challange im facing is  1) In PROC EXPORT, i can export empty dataset data to sheet1 and data to sheet2 BUT i cant include/define FOOTER information. 2) In ODS EXCEL, i can include/define FOOTER information BUT i can't export empty dataset data to sheet1. HOW TO ACHIEVE THIS. PLEASE HELP ME  ... View more

Proc export or ODS EXCEL

by Calcite | Level 5 in SAS Enterprise Guide
‎12-26-2018 10:31 PM
‎12-26-2018 10:31 PM
Hi Everyone! Below is one of the challenge im facing now.   Existing scenario: There is Excel template file placed in common folder. This template file contains two sheets (sheet1, sheet2). Both the sheets contains only Variable Names but no records. Also this Template sheet have Footer information which will be displayed only when we do PRINT PREVIEW of excel. Current SAS Code using DDE concept and this template file, writes work dataset data to 2nd sheet of template (not in Sheet1) After exporting SAS data to excel using above DDE concept, this file will be stored to another Folder with another name with datestamp. Now the output excel file contains two sheets ( sheet1 - only variables ,no data ; Sheet2 - both variables and data records) . Also contains Footer information. Expected Scenario: I need to achieve above scenario without USING DDE CONCEPT. I can do this using PROC EXPORT or ODS EXCEL. but the challange im facing is 1) In PROC EXPORT, i can export empty dataset data to sheet1 and data to sheet2 BUT i cant include/define FOOTER information. 2) In ODS EXCEL, i can include/define FOOTER information BUT i can't export empty dataset data to sheet1. HOW TO ACHIEVE THIS. PLEASE HELP ME  ... 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

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

by Calcite | Level 5 in New SAS User
‎12-15-2018 12:43 AM
‎12-15-2018 12:43 AM
/*Sample Dataset*/ DATA INVENTORY; INPUT PARTNUMBER $ DESCRIPTION $ INSTOCK @17 PRICE; DATALINES; K89R SEAL 34 245.00 M4J7 SANDER 98 45.88 LK43 FILTER 121 10.99 MN21 BRACE 43 27.87 BC85 CLAMP 80 9.55 NCF3 VALVE 198 24.50 KJ66 CUTTER 6 19.77 UYN7 ROD 211 11.55 JD03 SWITCH 383 13.99 BV1E TIMER 26 34.50 ; RUN; /*Tried xlsx and sheet and range still it gives error at Range*/ Proc Export Data= Work.Inventory Outfile= "D:\SAS\Others\Inventory.xlsx" dbms=xlsx replace; sheet=TEST; Range='Test$A15:B16'; quit; /*Tried xlsx and range still it gives error at Range*/ Proc Export Data= Work.Inventory Outfile= "D:\SAS\Others\Inventory.xlsx" dbms=xlsx replace; Range='Test$A15:B16'; quit;   Can we use RANGE in Proc Export? ... View more

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

by Calcite | Level 5 in New SAS User
‎12-14-2018 02:21 AM
‎12-14-2018 02:21 AM
/*Sample Datasets*/ DATA INVENTORY; INPUT PARTNUMBER $ DESCRIPTION $ INSTOCK @17 PRICE; DATALINES; K89R SEAL 34 245.00 M4J7 SANDER 98 45.88 LK43 FILTER 121 10.99 MN21 BRACE 43 27.87 BC85 CLAMP 80 9.55 NCF3 VALVE 198 24.50 KJ66 CUTTER 6 19.77 UYN7 ROD 211 11.55 JD03 SWITCH 383 13.99 BV1E TIMER 26 34.50 ; RUN; DATA TOTAL; INPUT CATEGORY:$ 15. TOTAL; DATALINES; STOCK_IN_TOTAL 1200 PRICE_IN_TOTAL 443.60 ; RUN; Proc Export Data= Work.Inventory Outfile= "C:\Users\U518651\Desktop\test\Inventory_Test.xls" dbms=xls replace; sheet=TEST; quit; Proc Export Data= Work.Total Outfile= "C:\Users\U518651\Desktop\test\Inventory_Test.xls" dbms=xls replace; /*sheet=TEST;*/ Range='Test$A15:B16'; quit; ... View more

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

by Calcite | Level 5 in New SAS User
‎12-13-2018 01:19 AM
‎12-13-2018 01:19 AM
I tried RANGE & SHEET but it throws error ... View more

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

by Calcite | Level 5 in New SAS User
‎12-12-2018 01:44 PM
‎12-12-2018 01:44 PM
Existing code is using DDE concept(which run on sas 9.4) to write data to particular range of cells in existing workbook Now i need to automate this to run in sas EG 7.1 Instead of DDE , i need to use other exporting strategy ... View more

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

by Calcite | Level 5 in New SAS User
‎12-12-2018 01:41 PM
‎12-12-2018 01:41 PM
I tried sheet n range option But i see error in log at the word sheet n range ... View more

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

by Calcite | Level 5 in New SAS User
‎12-12-2018 11:55 AM
‎12-12-2018 11:55 AM
I have two datasets say DS_A  and DS_B . Both datasets contains 3 variables & 10 observations each. I wish to export these datasets data to only one Excel file ( File_name : Sample.XLS, SheetName: Sheet1 ) I need to Export DS_A data to Sheet1 from A1:C10  cells and DS_B data to Same Sheet1 from A15:C25 cells .   the Challenge here is i shouldnt use DDE concept.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-19-2019 02:18 AM
Quick links