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 |
Tell me more about the parameters in macro? : sas-macro
what is the use of proc sql?
What are the Aggregate functions in SQL ?
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
How experienced are you with customized reporting and use of Data _Null_ features?
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
What are SAS/ACCESS and SAS/CONNECT?
Differentiate input and infile.
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
If a variable contains only numbers, can it be a character data type?
describe about joins? briefly?