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 |
how many types of MERGE?
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
Can you execute a macro within a macro? Describe. : sas-macro
What techniques and/or PROCs do you use for tables?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
which date function advances a date, time or datetime value by a given interval? : Sas programming
Have you ever used the SAS Debugger?
how can you put a "trace" in your program? : Sas programming
Can we replace a dataset into view?
what is sas application server? : Sas-di
how are numeric and character missing values represented internally? : Sas programming
explain the use of % includes a statement in sas? : Sas-administrator