What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
- 1 Answers
- 10381 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 |
Explain the difference between using drop = data set option in set and data statement?
How does proc sql work?
What is the purpose of the trailing and How would you use them?
how does sas handle missing values in procs? : Sas programming
Are you familiar with special input delimiters How are they used?
How can you create a macro variable with in data step? : sas-macro
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What are the ways in which macro variables can be created in sas programming?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is slowly changing dimension? : Sas-di
Teradata 
