What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
- 1 Answers
- 10666 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Briefly explain input and put function?
What are the ways to do a “table lookup” in sas?
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
Describe what are the different levels of administrative users in sas? : sas-grid-administration
is there any difference between proc summary and proc means?
What are Dashboard reports?And significance of these in analysis?
Difference between SAS STATA & SPSS?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
wt is a-z and a--z?
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
Have you ever used the SAS Debugger?
where to use sas business intelligence? : Sas-bi
Teradata 
