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”,…..
- 3 Answers
- 5418 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the role of sas grid administrator? : sas-grid-administration
What are the functions used for character handling?
To what type of programms have you used scratch macros?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Explain append procedure?
What is the difference between the proc sql and data step?
What is the role of unrestrictive users? : sas-grid-administration
Mention the difference between ceil and floor functions in sas?
What is the difference between %local and %global? : sas-macro
What is the work of tranwrd function?
what techniques and/or procs do you use for tables? : Sas programming
what is slowly changing dimension? : Sas-di
How many data types are there in SAS?
what is metadata? : Sas-bi
What does proc print, and proc contents are used for?
