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 |
what is intially documentation for a sas programmer?
How do dates work in SAS data?
What is the difference between SAS functions and procedures?
what is the formula to measure Baseline
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
What is substr function?
Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
What does the trace option do?
What do you know about sas and what we do? : sas-grid-administration
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
what is program data vector? : Sas-administrator
what are the best practices to process the large data sets in sas programming? : Sas-administrator