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
- 5715 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
how to read the variables in sas? : Sas-administrator
Why and when do you use proc sql?
explain the function of substr in sas? : Sas-administrator
What do you know about sas data set?
Of all your work, where have you been the most successful?
To what type of programms have you used scratch macros?
What function CATX syntax does?
What is the difference between SAS functions and procedures?
How you can read the variables that you need?
What is maximum storage capability of SAS?
What are the functions used for character handling?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Which are the statements whose placement in the data step is critical?
For clinical entire study how many tables will create approx?
for report generation which one you used proc report or data_null_?
