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: 
Novice72
‎05-01-2023
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Appending 2 excel files

by Calcite | Level 5 in New SAS User
‎05-01-2023 01:50 PM
‎05-01-2023 01:50 PM
Hello, It doesn't matter anymore. The person I was done this for has decided to go another way and use Power BI instead. Thank you for your advice though. Appreciate it.  ... View more

Re: Appending 2 excel files

by Calcite | Level 5 in New SAS User
‎05-01-2023 01:50 PM
‎05-01-2023 01:50 PM
Hello, It doesn't matter anymore. The person I was done this for has decided to go another way and use Power BI instead. thank you for your advice though. Appreciate it.  ... View more

Appending 2 excel files

by Calcite | Level 5 in New SAS User
‎04-26-2023 11:24 AM
‎04-26-2023 11:24 AM
I have 2 excel files (file 1 has 5 columns, file 2 has 34 columns). I am trying to append 1018 from file 2 to the bottom of file based on a value in column 34 of file 2. I do not fully understand the syntax of the PROC APPEND statement. I have reviewed many a website for a simple explanation and example of the syntax needed. I have gotten to the point and then I am stuck as to what the next statement is to be:   PROC APPEND BASE=WORK.EXCELFILE1 APPENDVER=V6 DATA=WORK.EXCELFILE2     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-01-2023 01:51 PM
Quick links