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
how can you import .csv file in to sas? : Sas programming
What is your favorite all time computer book? Why?
Explain append procedure?
What is the use of stop statement?
What are the default statistics that proc means produce?
If you could design your ideal job, what would it look like?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Explain the purpose of retain statement.
Why double trailing @@ is used in input statement?
what is the use of proc contents and proc print in sas? : Sas-administrator
What are the functions which are used for character handling functions?
what are input dataset and output dataset options? : Sas programming
What are the 3 components in sas programming?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What is the function of Stop statement in a SAS Program?