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”,…..
Answer Posted / 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 View All Answers
Mention how to limit decimal places for the variable using proc means?
Explain data step in SAS
What is proc sort?
what is data integration? : Sas-di
explain the concepts and capabilities of business object? : Sas-bi
What is the order of application for output data set options, input data set options and SAS statements?
In ARRAY processing, what does the DIM function do?
Can you explain the process of calendar?
How do you add a number to a macro variable? : sas-macro
what is SAS OPTIMIZATION?
What is a macro routine?
Which command is used to perform sorting in sas program?
how does sas handle missing values in functions? : Sas programming
What areas of SAS are you most interested in?
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