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?
Answers were Sorted based on User's Feedback
Answer / kumaraswamy maduri
Using MISSOVER or TRUNCOVER. TRUNCOVER is best because if
the last variable doesn't have value then it assigns
missing as just as missover one extra difference with
TRUNCOVER is, if you are using formatted input and the
width is more than the value still truncover reads the
available value but missover assigns a missing.
Eg: data t;
input num 3.;
cards;
1
12
121
;
run;
Check the above code using missover and truncover.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / nitin
By using stopover, missover is used to read next record
without stopping.
| Is This Answer Correct ? | 6 Yes | 2 No |
why a stop statement is needed for the point= option on a set statement?
What is SAS? What are the functions does it performs?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
AE datasets names? how many types?
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
what is the use of catalog?
what is option year cuttoff in sas
how could you generate test data with no input data? : Sas programming
Give e an example of..
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
How to include or exclude specific variables in a data set?