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

Tell me more about the parameters in macro? : sas-macro

0 Answers  


what is the use of proc sql?

5 Answers   CitiGroup,


What are the Aggregate functions in SQL ?

2 Answers   AON,


Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.

2 Answers   Accenture,


How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,


WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,


What are SAS/ACCESS and SAS/CONNECT?

0 Answers  


Differentiate input and infile.

0 Answers  


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

0 Answers   CTS,


i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.

6 Answers   CTS,


If a variable contains only numbers, can it be a character data type?

0 Answers  


describe about joins? briefly?

2 Answers   CitiGroup,


Categories