topic Re: Can anyone help me to create program for this raw data in SAS Programming

Read raw data w/ special characters

vidyapedii — Mon, 20 Feb 2017 07:48:02 GMT

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

Re: Can anyone help me to create program for this raw data

Ksharp — Sun, 19 Feb 2017 03:48:28 GMT

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


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

Re: Can anyone help me to create program for this raw data

art297 — Sun, 19 Feb 2017 04:16:22 GMT

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