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 is sas enterprise intelligence architecture? : Sas-bi
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
How we can call macros with in data step? : sas-macro
Describe a time when you were really stuck on a problem and how you solved it?
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
What is interleaving in SAS?
what is study design in while working with SAS? what are screening variables in SAS?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
How would you keep from overlaying the a SAS set with its sorted version?