topic Re: infile statement and if statement in SAS Programming

infile statement and if statement

BrahmanandaRao — Fri, 03 Mar 2023 06:31:34 GMT

Hi Guys,

GoodMorning

when we use infile statement to create dataset from extranal data

IF statement works

Kurt_Bremser — Fri, 03 Mar 2023 07:17:51 GMT

Maxim 4.

Try it.

BrahmanandaRao — Fri, 03 Mar 2023 07:23:45 GMT

data dsn;
infile "/home/u35263349/sampleinfile.txt" dsd;
Input id name$ sex$ age sal;
where sex='f'; 
run;

data dsn1;
set dsn;
where sex='f';
run;

Kurt_Bremser — Fri, 03 Mar 2023 07:31:38 GMT

Maxim 1!

From the documentation of the WHERE Statement:

Selects observations from SAS data sets that meet a particular condition.

Emphasis by me.

You do not read from a dataset (no SET, MERGE, MODIFY or UPDATE statement).

When you want to filter during reading from an external file, you must use a subsetting IF.