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 special input delimiters used in SAS?
Name types of category in which SAS Informats are placed?
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
in which companies SAS openings are there? List of companies using SAS technology.
what is information maps?
How would you define the end of a macro?
how could you generate test data with no input data? : Sas programming
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
what is star schema? : Sas-di
% let A=3+4 what is result
How would you invoke a macro? : sas-macro
proc means? proc sort? proc append? proc freq? proc print? proc content?