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
- 6498 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
what has been your most common programming mistake? : Sas programming
explain what is factor analysis? : Sas-administrator
What is the function of Stop statement in a SAS Program?
How do you connect the desktop application to metadata server? : sas-grid-administration
what is proc Index? and what is proc document?
What are SAS/ACCESS and SAS/CONNECT?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What are the special input delimiters used in SAS?
what is study design in while working with SAS? what are screening variables in SAS?
how do you debug and test your sas programs? : Sas programming
How do you specify the number of iterations and specific condition within a single do loop?
what is the difference between floor and ceil functions in sas? : Sas-administrator
what is ae onset date n what is RDS
How substr function works in sas?
What are the different types of sas functions?
