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 are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
what are input dataset and output dataset options? : Sas programming
Name validation tools used in SAS
What commands are used in the case of including or excluding any specific variables in the data set?
what is factor analysis? : Sas-administrator
for whom is sas data integration studio designed? : Sas-di
How do you debug and test your SAS programs?
what is the difference between the SAS v8 and SAS v9?
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
what are some differences between proc summary and proc means? : Sas programming
How would you delete observations with duplicate keys?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?