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”,…..
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
Difference between SAS STATA & SPSS?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
Give e an example of..
How long can a macro variable be? A token? : sas-macro
what is sas database server? : Sas-di
how do u validate the program which u have written.
is there any differnce between proc means and proc summary?
How do you delete duplicate observations in sas?
What is the differnce between SDTM 3.1.2 to 3.1.1 version