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
- 5447 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is factor analysis?
what is the difference between nodup and nodupkey options? : Sas programming
what is null hypothesis? why do you consider that?
Of all your work, where have you been the most successful?
What do the SAS log messages "numeric values have been converted to character" mean?
Describe the function and utility of the most difficult SAS macro that you have written?
Name few SAS functions?
What can you learn from the SAS log when debugging?
What are the limitations for memory allocation for SAS variables
what is metadata? : Sas-bi
how many display types available in sas bi dashboard? : Sas-bi
Describe the function and untility of the most difficult SAS macro that you have written.
where to use sas business intelligence? : Sas-bi
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
How would you define the end of a macro?
