what are the validation tools in sas?
Answers were Sorted based on User's Feedback
Answer / jyotshna
for dataset
datasetname/debug
datasetname/stmtchk
for macros
options:
mprint mlogic symbolgen
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sirisha
format:for range checking
proc freq:used to check uniquenes
proc means:for statistical measurement,missing and non missingvalues.
macros: for reuse of the code
proc sort with nodupkey :to find duplicate observation
proc report:to create new variable etc.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / aruna
Jyotshna, can u elaborate on datasetname/debug and
datasetname/stmtchk
Is This Answer Correct ? | 0 Yes | 0 No |
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?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
What is the difference between one to one merge and match merge? Give an example.
What is the purpose of _error_?
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
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?
What are the Aggregate functions in SQL ?
How substr function works in sas?
How to create a permanent sas data set?
how to write code for left outer join in SAs using datastep?
What does proc print, and proc contents are used for?
what is treatment emergent events and treatment emregent adverse event