What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
- 1 Answers
- 10898 Views
- TCS, I also Faced
- E-Mail Answers
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
What is the difference between %put and symbolgen? : sas-macro
What are the default statistics for means procedure?
What is the good sas programming practices for processing large data sets?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What is the length assigned to the target variable by the scan function?
State the difference between INFORMAT and FORMAT ?
How do you debug and test your SAS programs?
Describe a time when you were really stuck on a problem and how you solved it?
What is proc sort?
How does proc sql work?
how do you test for missing values? : Sas programming
how could you generate test data with no input data? : Sas programming
explain about various caches available in data integrator? : Sas-di
How many data types are there in SAS?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
