topic Re: How to create SUPPEG in SAS Health and Life Sciences

How to create SUPPEG

sasuser123123 — Mon, 30 Sep 2019 06:02:47 GMT

Hello!

I'm trying to create a supplementary EG data set
Could you please tell me that how to create a suppeg by using rawdata and how to link that dataset with main domain. Actually I did main domain perfectly but when I'm trying to create a SUPPEG I've lot of doubts about that. So could please tell me that process of creating a SUPP domains

Thank you!!

Re: How to create SUPPEG

Kurt_Bremser — Mon, 30 Sep 2019 07:37:07 GMT

First of all, show us example data so we have something to work with. Use a data step with datalines so we can easily create the dataset with copy/paste and submit.

Next, define what you mean by "supplementary". What should the new dataset contain in terms of structure (columns) and data? Supply rules for filling columns, if such are given.

Re: How to create SUPPEG

sasuser123123 — Mon, 30 Sep 2019 08:08:30 GMT

Thank you so much for your response..
So my data is..

Sub Visit HR PR QRS QT Find
101 Scr 73 154 110 428 Abnormal, not clsg
101 EOT 63 166 130 430 Abnormal, not clsg
101 FU 70 164 142 410 Abnormal, not clsg
102 Scr 70 150 86 428. normal
102 EOT 69 160 86 482 normal
102 FU 62 158 93 362 normal
103 Scr. 73. 154. 110. 428 Abnormal, not clsg

So I've 50 observations like that...

Note:
Scr=screening ,EOT=End of treatment, FU=follow up ,
Clsg=clinically significant.

The Variable 'Find' should be in the SUPPEG, because that variable not fit to the EG main domain.

Thank you!

Re: How to create SUPPEG

Kurt_Bremser — Mon, 30 Sep 2019 08:14:10 GMT

Please take more time to read and understand our answers. You have

not supplied data in usable form (data step with datalines)
not shown the intended structure of the new dataset
not given an example for its contents
not supplied any logical rule for doing this

Re: How to create SUPPEG

sasuser123123 — Mon, 30 Sep 2019 08:28:31 GMT

Sir, I hope you know structure of the SUPPEG data set
It contains the variables
Studyid,rdomain,usubjid,idvar,idvarval,qnam,qlabel,qval,qorig and qeval

Re: How to create SUPPEG

sasuser123123 — Mon, 30 Sep 2019 08:29:01 GMT

As per the SDTMIG

Re: How to create SUPPEG

Patrick — Mon, 30 Sep 2019 08:35:23 GMT

@sasuser123123

Below what providing sample data as a SAS data step means. This is work you should be doing for us so we can spend the time for solving the problem you need help with.

data have;
  infile datalines truncover dlm=' ,' dsd;
  input Sub Visit $ HR PR QRS QT Find $20.;
  datalines;
101 Scr 73 154 110 428 Abnormal, not clsg
101 EOT 63 166 130 430 Abnormal, not clsg
101 FU 70 164 142 410 Abnormal, not clsg
102 Scr 70 150 86 428. normal
102 EOT 69 160 86 482 normal
102 FU 62 158 93 362 normal
103 Scr. 73. 154. 110. 428 Abnormal, not clsg
;

proc print;
run;

"The Variable 'Find' should be in the SUPPEG, because that variable not fit to the EG main domain."

I have no idea what that means. Can you please try and explain to us what you have and what you need in a different way.

Ideally just show us how the desired state should look like if using the sample Have data as source.

Re: How to create SUPPEG

Patrick — Mon, 30 Sep 2019 08:41:15 GMT

@sasuser123123

After Googling a bit it appears that's Clinical Trials, CDISC stuff.

SAS gets used in many different industries and for many different purposes. Don't assume everybody just knows what SUPPEG means. You need to provide such background in your questions. You ideally also abstract the technical problem you need to solve to a level where also people without the specific industry background can provide an answer.

Re: How to create SUPPEG

Kurt_Bremser — Mon, 30 Sep 2019 09:21:09 GMT

