Hi all,
I have to convert many text a file to sas dataset without using DDE. My file is like the following :
Label define age ///
1 "10 to 20"///
2 "20 to 30 "///
3 "30 to 40 "///
5 "40 to 50"///
6 "50 to 60"///
I tried to read the file and use fread, fget functions to read each line but i couldnot figureout how to create the dataset
%do %while(%sysfunc(fread(&fid1)) = 0);
%let rc=%sysfunc(fread(&fid1));
%let rc=%sysfunc(fget(&fid1,C,200));
Thank you all.
Hi,
Not sure what your structure is there, what do the /// reference? What are the variables?
At a guess:
data want;
attrib id format=best. age format=$20. otherbit format=$20.;
infile "...\your_file_here.txt" dlm=" " dsd missover;
input id age $ otherbit $;
run;
Possible minor change to RW9's code:
dlm " /" and don't bother reading in the otherbit variable unless there is some purpose to that /// other than saying end of line or data section.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.