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 |
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
How would you code the criteria to restrict the output to be produced?
how does sas handle missing values in procs? : Sas programming
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
describe how to adjust the performance of data integrator? : Sas-di
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is the difference between a PROC step and a DATA step?
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,