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: 
Spf2010
‎08-22-2018
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-15-2018 11:26 AM
‎08-15-2018 11:26 AM
It get rid of the headers but I still have blank rowe between each dataset that appends ... View more

Re: Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-15-2018 11:05 AM
‎08-15-2018 11:05 AM
Xlsx.The sheet has headers rows 1 to 4. Rows 5 and 6 the columns are merged for 2 or 3 columns and 2 or 3 are not.I can't post my code because of work rules. I am using Surya's code. ... View more

Re: Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-15-2018 10:57 AM
‎08-15-2018 10:57 AM
I tried the Range="sheet$A4:0" it didn't work. ... View more

Re: Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-15-2018 10:36 AM
‎08-15-2018 10:36 AM
figured out the issue. However there are a lot of spaces and headings for each file when it appends. How do I clean that up? ... View more

Re: Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-15-2018 09:02 AM
‎08-15-2018 09:02 AM
The results from this is just one column name memname.Do you know why this would be? ... View more

Import one sheet from multiple excel files

by Calcite | Level 5 in SAS Data Management
‎08-14-2018 04:13 PM
‎08-14-2018 04:13 PM
I am new to sas. I am trying to figure out how to import every excel file in a folder without naming each file.(apox 100) Also there is one sheet I am looking to grab from every file and combine them into one data set. I have done a lot of research but nothing has worked. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-22-2018 09:41 AM
Quick links