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?
- 3 Answers
- 12559 Views
- Accenture, I also Faced
- E-Mail Answers
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 is the purpose of _character_ and _numeric_?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How would you invoke a macro? : sas-macro
what is sas database server? : Sas-di
What is the difference between INPUT and INFILE ?
What are the prime responsibilities of data integration administrator? : Sas-di
What is the general format of function in sas? : sas-grid-administration
Differentiate between format and informat? : sas-grid-administration
What would be the value of month at the end of data step execution and how many observations would be there?
Have you ever used the SAS Debugger?
do you need to know if there are any missing values? : Sas programming
How necessary is it to be creative in your work?
If a variable contains only numbers, can it be a character data type?
What are the difficulties u faced while doing vital signs table or dataset?
