i am trying to import bulk of files and create one dataset having all these files ,i am facing a problem that variable name is greater than 32 character and sas is not accepting this accordingly sas renames the header to serial as Name 1 name 2 .etc
i need to capture original header name to be able to append all the tables in one table
As long as you use Excel files, and have names in there which exceed the limits of SAS, you will have problems.
The second option is preferred for repeatable, consistent results.
What kind of files do you need to import? Excel, text, or other?
Hi Josvander
i am trying to import XLSX file with UTF8 encoding
As long as you use Excel files, and have names in there which exceed the limits of SAS, you will have problems.
The second option is preferred for repeatable, consistent results.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.