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
- 5714 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
explain what is factor analysis? : Sas-administrator
how many display types available in sas bi dashboard? : Sas-bi
which features do you use to check the data validations and errors? : Sas-administrator
What are the prime responsibilities of data integration administrator? : Sas-di
How long can a macro variable be? A token? : sas-macro
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what is study design in while working with SAS? what are screening variables in SAS?
Enlist the syntax rules followed in sas statements.
If a variable contains letters or special characters, can it be numeric data type?
what is the difference between unique key and primary key? : Sas-di
What do the SAS log messages "numeric values have been converted to character" mean?
do you prefer proc report or proc tabulate? Why? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
what are the considerations when picking a SAS/STAT procedure?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
