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 many types prompting framework can be broken down to? : Sas-bi

1076


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

2223


what is sas olap server? : Sas-di

1257


What can you learn from the SAS log when debugging?

1380


How you can read the variables that you need?

1125


what is study design in while working with SAS? what are screening variables in SAS?

2242


what is sas business intelligence? : Sas-bi

1178


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1404


what is SAS OPTIMIZATION?

2295


What does the trace option do?

1109


Differentiate between proc means and proc summary.

1060


What is the role of sas grid administrator? : sas-grid-administration

1287


what are sas bi dashboard components? : Sas-bi

1172


how would you determine the number of missing or nonmissing values in computations? : Sas programming

1150


Explain data_null_?

1057