topic %let macro variable using in proc sql in SAS Programming

%let macro variable using in proc sql

pavank — Wed, 22 Nov 2023 09:42:18 GMT

%let  A ='India','USA','UK','AUSTRALIA';

how to using macro variable A in proc sql

Re: %let macro variable using in proc sql

rudfaden — Wed, 22 Nov 2023 09:44:50 GMT

proc sql;
select *
from mytable
where country in(&A)

Re: %let macro variable using in proc sql

pavank — Wed, 22 Nov 2023 09:58:28 GMT

from mytable means i donot have any table just i have macro variable A only

Re: %let macro variable using in proc sql

Kurt_Bremser — Wed, 22 Nov 2023 10:03:19 GMT

For what purpose do you want to use the contents of the macro variable (filtering, as part of a string, ...)?

Re: %let macro variable using in proc sql

PaigeMiller — Wed, 22 Nov 2023 10:31:43 GMT

@pavank wrote:
%let  A ='India','USA','UK','AUSTRALIA';
how to using macro variable A in proc sql

As in your last thread, we need you to explain a lot more about what you want. No one understands what you want, and by making your explanation one partial sentence, you are not helping yourself or us. To better help us help you, please EXPLAIN the entire problem with sufficient detail taht we know exactly what you want.

Re: %let macro variable using in proc sql

andreas_lds — Wed, 22 Nov 2023 10:36:54 GMT

@pavank wrote:
from mytable means i donot have any table just i have macro variable A only

And what do you want to with that variable?

The where statement is the place a variable defined like A is used. (quoted strings, comma between values).

Re: %let macro variable using in proc sql

pavank — Wed, 22 Nov 2023 10:58:01 GMT

how to pass list values in proc sql

%let A ='India', 'USA', 'UK', 'AUSTRALIA' ;

Re: %let macro variable using in proc sql

PaigeMiller — Wed, 22 Nov 2023 13:36:56 GMT

@pavank wrote:

how to pass list values in proc sql

%let A ='India', 'USA', 'UK', 'AUSTRALIA' ;

to achieve what outcome from PROC SQL???

Please, @pavank , show us the code you want without macro variables, in other words show us the code you want with 'India','USA', etc. hard-coded, and then it should be easy to take that code and make use of &A.

Re: %let macro variable using in proc sql

rudfaden — Wed, 22 Nov 2023 12:59:38 GMT

What are you trying to achive?

Re: %let macro variable using in proc sql

Tom — Wed, 22 Nov 2023 14:56:11 GMT

@pavank wrote:

how to pass list values in proc sql

%let A ='India', 'USA', 'UK', 'AUSTRALIA' ;

Where do you want to PASS it to?

Let's forget about SQL for now and just work with normal SAS code.

Do you want store that string in a variable? Add double quotes around it.

data want;
   mylist= "&a";
run;

Do you want to store each quoted word as a value of a variable in a separate observation?

data want;
  length country $20;
  do country=&a ;
    output;
  end;
run;