BookmarkSubscribeRSS Feed
BrahmanandaRao
Lapis Lazuli | Level 10

Hi Guys,

GoodMorning

when we use infile statement to create dataset from extranal data 

IF statement works 

 

3 REPLIES 3
BrahmanandaRao
Lapis Lazuli | Level 10
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;

Anandkvn_0-1677828143489.png

 

Kurt_Bremser
Super User

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 681 views
  • 1 like
  • 2 in conversation