What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
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 the difference between INPUT and INFILE ?
Describe a time when you were really stuck on a problem and how you solved it?
what is hierarchy flattening? : Sas-di
Differences between where and if statement?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
it will become easy if uuu provide website linkssss and list of consultanciessssss
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What do you know about symput and symget?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what is data governance? : Sas-di
Explain proc univariate?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What are the advantages of using sas?
How do you delete duplicate observations in sas?
What do you know about sas and what we do? : sas-grid-administration