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 a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

960


Give some examples where proc report’s defaults are same as proc print’s defaults?

1053


Explain data step in SAS

1017


Explain substr function?

1029


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1478


how to change the execute of macro

2226


What is SAS informats?

1054


What is the use of the %include statement?

1084


Explain how merging helps to combine data sets.

992


What is program data vector (pdv)?

1189


What is the use of stop statement?

1016


Difference between SAS STATA & SPSS?

1059


Explain the difference between informat and format with an example.

1112


Explain proc univariate?

970


What is the difference between SAS functions and procedures?

1097