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
- 6606 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
Do you know the features of sas?
What are the advantages of using sas?
do you need to know if there are any missing values? : Sas programming
What are the data types in sas?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What is the difference between INPUT and INFILE ?
what is the difference between floor and ceil functions in sas? : Sas-administrator
What are the functions used for character handling?
where to use sas business intelligence? : Sas-bi
Of all your work, where have you been the most successful?
explain the difference between proc means and proc summary?
In ARRAY processing, what does the DIM function do?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Did you used proc test? when?
