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 / 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

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

Post New Answer

More SAS Interview Questions

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  


in data set200 observation how to take 110,150,170 using sql procedure?

7 Answers   Accenture,


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,


Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

0 Answers  






How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

0 Answers  


This entry was posted in General. Bookmark the permalink. Post a comment or leave

0 Answers   Quintiles,


explain what is data set in sas? : Sas-administrator

0 Answers  


/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

2 Answers   Eval Source,


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  


name several ways to achieve efficiency in your program? : Sas programming

0 Answers  


Approximately what date is represented by the SAS date value of 730?

0 Answers  


Categories