topic Re: which statement works in infile statement in New SAS User

which statement works in infile statement

BrahmanandaRao — Sat, 25 Mar 2023 05:34:15 GMT

data a;
infile "/home/u35263349/if.txt";
input name$ city$ ;
if city='hyderabad' ;
run;

1.which statement works if statetment or where statement in infile statement read the external source data

please find below attachment txt.file

Re: which statement works in infile statement

ballardw — Sat, 25 Mar 2023 05:47:33 GMT

If you run this code:

data a;
infile "/home/u35263349/if.txt";
input name$ city$ ;
run;

You will see that the value in the data is read as "hyderaba". The length is 8 characters because when you use Input city $; SAS defaults to reading 8 characters. You need to provide an informat longer than 8 OR tell SAS the variable should be longer. So you did not have the value long enough to match your If condition.

This uses an informat to read City as a 10 character variable:

data a;
infile "/home/u35263349/if.txt";
input name$ city :$10. ;
run;

This sets the length of Name and City to 10 characters when read:

data a;
infile "/home/u35263349/if.txt";
length name city $10;
input name$ city $ ;
run;

Re: which statement works in infile statement

Astounding — Sat, 25 Mar 2023 07:11:23 GMT

You need IF, not WHERE.
The IF statement can be used by any DATA step.
The WHERE statement requires that the incoming data is already a SAS data set. Since your source of incoming data is text and not a SAS data set, you cannot use WHERE.

Re: which statement works in infile statement

BrahmanandaRao — Sat, 25 Mar 2023 07:18:27 GMT

which statement works in infile statement IF or where

Re: which statement works in infile statement

Astounding — Sat, 25 Mar 2023 07:26:19 GMT

IF.
Not WHERE.

Re: which statement works in infile statement

Kurt_Bremser — Sat, 25 Mar 2023 08:28:22 GMT

The answer is there: WHERE Statement

You only have to READ.