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 / nishant

PROC SQL is a powerful tool in sas which combines the
functionality of data and proc steps. PROC SQL can sort,
summarize, subset, join (merge), and concatenate datasets,
create new variables, and print the results
or create a new dataset all in one step!

PROC SQL uses less resources when compared to that of data
and proc steps.

To join files in PROC SQL it does not require to sort the
data prior to merging which is must is data merge

Is This Answer Correct ?    22 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to do user inputs and command line arguments in sas?

3035


How do you test for missing values?

1624


Are you involved in writing the inferential analysis plan? Tables specfications?

2219


Differentiate between ceil and floor functions.

1151


Difference between sum function and using “+” operator?

1143


Explain how merging helps to combine data sets.

1046


what is business intelligence? : Sas-bi

1056


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2068


why is a stop statement needed for the point=option on a set statement? : Sas programming

1075


Do you know the features of sas?

1037


explain about sas business intelligence? : Sas-bi

1132


What does the trace option do?

1099


how sas deals with business intelligence? : Sas-bi

1050


What is proc sort?

1198


Which are the statements whose placement in the data step is critical?

1251