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 connection profile? : sas-grid-administration

0 Answers  


What is the difference between reading data from an external file and reading data from an existing data set?

0 Answers  


At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,


differnce between 8.2 and 9.1.3

1 Answers  


what are the new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,






Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

0 Answers  


What is maximum storage capability of SAS?

0 Answers  


How could you generate test data with no input data?

14 Answers   CTS,


What are exact SAS Base contents..?N what r SAS Tools..?

1 Answers  


how many data types in sas? : Sas-administrator

1 Answers  


What is the difference Using & and && in the macro variables

5 Answers   Accenture,


Categories