topic convert text file to SAS dataset in SAS Programming

convert text file to SAS dataset

Maya_QC — Tue, 29 Jul 2014 14:36:17 GMT

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.

RW9 — Tue, 29 Jul 2014 14:43:28 GMT

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;

ballardw — Wed, 30 Jul 2014 16:19:15 GMT

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.