Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

Answers were Sorted based on User's Feedback



How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? ..

Answer / vijaibhaskar

1. put statement and debug option is used for debug and
test the programs.
2.NMISS OPTION is used for missing values
3.line pointer is used for multiple lines per observation
@@ is used for multiple observations per line
4. ARRAYS IS USED FOR PROCESSING FOR LARGE DATA SET
5. WHEN DATA SET IS CREATED SAS CREATE DISCRIPTOR PORTION
AND DATA PORTION .THAT MEANS SAS STORES THE INFOMATION LIKE
VARIABLE NAME ,LENGTH,TYPE etc.
6.variable+expression.
sum function
u write renames of the variables in first data set if
same variable names are exit in second data set
missing values in transction data set does nt over write
the master data set in update statement.
NMISS OPTION

Is This Answer Correct ?    3 Yes 2 No

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? ..

Answer / 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 ?    2 Yes 1 No

Post New Answer

More SAS Interview Questions

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  


I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 Answers  


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

0 Answers  


Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.

2 Answers  


What is maximum number of rows and cols can be handled in SAS?

0 Answers   Signetsoft,






How does the internal authentication work in sas? : sas-grid-administration

0 Answers  


how does sas handle missing values in functions? : Sas programming

0 Answers  


What is highest missing value for numeric?

1 Answers  


Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  


What are Dashboard reports?And significance of these in analysis?

1 Answers  


One way of creating a new variable in Macros is by % Let....What is the other way..?

5 Answers   TCS,


Mention what is the difference between nodupkey and nodup options?

0 Answers  






Categories