What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
- 1 Answers
- 10368 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 |
What can be the size of largest dataset in SAS?
What’s the difference between var b1 – b3 and var b1 — b3?
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
Explain the special input delimiters used in sas programming.
how does sas handle missing values in an update? : Sas programming
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
What are the criticality that you have faced during your project in SAS?
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
Approximately what date is represented by the SAS date value of 730?
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
What is a method to debug and test your SAS program?
what is the primary variable in your study?
Teradata 
