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: 
NL
‎07-02-2017
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Can I update an excel file with a SAS dataset without import the e...

by Calcite | Level 5 in SAS Programming
‎06-22-2017 11:47 PM
‎06-22-2017 11:47 PM
Hi Haikuo,    Can the same work in v9.4 if my excel file is in xlsx format (MS Office 2101)? I have the option to read the Excel file spreadsheet using libname with the xlsx engine. My objective is to update a column in a spreadsheet based on a table in SAS and keep all other existing columns intact.    Regards, Nelson   ... View more

Re: SAS 9.3 import excel file

by Calcite | Level 5 in SAS Procedures
‎09-02-2014 06:42 PM
‎09-02-2014 06:42 PM
This may be a bit off the topic. I have SAS 9.2 (32 bit) installed in a 64 bit OS (laptop) and have MS Office 2010 (32 bit). However, I noticed the ACCESS Connectivity Engine is missing. I tried to download and install it but still unbale to see it in Registry editor. What is the root cause? Would SAS still be able to read Excel and export to Excel? ... View more

Re: SAS 9.3 import excel file

by Calcite | Level 5 in SAS Procedures
‎09-02-2014 06:06 PM
‎09-02-2014 06:06 PM
Hi, Would SAS 9.3 or 9.4 take care the "bitness" issue with the use of PC File Server? Nelson ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-02-2017 07:32 PM
Quick links