Read raw data w/ special characters

[vidyapedii]

Raw data

101~lilly\5000
102&jasmine|3000
103:rose /7000

I need a data set without special characters with 3 varialbles named  " id name and sal"

I created programm like this, but getting error

data a;

infile 'C:\SASUniversityEdition\myfolders\vidya\test1.txt' dlm='~' '\' '&' '|' ':' '/';
input id name $ sal;
run;

Please help me to create the correct programm

[Ksharp]

If you are using UE, the path should like this:


data a;
infile '/folders/myfolders/test1.txt' dlm='~' '\' '&' '|' ':' '/';
input id name $ sal;
run;

[art297]

You will get errors for at least two reasons: (1) SAS can't find the file and (2) you didn't specify the delimiters properly. Try this instead:

data a;
  infile '/folders/myfolders/vidya/test1.txt' dlm='~&|:/\';
  input id name $ sal;
run;

Art, CEO, AnalystFinder.com