good day expects.
i am using the below script to Import txt file, however my script adds a new column called VAR1. see screen prints below. please assist
script
Results
Looks like the whole source string gets imported into a single variable Var1.
You define getnames=no so SAS needs to create a variable name (Var1).
The default delimiter does not match your data so the whole line gets imported into a single variable.
Looks like a SAP unload. These are usually not delimited, but have fixed-width columns, which you can read with formatted INPUT.
PS PROC IMPORT won't help you here in any way, as SAP unloads do not provide a header line with column names; you have to write your own data step according to the unload documentation.
Looks like a fixed-width-file, nothing to be read by proc import, but with a data step.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: