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
6661 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 to merge the data using merge statement and proc format? Is the result is same ?

2 Answers

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers Oracle,

What is the basic structure of a sas program?

0 Answers

What is the difference between input and infile statement?

0 Answers

How we can call macros with in data step? : sas-macro

0 Answers

What is LAG function?How is it used? can any one explain

3 Answers TRE, Verinon Technology Solutions,

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

0 Answers

What is the order of application for output data set options, input data set options and SAS statements?

0 Answers Quintiles,

Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.

4 Answers Symphony,

To what type of programms have you used scratch macros?

0 Answers Novartis,

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers

Describe 5 ways to do a “table lookup” in SAS?

0 Answers

For more SAS Interview Questions Click Here