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 proc sort?
How we can create SAS USER DEFINED CODE?
What is the general format of function in sas? : sas-grid-administration
In sas admin differentiate between roles and capabilities? : sas-grid-administration
which features do you use to check the data validations and errors? : Sas-administrator
What is factor analysis?
how do you test for missing values? : Sas programming
Differentiate input and infile.
what are all the reports you generated in your recent project?
What are common programming errors committed in sas
What are the differences between sum function and using “+” operator?
what is hash files in sas and why we are using this one in sas?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
Which command is used to save logs in the external file?
how does sas handle missing values in functions? : Sas programming