What do you feel about hardcoding?
Answers were Sorted based on User's Feedback
Answer / phani
hardcoding is explicitly stating the value of a symbolic
object or variable in a program
hardcoding is a bad proctice bcoz of 2 reasons:
1) it over rides the database controls in the clinical data
management systems and the CFR 21 Part 11 controls may be
compromised.
2) data often change in a trial over time and the hadcode
that is written today may not be valid in the future.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / saurabh gupta
It's a best practice not to hardcode values in code until
or unless it's not very necessary. Always try to use
dynamic variables in your code it will increase the
felxibility of the code.
Ex let say you have to run one of your code every year and
one of your condition needs a date which is begning of the
year and you hardcoded your value like this
%Let YBEG = '2007-01-01'
Then every year when you have to run this code you have to
change the date but if you use daynamic variable it will
resolve automatically.
ex YBEG = Y_BEG_0.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pnprasad
Hardcoding example:
data endstudy;
set endstudy;
if subjid = “xxxxxx” then
discterm = “Death”;
run;
it is known from non-database sources that at study
termination, subject
“xxxxxx” died.
With hardcoding there is no clear audit trail of data
change and CFR 21 – Part 11 controls might be considered
compromised.
Improved Hardcoding example;
data endstudy;
set endstudy;
**** HARDCODE APPROVED BY DR."nnn" AT SPONSOR ON 02/02/2008;
if subjid = “xxxxxx” and “&sysdate” <= “01MAY2005”d then
do;
discterm = "Death";
put “Subject “ subjid “hardcoded to termination reason”
discterm;
run;
For instance, there may be an upcoming data safety
and monitoring board (DSMB) or independent data monitoring
committee (IDMC)meeting where the clinical trial must be
monitored for safety information using the best
available data.
| Is This Answer Correct ? | 3 Yes | 1 No |
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
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?
What's the difference between VAR A1 - A4 and VAR A1 - A4?
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
who is the best SAS clinical Trainer in Hyderabad?
What is the command used to find missing values?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
what are the benefits of data integration? : Sas-di
How would you delete duplicate observations?
What do you understand by the term Normal Distribution?
What is the maximum length of the macro variable? : sas-macro
How to read an input file in sas?