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?
Answer Posted / 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 |
Post New Answer View All Answers
What are the default statistics that proc means produce?
what are the types of interactive display types? : Sas-bi
What is the use of %include statement?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is the basic structure of the SAS base program?
What areas of SAS are you most interested in?
what is the difference between infile and input? : Sas-administrator
How to read an input file in sas?
What is SAS informats?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is the difference between INPUT and INFILE ?
what is function of retain statment
How we can call macros with in data step? : sas-macro
What are the statements that are executed only?
What is connection profile? : sas-grid-administration