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 |
what other SAS features do you use for error trapping and data validation?
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
Describe a time when you were really stuck on a problem and how you solved it?
How do you connect the desktop application to metadata server? : sas-grid-administration
What is highest missing value for numeric?
what is the basic structure sas administrator? : Sas-administrator
What are the advantages of using sas?
What is the one statement to set the criteria of data that can be coded in any step?
in data set200 observation how to take 110,150,170 using sql procedure?
how do you validate sas program?
What are the five ways to do a table lookup in sas? : sas-grid-administration
How would you define the end of a macro? : sas-macro