Hello, I am trying reading one .acct extension file (ascii file) which has multiple values. each observation contain 10 variables and values are separated by space (as shown below). some values are in between double quotes (where they have different delimiters like space, hyphen in between one values as well). (sas 9.4 linux)
trying to give an example,
/homedir/test.acct file contains,
"some_char"
123.45
" "
"/rootdir/test.sh -parm1 -parm2"
"-param1 ' " "userid@test.com" " ' -param2 some_char"
-1
12345678910
"select[type==any] order[r12f:pg]"
60.0
"some-character"
I am trying reading using filename statement which is not working fine - test run fine but not getting values.
/*trying to read everything as character first to get initial dataset*/
filename test_file pipe "/homedir/test.acct";
data test;
infile test_file dsd dlm='09'x;
input
var1 $20
var2 $20
var3 $20
var4 $50
.
.
var10 $20;
run;
... View more
