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
- 5713 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 sas metadata repository? : Sas-bi
How to convert a numeric variable to a character variable?
What is the difference between SAS functions and procedures?
How do you add a number to a macro variable? : sas-macro
What is the sas data set? : sas-grid-administration
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
how to do user inputs and command line arguments in sas?
what is sas and what are the functions? : Sas-administrator
what is change analysis in sas di ? : Sas-di
what is hierarchy flattening? : Sas-di
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?
explain about various caches available in data integrator? : Sas-di
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
explain the key concept of sas? : Sas-administrator
How to limit decimal places for the variable using proc means?
