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...

what is the use of proc sql?

Answer Posted / venkatesh.layam

proc sql is sql in sas.
with proc sql,we can do many more tasks.
-retrive the data from tables,from data bases
-merge the datasets or tables.
-by using different joins we can combine the data as per
our convinience
-we can create the data ,modify the data
-we can have the discriptive statistics also
-we can sort the data with out using proc sort,just use
order by .
these many tasks can do with in single programme

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain the function of substr in sas? : Sas-administrator

1008


How long can a macro variable be? A token? : sas-macro

1205


how do you want missing values handled? : Sas programming

947


Which command is used to save logs in the external file?

1089


What is a pdv and what are its functions?

1137


Explain proc sort?

1081


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1614


What is the difference between input and infile statement?

1164


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2746


How would you define the end of a macro?

1085


Explain how merging helps to combine data sets.

1046


what is factor analysis? : Sas-administrator

1085


what is operational data and operational system? : Sas-di

1102


What system options would you use to help debug a macro? : sas-macro

1089


what is business intelligence? : Sas-bi

1059