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.

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.

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.

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 Answers  

---

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,

---

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  

---

What are Dashboard reports?And significance of these in analysis?

1 Answers  

---

how do you validate sas program?

6 Answers   Accenture,

---

how does sas handle missing values in a merge? : Sas programming

0 Answers  

---

How do you specify the number of iterations and specific condition within a single do loop?

0 Answers  

---

How do you test for missing values?

0 Answers   Quintiles,

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers  

---

Mention how to limit decimal places for the variable using proc means?

0 Answers  

---

What is the order of evaluation of the following operators + - * / ** () ???

2 Answers  

---

how sas deals with business intelligence? : Sas-bi

0 Answers  

---