Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6786 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 program data vector? : Sas-administrator
How substr function works in sas?
What are the differences between proc means and proc summary?
What are the features of base sas system?
what is SAS OPTIMIZATION?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What is SAS? What are the functions does it performs?
what are some differences between proc summary and proc means? : Sas programming
What areas of SAS are you most interested in?
What is the difference between INPUT and INFILE ?
What is the use of %include statement?
why is sas considered self-documenting? : Sas programming
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
What is the command used to find missing values?
how do you test for missing values? : Sas programming
