WHERE Statement and Datalines

[BrahmanandaRao]

1.How many ways to create Global macro variables what are those can anyone explain examples

2.

data dsn;
input name $ city $;
if city='hyd';
/*where city='hyd';
datalines;
ram blr
ravi chennai
krish vja
kesav hyd
;
run;


*HERE IF WORKS AND WHERE NOT WORKS IN DATALINES 

[andreas_lds]

Maxim 1

Read the documentation.

SAS provides extremely well done documentation for its products. Learning to read the documentation will enhance your problem-solving skills by orders of magnitude.

from https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers...

[Kurt_Bremser]

I changed your subject line because your question has got nothing to do with macro variables.

As already stated, Maxim 1 is king here:

WHERE Statement 

Study it, and you will find why WHERE cannot work in a data step that reads data only from DATALINES or INFILEs.