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?
- 1 Answers
- 11588 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
what is enterprise guide? What is the use of it? : Sas programming
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How does the internal authentication work in sas? : sas-grid-administration
how are numeric and character missing values represented internally? : Sas programming
How can you create a macro variable with in data step? : sas-macro
Mention what are the data types does SAS contain?
How to convert a numeric variable to a character variable?
Mention what is the difference between nodupkey and nodup options?
how does sas handle missing values in assignment statements? : Sas programming
what are informats in sas? : Sas-administrator
Explain what is the use of proc gplot?
What does PROC print, and PROC contents do?
What are the different servers in sas? : sas-grid-administration
In proc transpose and data step with arrays which one you pick?
