You need to create an In List that it is to be later used in a Where Clause tha

You need to create an In List that it is to be later used in
a Where Clause that includes all the Regions that begin with
the letter A from the sashelp.shoes table. Using PROC SQL
with an into clause create the following string from the
sashelp.shoes table using the variable region
“AFRICA”,”ASIA”,…..

Question Posted / daya.oct21

3 Answers
6791 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

You need to create an In List that it is to be later used in a Where Clause that includes all the R..

Answer / ragg

here is the code for your question.
proc sql;
select *
from sashelp.shoes
where Region like 'A%';
quit;
it will list out all letters starting with 'A'in region variable.

Is This Answer Correct ?

15 Yes

3 No

You need to create an In List that it is to be later used in a Where Clause that includes all the R..

Answer / vema reddy dwarampudi

Please add from clause in the above code
proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
from sashelp.shoes
where Region like 'A%';
quit;

Is This Answer Correct ?

1 Yes

0 No

You need to create an In List that it is to be later used in a Where Clause that includes all the R..

Answer / vema reddy dwarampudi

proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
where Region like 'A%';
quit;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More SAS Interview Questions

how many types of MERGE?

17 Answers CitiGroup,

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers

Can you execute a macro within a macro? Describe. : sas-macro

0 Answers

What techniques and/or PROCs do you use for tables?

4 Answers Oracle,

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers

which date function advances a date, time or datetime value by a given interval? : Sas programming

0 Answers

Have you ever used the SAS Debugger?

0 Answers Quintiles,

how can you put a "trace" in your program? : Sas programming