What is the difference between a PROC step and a DATA step?
Answers were Sorted based on User's Feedback
Answer / kiran datir
The DATA Step is a true workhorse. It allows you to create multiple datasets in one swift step. PROC step requires several SELECT clauses to create multiple datasets.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ju_rk
DATA step is a sequential process (one at a time for each observation), whereas the SQL procedure is a simultaneous process for all the observations.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vj
Data Step processes data ROW-wise.
Proc Step processes data COLUMN-wise.
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / surekha
pankaj's answer is completely true
@pankaj have u taken any training course of SAS
Is This Answer Correct ? | 1 Yes | 7 No |
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
Mention the difference between ceil and floor functions in sas?
What is slibref?
Can we create datasets by proc step ? (Proc contents, Means)?
How do you debug and test your SAS programs?
What do you know about sas data set?
What techniques and/or PROCs do you use for tables?
what is the effect of the options statement errors=1? : Sas programming
Explain the difference between nodup and nodupkey options?
What are the criticality that you have faced during your project in SAS?
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.