topic Prc sql count (distinct USUBJID || AEDECOD) what does the || symbol mean here in SAS Programming

Prc sql count (distinct USUBJID || AEDECOD) what does the || symbol mean here

Akter — Wed, 11 Jan 2023 20:01:34 GMT

What does the code Count (distinct usubjid || aedecod). why concatenation operator (II) given in between usubjid and aedecod? what does concatenation operator mean and when do we write in that way.

see part of the code below:

*******

proc sql;

create table table1 as select distinct COHORTN, count (distinct USUBJID || AEDECOD) as num, 2 as cat from adae;

group by COHORTN;

quit;

*******

Thank you!

Re: Prc sql count (distinct USUBJID || AEDECOD) what does the || symbol mean here

ballardw — Wed, 11 Jan 2023 20:09:49 GMT

Why? Ask the person that wrote the code.

Must have wanted to count the number of combinations of those two variables.

If you don't know what "concatenation" means it basically means stick things together.

Example:

data example;
   thisvar = "Some text";
   thatvar = "yet more text";
   combined = thisvar||thatvar;
   put combined=;
run;

When? When it does what you want.

Re: Prc sql count (distinct USUBJID || AEDECOD) what does the || symbol mean here

Akter — Thu, 12 Jan 2023 15:22:16 GMT

probably i got the answer:

"count (distinct USUBJID || AEDECOD)" this counts the distinct number of records for both USUBJID and AEDECOD. If any USUBID has two same AEDECOD (i.e if any subject has two records for Hypotension) it counts One.

Thanks!