DATA Step, Macro, Functions and more

Varibale names got spaces and special chars while importing csv file to sas

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

Varibale names got spaces and special chars while importing csv file to sas

[ Edited ]

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 IDPolicy Effective DatePolicy Expiration DateProducerStateCompanyNew/Renew CodePremium
AZA12467955201608012017020142491662CA55R2160
AZA1255348620160223201702234108496AZ1R406

 

 


Accepted Solutions
Solution
‎01-26-2017 08:24 AM
PROC Star
Posts: 7,363

Re: Varibale names got spaces and special chars while importing csv file to sas

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

 

 

View solution in original post


All Replies
Solution
‎01-26-2017 08:24 AM
PROC Star
Posts: 7,363

Re: Varibale names got spaces and special chars while importing csv file to sas

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

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 133 views
  • 0 likes
  • 2 in conversation