**** DUPLICATE THE INCOMING DATASET FOR OVERALL COLUMN CALCULATIONS
**** SO NOW TRT HAS VALUES 0 = PLACEBO, 1 = ACTIVE, AND 2 = OVERALL.;
data adsl; ➊
set adsl;
output;
trtpn = 2;
output;
run;
Can someone explain the trtpn=2; output ; for overall column calculation..I came across this in the Sas for pharama book.
Thanks.
Assuming that there is a variable trtpn in the data set this would create a new row for each observation with a different value of trtpn. A quick way of duplicating data or adding records when required. Note the number of records in each dataset.
Here's an example you can run:
data class;
set sashelp.class;
Class=1;
run;
data class_duplicates;
set class;
output;
Class=2;
output;
run;
proc freq data=class_duplicates;
table class;
run;
this is creating a variable named trtpn with a value of 2.
Assuming that there is a variable trtpn in the data set this would create a new row for each observation with a different value of trtpn. A quick way of duplicating data or adding records when required. Note the number of records in each dataset.
Here's an example you can run:
data class;
set sashelp.class;
Class=1;
run;
data class_duplicates;
set class;
output;
Class=2;
output;
run;
proc freq data=class_duplicates;
table class;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.