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 / vema reddy dwarampudi
proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
where Region like 'A%';
quit;
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a macro routine?
What is the SAS data set?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Explain the difference between informat and format with an example.
what has been your most common programming mistake? : Sas programming
explain the function of substr in sas? : Sas-administrator
What is the difference between SAS functions and procedures?
describe about metadata object? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is Linear Regression?
how do you test for missing values? : Sas programming
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What is substr function?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Can you suggest us materials for sdtm mapping?