topic Re: Varibale names got spaces and special chars while importing csv file to sas in SAS Programming

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

ambadi007 — Fri, 20 Jan 2017 17:02:52 GMT

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

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

art297 — Fri, 20 Jan 2017 17:45:46 GMT

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