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 |
how can u extract,transform and loading?
Briefly explain input and put function?
Compare sas with other data analytics tools.
What Proc glm does?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
Tell me about % include and % eval? : sas-macro
How do you control the number of observations and/or variables read or written?
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
What is the difference between %local and %global? : sas-macro
what is function of retain statment
what is the use of proc contents and proc print in sas? : Sas-administrator
what is hash files in sas and why we are using this one in sas?