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
- 6651 Views
- I also Faced
- E-Mail Answers
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
Describe the function and utility of the most difficult SAS macro that you have written?
what is the use of proc sql? : Sas programming
What are common programming errors committed in sas
What are the features of base sas system?
Why and when do you use proc sql?
What does the trace option do?
explain the proc in sas? : Sas-administrator
In ARRAY processing, what does the DIM function do?
Explain the purpose of retain statement.
Differentiate input and infile.
If you could design your ideal job, what would it look like?
which date functions advances a date time or date/time value by a given interval? : Sas programming
Explain the difference between informat and format with an example.
what is sas enterprise intelligence architecture? : Sas-bi
What is the basic syntax style in SAS?
