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
- 6605 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 is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
How to limit decimal places for the variable using proc means?
Have you ever used the SAS Debugger?
what is sas database server? : Sas-di
how does sas handle missing values in sort order? : Sas programming
What is the sas data set? : sas-grid-administration
Give e an example of..
What would be the value of month at the end of data step execution and how many observations would be there?
What is the difference between INPUT and INFILE ?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
How to create a permanent sas data set?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What are the parameters of scan function?
