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 difference between SAS Data step and SAS PROC SQL,
and which is better?



What is the difference between SAS Data step and SAS PROC SQL, and which is better?..

Answer / pallavi

1)Syntax is different
2
3)benefit of PROC SQL is its ability to process unsorted
data and create tables in a sorted fashion
4)Performing an OUTER UNION is very similar to the DATA step
with a SET statement referencing two or more data sets
5)Establish a connection with a RDBMS a)LIBNAME in dataset
b)CONNECT DISCONNECT in proc SQL

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SAS Interview Questions

what is intially documentation for a sas programmer?

2 Answers   Accenture,


How do dates work in SAS data?

0 Answers  


What is the difference between SAS functions and procedures?

0 Answers  


what is the formula to measure Baseline

3 Answers   Sristek,


HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,


What is substr function?

0 Answers  


Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

6 Answers   HSBC,


What does the trace option do?

0 Answers  


What do you know about sas and what we do? : sas-grid-administration

0 Answers  


What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.

1 Answers   Cipla,


what is program data vector? : Sas-administrator

0 Answers  


what are the best practices to process the large data sets in sas programming? : Sas-administrator

0 Answers  


Categories