Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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”,…..

Answer Posted / ragg

here is the code for your question.
proc sql;
select *
from sashelp.shoes
where Region like 'A%';
quit;
it will list out all letters starting with 'A'in region variable.

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the good sas programming practices for processing large data sets?

1119


what are the scrubbing procedures in sas? : Sas programming

1286


What are the new features included in the new version of SAS Programming Language?

1209


How we can create SAS USER DEFINED CODE?

2098


What commands are used in the case of including or excluding any specific variables in the data set?

1097


Mention few capabilities of sas framework.

1193


what is transformation in sas data integration? : Sas-di

1036


Explain what is SAS informats?

1094


where are dashboard components are created and maintained? : Sas-bi

1013


What are the data types in sas?

1062


what is SAS OPTIMIZATION?

2298


What is the difference between reading data from an external file and reading data from an existing data set?

1176


What is the use of divide function?

1067


what are 5 ways to perform a table lookup in sas? : Sas-administrator

1238


how can you put a "trace" in your program? : Sas programming

1065