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 / 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 a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Give some examples where proc report’s defaults are same as proc print’s defaults?
Explain data step in SAS
Explain substr function?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
how to change the execute of macro
What is SAS informats?
What is the use of the %include statement?
Explain how merging helps to combine data sets.
What is program data vector (pdv)?
What is the use of stop statement?
Difference between SAS STATA & SPSS?
Explain the difference between informat and format with an example.
Explain proc univariate?
What is the difference between SAS functions and procedures?