topic Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset in SAS Health and Life Sciences

--TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Hsas — Thu, 06 Oct 2016 04:50:25 GMT

Hi,

How to populate --TESTCD for the NOT DONE records in an SDTM dataset. eg.

in VS dataset per subject if there are 5 parameters out of which if one is not done then the TESTCD should be of that parameter and VSSTAT=NOT DONE. However for this visit if all parameters are NOT DONE then the entire panerfor that visit per subject should be collapsed to 1record with VSTESTCD=VSALL. How can this be done using SAS? Please help.

Thanks,

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

LinusH — Thu, 06 Oct 2016 06:14:23 GMT

Sorry, but what are you talking about?

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Reeza — Thu, 06 Oct 2016 06:52:19 GMT

Is this in SAS Clinical?

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Hsas — Thu, 06 Oct 2016 07:10:25 GMT

Yes in SDTM clinical SAS.

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Reeza — Thu, 06 Oct 2016 07:16:11 GMT

I've moved your post to the Healthcare forum. That said there aren't a lot of people who use this particular application on here.

I would highly recommend contacting SAS Tech Support. That's what you pay them for after all 🙂

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Hsas — Thu, 06 Oct 2016 07:20:59 GMT

ok thank you.

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

RW9 — Thu, 06 Oct 2016 08:48:06 GMT

Well, if you can code its pretty simple:

data have;
  length usubjid vstestcd vsstatus $20;
  usubjid="001"; vstestcd="PULSE"; vsstatus=""; output;
  usubjid="001"; vstestcd="HEIGHT"; vsstatus=""; output;
  usubjid="002"; vstestcd="PULSE"; vsstatus="NOT DONE"; output;
  usubjid="002"; vstestcd="HEIGHT"; vsstatus="NOT DONE"; output;
run;

proc sql;
  create table WANT as
  select  *
  from    HAVE
  where   USUBJID not in (select distinct USUBJID from (select * from HAVE where VSSTATUS="NOT DONE") group by USUBJID having count(*)=2)
  union all
  select  distinct
          USUBJID,
          "VSALL" as VSTESTCD,
          VSSTATUS
  from    HAVE
  where   USUBJID in (select distinct USUBJID from (select * from HAVE where VSSTATUS="NOT DONE") group by USUBJID having count(*)=2);
quit;

Obviously change it to match your data.

Re: --TESTCD XXALL for NOT DONE records in Findings SDTM dataset

Hsas — Wed, 12 Oct 2016 03:03:54 GMT

Thank you.