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: 
zheng2017
‎01-19-2017
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to read the Excel with over 256 columns by SAS

by Calcite | Level 5 in SAS Programming
‎01-19-2017 03:58 AM
‎01-19-2017 03:58 AM
The following code is the way I import the excel into SAS: libname EXL excel "D:\tt\dt.xlsx" ver=2010 SCAN_TEXTSIZE=NO MSENGINE= ACE ; ... View more

Re: How to read the Excel with over 256 columns by SAS

by Calcite | Level 5 in SAS Programming
‎01-18-2017 04:28 AM
‎01-18-2017 04:28 AM
OS: Windows SAS Version:9.3 For somes reasons,I can't convert Excel into CSV format. ... View more

How to read the Excel with over 256 columns by SAS

by Calcite | Level 5 in SAS Programming
‎01-18-2017 04:18 AM
‎01-18-2017 04:18 AM
Hi,      Recently , I got confused by importing the Excel dataset with  hundreds of variables by using SAS.   When I tried to do it , SAS imported the Excel dataset with only 256 variables and droped many variables without error messages printed in the log.       Is there anyone who knows the methods of importing Excel data with over 300 variables?     I'm looking forward to your answers.    Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-19-2017 05:53 AM
Quick links