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: 
Tmacfan
‎02-10-2017
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Tagsets.ExcelXP to XLSX

by Calcite | Level 5 in SAS Programming
‎03-03-2017 03:38 PM
‎03-03-2017 03:38 PM
This works fine in interactive mode, but doesn't if you use Windows Task Scheduler to run the SAS program that uses this script to convert xls files to xlsx files.  The vbscript does not even launch.   Do we have something that works for a scheduled reporting program? ... View more

Re: Export to Excel from unix SAS code

by Calcite | Level 5 in SAS Programming
‎01-17-2017 04:20 AM
‎01-17-2017 04:20 AM
Hi Cynthia,   Thank you for taking out the time and answering my queries 🙂   I do have SAS addin capability but for this particlualr task I need to update raw data into a excel sheet with pivot already existing and then somehow mail that to end-user.   I will look into VBA if that can help me.   Appreciate your help o t he same.     Best, Vikas       ... View more

Re: generate pivot table using tagsets.tableeditor and saving as excel

by Calcite | Level 5 in SAS Programming
‎01-10-2017 05:04 AM
‎01-10-2017 05:04 AM
Hi Kurt, Thanks for the revert but I already tried this. This creates a save as button but I need to save the pivot in excel automatically. Also I am using pc sas 9.3 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-10-2017 02:51 AM
Quick links