How do you debug and test your SAS programs?
What can you learn from the SAS log when debugging?
How do you test for missing values?
How would you create multiple observations from a single
observation?
What are some good SAS programming practices for processing
very large data sets?
Briefly describe 5 ways to do a "table lookup" in SAS.
Why is SAS considered self-documenting?
Are you sensitive to code walk-throughs, peer review, or QC
review?
What other SAS features do you use for error trapping and
data validation?
How does SAS handle missing values in: assignment
statements, functions, a merge, an update, sort order,
formats, PROCs?
Answer Posted / admin
http://sas-4-u.com/4um/index.php?topic=63.0;
When you check for ordinary missing numeric values, you can use code that is similar to the following:
if numvar=. then do;
If your data contains special missing values, you can check for either an ordinary or special missing value with a statement that is similar to the following:
if numvar<=.z then do;
To check for a missing character value, you can use a statement that is similar to the following:
if charvar=' ' then do;
The MISSING function enables you to check for either a character or numeric missing value, as in:
if missing(var) then do;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How is character variable converted into numeric variable and vice versa?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is the primary data source for the wrs? : Sas-bi
How necessary is it to be creative in your work?
Which statement does not perform automatic conversions in comparisons?
how does sas handle missing values in formats? : Sas programming
how does sas handle missing values in procs? : Sas programming
What is a pdv and what are its functions?
explain the difference between proc means and proc summary?
what is the difference between infile and input? : Sas-administrator
describe how to adjust the performance of data integrator? : Sas-di
What does the trace option do?
What is the SAS data set?
How to limit decimal places for variable using proc means?
What are all the problems you faced while validating tables and reports?