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
- 11670 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 good sas programming practices for processing large data sets?
How sas treats the dsd delimiters?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Name and describe few sas character functions that are used for data cleaning in brief.
what is the difference between infile and input? : Sas-administrator
How substr function works in sas?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What is run-group processing?
how do the in= variables improve the capability of a merge? : Sas programming
What is a put statement?
What is the use of stop statement?
What do the SAS log messages "numeric values have been converted to character" mean?
what is metadata? : Sas-bi
List down the reasons for choosing sas over other data analytics tools.
Differentiate input and infile.
