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
- 6782 Views
- I also Faced
- E-Mail Answers
Answer Posted / vema reddy dwarampudi
Please add from clause in the above code
proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
from sashelp.shoes
where Region like 'A%';
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert a numeric variable to a character variable?
Differentiate between ceil and floor functions.
What is the sas data set? : sas-grid-administration
what is the difference between nodup and nodupkey options? : Sas programming
What is the command used to find missing values?
What is the difference between where and if statement?
What is the length assigned to the target variable by the scan function?
What is the role of sas grid administrator? : sas-grid-administration
How necessary is it to be creative in your work?
explain the function of substr in sas? : Sas-administrator
How can you create a macro variable with in data step? : sas-macro
What are the statements that are executed only?
What is factor analysis?
Do you need to rearrange the order of the data for the report?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
