Why is a STOP statement needed for the point=option on a
SET statement?
Answers were Sorted based on User's Feedback
Answer / latha sunkara
When you use the POINT= option, you must include a STOP
statement to stop DATA step processing, programming logic
that checks for an invalid value of the POINT= variable, or
both. Because POINT= reads only those observations that are
specified in the DO statement, SAS cannot read an end-of-
file indicator as it would if the file were being read
sequentially. Because reading an end-of-file indicator ends
a DATA step automatically, failure to substitute another
means of ending the DATA step when you use POINT= can cause
the DATA step to go into a continuous loop.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / dupe
just to add to the previous answer, if the stop statement
is executed, SAS cannot proceed to the bottom of the
datastep, where a run statement is encountered which forces
an explisit output of observation. To overcome this, you
will need to include the output statement before the stop
statement.
Is This Answer Correct ? | 3 Yes | 2 No |
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
how do u validate the program which u have written.
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How can you put a "trace" in your program?
what is the use of LRECL option.
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Why is SAS considered self-documenting?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
name some data transformation used in sas di? : Sas-di