How to create SUPPEG

[sasuser123123]

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!!

[Kurt_Bremser]

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.

[sasuser123123]

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!

[Kurt_Bremser]

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

[Patrick]

@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.

[sasuser123123]

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

[Patrick]

@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.

[Kurt_Bremser]

---

@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.

[sasuser123123]

As per the SDTMIG

[sasuser123123]

Ohh I'm sorry!!
And Thank you!

[VinitvictorCorr]

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?

[VinitvictorCorr]

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 🙂

[Kurt_Bremser]

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

[VinitvictorCorr]

true story 😄

[blueskyxyz]

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;