Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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”,…..

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

what is the difference between %put and symbolgen?

6 Answers  


how do you debug and test your sas programs? : Sas programming

0 Answers  


how do we mail reports from SAS environment to our team leader

5 Answers   Wockhardt,


What is the use of function Proc summary?

0 Answers  


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

0 Answers  






AE datasets names? how many types?

0 Answers   Accenture,


What does the trace option do?

0 Answers  


what techniques and/or procs do you use for tables? : Sas programming

0 Answers  


Write a SAS macro to calculate number of numbers in an email address

2 Answers  


how to write code for left outer join in SAs using datastep?

8 Answers   CitiGroup,


where are dashboard components are created and maintained? : Sas-bi

0 Answers  


How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  






Categories