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
- 6652 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
What does the trace option do?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Which function is used to count the number of intervals between two sas dates?
what is study design in while working with SAS? what are screening variables in SAS?
What are the limitations for memory allocation for SAS variables
Differentiate input and infile.
How would you identify a macro variable? : sas-macro
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
how to read the variables in sas? : Sas-administrator
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Tell e how how dealt with..
How we can create SAS USER DEFINED CODE?
Do you need to know if there are any missing values?
