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 are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,


what are input dataset and output dataset options? : Sas programming

0 Answers  


Name validation tools used in SAS

0 Answers  


What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers  


what is factor analysis? : Sas-administrator

0 Answers  


for whom is sas data integration studio designed? : Sas-di

0 Answers  


How do you debug and test your SAS programs?

0 Answers   Quintiles,


what is the difference between the SAS v8 and SAS v9?

7 Answers   TCS,


what are all the reports you generated in your recent project?

0 Answers   Accenture, Quintiles,


what are some differences between proc summary and proc means? : Sas programming

0 Answers  


How would you delete observations with duplicate keys?

6 Answers  


i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,


Categories