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 do the mod and int function do? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what do the pad and dim functions do? : Sas programming
What do you know about symput and symget?
What is PROC in SAS?
What are the difference between the sas data step and sas procs?
If a variable contains letters or special characters, can it be numeric data type?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Intern stastical programmer written test
What is the difference between where and if statement?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how will you location sas platform applications available from web browser? : Sas-bi
what are the component of range? : Sas-bi