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
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
Have you used macros? For what purpose you have used? : sas-macro
how can you import .csv file in to sas? : Sas programming
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
Name any two sas spawners? : sas-grid-administration
Do you need to rearrange the order of the data for the report?
how does sas handle missing values in formats? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Hi, If anyone has base SAS certification dumps, please share.
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How does proc sql work?
what are validation tools that are used in sas? : Sas-administrator
what is metadata? : Sas-bi
What is the function of output statement in a SAS Program?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Mention the difference between ceil and floor functions in sas?