topic Re: WHERE Statement and Datalines in SAS Programming

WHERE Statement and Datalines

BrahmanandaRao — Tue, 29 Mar 2022 08:50:35 GMT

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

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

Re: Global macro variable

andreas_lds — Tue, 29 Mar 2022 06:47:00 GMT

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/ta-p/352068

Re: WHERE Statement and Datalines

Kurt_Bremser — Tue, 29 Mar 2022 08:54:30 GMT

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.