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
- 5387 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
Mention common programming errors committed in sas ?
what r the job openings SAS for fresher graduates !
what is sas business intelligence? : Sas-bi
Compare sas with other data analytics tools.
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What does PROC print, and PROC contents do?
why is sas data integration studio important? : Sas-di
Describe what are the different levels of administrative users in sas? : sas-grid-administration
how could you generate test data with no input data? : Sas programming
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Describe the ways in which you can create a macro variable?
Difference between informat and format?
