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?
- 2 Answers
- 16119 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 specify the number of iterations and specific condition within a single do loop?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
do you prefer proc report or proc tabulate? Why? : Sas programming
How can sas program be validated?
is QUALCOMM using SAS ?
what is Enterprise Guide?what is the use of it?
Explain how you can debug and test your SAS program?
Explain input and put function?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
Teradata 
