What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
- 1 Answers
- 10401 Views
- TCS, I also Faced
- E-Mail Answers
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 are the sites did u refer for enquiries and doubts for SAS
what is the effect of the options statement errors=1? : Sas programming
What are the statements in proc sql?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what are the types of interactive display types? : Sas-bi
Explain the difference between nodup and nodupkey options?
what is the main difference between rename and label? (don't say that they both perform the same function).
How do handle working under pressure?
Explain the use of proc gplot? : sas-grid-administration
describe how to adjust the performance of data integrator? : Sas-di
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
Teradata 
