Hi experts ,
I am trying to read a CSV file and the variable names is having spaces and some special charectors (/) example of variable name and observation below. while it reading its not getting in properly . Please advice
Policy ID | Policy Effective Date | Policy Expiration Date | Producer | State | Company | New/Renew Code | Premium |
AZA12467955 | 20160801 | 20170201 | 42491662 | CA | 55 | R | 2160 |
AZA12553486 | 20160223 | 20170223 | 4108496 | AZ | 1 | R | 406 |
Is your file comma delimited or tab delimited?
Here is the code I used for both and the imports were both successful. The spaces and slashes in the variable names were all changed to underscores.
proc import datafile="c:\art\test.csv" out=want replace dbms=csv; getnames=yes; run; proc import datafile="c:\art\test.txt" out=outdsetname replace dbms=dlm; getnames=yes; delimiter='09'x; run;
Art, CEO, AnalystFinder.com
Is your file comma delimited or tab delimited?
Here is the code I used for both and the imports were both successful. The spaces and slashes in the variable names were all changed to underscores.
proc import datafile="c:\art\test.csv" out=want replace dbms=csv; getnames=yes; run; proc import datafile="c:\art\test.txt" out=outdsetname replace dbms=dlm; getnames=yes; delimiter='09'x; run;
Art, CEO, AnalystFinder.com
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.