@sasuser123123 wrote:
Sir, I hope you know structure of the SUPPEG data set
It contains the variables
Studyid,rdomain,usubjid,idvar,idvarval,qnam,qlabel,qval,qorig and qeval

No, I don't, because I am not a clinical SAS programmer. I needed to consult google to find out what you're talking about.

I will move your question to the Clinical Development community.

Re: How to create SUPPEG

sasuser123123 — Mon, 30 Sep 2019 09:24:34 GMT

Ohh I'm sorry!!
And Thank you!

Re: How to create SUPPEG

VinitvictorCorr — Mon, 30 Sep 2019 11:19:28 GMT

usually supplementary data for EG domain contains BEAT number or Repetition number for that particular ECG test. It is not necessary that every EG domains will contain supplementary information. Hence can you please elaborate as to what information do you need to populate in SUPPEG? Also if you have already created EG domain, can you please share that as well?

Re: How to create SUPPEG

VinitvictorCorr — Mon, 30 Sep 2019 11:22:19 GMT

Also a quick hint, whenever you post a question regarding clinical sas, you can mention it in the topic or at the start of your question so that it would not cause a misunderstanding. SAS is used in a lot of fields, and as this is a a global platform, we need to be somewhat a little more specific sometimes 🙂

Re: How to create SUPPEG

Kurt_Bremser — Mon, 30 Sep 2019 11:59:02 GMT

Especially with the "EG" acronym, which usually means Enterprise Guide around here 😉

Re: How to create SUPPEG

VinitvictorCorr — Tue, 01 Oct 2019 03:51:01 GMT

true story 😄

Re: How to create SUPPEG

blueskyxyz — Thu, 07 Jan 2021 14:59:38 GMT

data have;
  infile datalines truncover dlm=' ,' dsd;
  input Sub Visit $ HR PR QRS QT Find $20.;
  datalines;
101 Scr 73 154 110 428 Abnormal, not clsg
101 EOT 63 166 130 430 Abnormal, not clsg
101 FU 70 164 142 410 Abnormal, not clsg
102 Scr 70 150 86 428. normal
102 EOT 69 160 86 482 normal
102 FU 62 158 93 362 normal
103 Scr. 73. 154. 110. 428 Abnormal, not clsg
;

proc print;
run;

/*1. get egseq by key variables*/
data EG;
    set HAVE;
    by SUB ;
    EGSEQ+1;
    if first.SUB then EGSEQ=1;
	DOMAIN='EG';
run;

/*2. transpose data*/
proc transpose data=eg  out=suppeg1(where=(col1^=''));
  by SUB egSEQ  DOMAIN;
  var Find;
quit;

data suppeg2;
  length QVAL $200 QLABEL $40 QNAM $8 ;
  set suppEG1( rename=(DOMAIN=RDOMAIN) );
  IDVAR="EGSEQ";
  IDVARVAL=strip(put(EGSEQ,best.));
  if upcase(_NAME_)="FIND" then do;
    QNAM="FIND";
    QLABEL="FIND";
  end;
  QVAL=COL1;
  QORIG="CRF";
run;

Re: How to create SUPPEG

Ragineejoshi — Thu, 07 Jan 2021 15:07:00 GMT

Thank you so much.
Big help. I will practice this code.

Re: How to create SUPPEG

blueskyxyz — Fri, 08 Jan 2021 05:42:45 GMT

Welcome, could you treat my response as the answer? If possible, please read the materials in sdtm ig before doing sdtm datasets. https://www.cdisc.org/standards/foundational/sdtmig

Re: How to create SUPPEG

Ragineejoshi — Fri, 08 Jan 2021 14:34:00 GMT

Sure I will do that.

Thank you for guidance.

Re: How to create SUPPEG

blueskyxyz — Mon, 11 Jan 2021 03:37:23 GMT

please accept it as solution if I have solved your question.

Re: How to create SUPPEG

Ragineejoshi — Mon, 11 Jan 2021 18:41:11 GMT

I accept this as the solution of my problem.

I am sorry but in my screen there is no tab saying accept as a solution. So I am typing a message for that.