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
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
What other SAS features do you use for error trapping and
How does SAS handle missing values in: assignment
statements, functions, a merge, an update, sort order,
Answers were Sorted based on User's Feedback
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.
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.
|Is This Answer Correct ?||3 Yes||2 No|
Answer / admin
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|
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?
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?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
What is maximum number of rows and cols can be handled in SAS?
How does the internal authentication work in sas? : sas-grid-administration
how does sas handle missing values in functions? : Sas programming
What is highest missing value for numeric?
Code a PROC MEANS that shows both summed and averaged output of the data.
What are Dashboard reports?And significance of these in analysis?
One way of creating a new variable in Macros is by % Let....What is the other way..?
Mention what is the difference between nodupkey and nodup options?