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 the good sas programming practices for processing large data sets?
what are the scrubbing procedures in sas? : Sas programming
What are the new features included in the new version of SAS Programming Language?
How we can create SAS USER DEFINED CODE?
What commands are used in the case of including or excluding any specific variables in the data set?
Mention few capabilities of sas framework.
what is transformation in sas data integration? : Sas-di
Explain what is SAS informats?
where are dashboard components are created and maintained? : Sas-bi
What are the data types in sas?
what is SAS OPTIMIZATION?
What is the difference between reading data from an external file and reading data from an existing data set?
What is the use of divide function?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how can you put a "trace" in your program? : Sas programming