topic Re: infile statement with filter in SAS Programming

infile statement with filter

BrahmanandaRao — Wed, 06 Apr 2022 07:35:06 GMT

data where_infile;
infile'/home/u35263349/My_Folder/class_ds.txt';
input Name$  Sex$  Age Height Weight ;
if Sex='F'; 
run;
Here i am import sashelp.class txt file and filter with if Clause

where cannot work with infile statement

but i didn't get output even if using IF statement where went work

Re: infile statement with filter

Kurt_Bremser — Wed, 06 Apr 2022 08:02:58 GMT

Open the text file with an editor and copy a few lines into a code box here.

Also post the log from your step into a code box.

Re: infile statement with filter

ballardw — Wed, 06 Apr 2022 08:08:33 GMT

@BrahmanandaRao wrote:
data where_infile;
infile'/home/u35263349/My_Folder/class_ds.txt';
input Name$  Sex$  Age Height Weight ;
if Sex='F'; 
run;
Here i am import sashelp.class txt file and filter with if Clause

where cannot work with infile statement

but i didn't get output even if using IF statement where went work

Show the log that was created when the code ran.

Always when output was not as expected.

Copy the text from the LOG and paste into a text box opened on the forum with the </> icon.

Re: infile statement with filter

Sajid01 — Wed, 06 Apr 2022 14:48:08 GMT

Hello @BrahmanandaRao
It is possible that the columns are tab separated. Other wise Your code code should work. If it is indeed tab separated use the following modification

data where_infile;
infile'/home/u35263349/My_Folder/class_ds.txt' dlm ='09'x dsd missover;
input Name $  Sex $  Age Height Weight ;
if Sex='F'; 
run;