Hi,
This is my first post to this forum. I am trying to read this text file.
It has four variables but last two variables may repeat several times in each row. Attached sample data will give you the details.
Any suggestion / tips would be appreciated.
Thanks!
Rana
So I would just treat the brackets and commas as delimiters the same as if there were spaces between the fields.
data want;
length id $12 device_or_cookie_indicator 8
property_id $20 unique_days 8
;
infile 'data.txt' dlm=',{()}' truncover firstobs=2;
input id device_or_cookie_indicator @;
do item=1 by 1 until (property_id = ' ');
input property_id unique_days @;
if item=1 or property_id ne ' ' then output;
end;
run;
Would the original file be JSON, XML or something like that? I don't quite recognize the format (end of day), SAS has method to read those (and other) files though this could probably be parsed as well...
So I would just treat the brackets and commas as delimiters the same as if there were spaces between the fields.
data want;
length id $12 device_or_cookie_indicator 8
property_id $20 unique_days 8
;
infile 'data.txt' dlm=',{()}' truncover firstobs=2;
input id device_or_cookie_indicator @;
do item=1 by 1 until (property_id = ' ');
input property_id unique_days @;
if item=1 or property_id ne ' ' then output;
end;
run;
Thanks Tom, Great help.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.