Creating a new variable

Dhana18 — Fri, 23 Aug 2019 11:04:59 GMT

I have a data set that has

CollDate1

Specimen1

TestType1

Result1

CollDate2

Specimen2

TestType2

Result2

CollDate3

Specimen3

TestType3

Result3

Treatment_Date1

STDCDCRecTreatment1

7/31/2019

Pharyngeal

Culture

Not Applicable (e.g. Culture positive for N. Meningitides)

7/31/2019

Urethral

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Endocervical

Culture

GC Negative

7/30/2019

Pharyngeal

Culture

Not Applicable (e.g. Culture positive for N. Meningitides)

7/30/2019

Endocervical

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Pharyngeal

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Urethral

Culture

GC Negative

7/30/2019

Endocervical

Culture

GC Negative

7/30/2019

Pharyngeal

GC nucleic acid amplification test (NAAT)

GC Positive

7/30/2019

Urine

GC nucleic acid amplification test (NAAT)

GC Positive

7/30/2019

Urethral

Culture

GC Positive

7/30/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/30/2019

Urine

GC nucleic acid amplification test (NAAT)

GC Positive

8/1/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/30/2019

Urine

GC nucleic acid amplification test (NAAT)

GC Positive

7/30/2019

Pharyngeal

GC nucleic acid amplification test (NAAT)

GC Positive

7/30/2019

Urethral

Culture

GC Positive

7/30/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/30/2019

Urine

GC nucleic acid amplification test (NAAT)

GC Positive

7/30/2019

Urethral

Culture

GC Positive

7/30/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/29/2019

Urethral

Culture

GC Positive

7/29/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/29/2019

Urethral

Culture

GC Positive

7/29/2019

Ceftriaxone 250 mg IM in a single dose AND same day treatment with Azithromycin 1g orally in a single dose (Gonorrhea)

7/29/2019

Rectal

Culture

GC Negative

7/29/2019

Pharyngeal

GC nucleic acid amplification test (NAAT)

GC Negative

7/29/2019

Urethral

Culture

GC Negative

7/29/2019

Pharyngeal

Culture

Not Applicable (e.g. Culture positive for N. Meningitides)

7/29/2019

Endocervical

Culture

GC Negative

7/29/2019

Urethral

Culture

Not Applicable (e.g. Culture positive for N. Meningitides)

7/29/2019

Endocervical

Culture

GC Negative

I would like to know number of tests conducted for each ID and number of Spe collected and number of pos result for each ID. How do i create a separate column of number of spe number of tests and number of pos result by specimen.

Also i would like to get time frame between positive test and treatment date.

Please help

Re: Creating a new variable

Shmuel — Fri, 23 Aug 2019 12:48:43 GMT

Try next code and adapt it to your request:

data temp;
 set have;
       keep ID Colldate1 Sprcimen1 TestTye1 Result1;
       output;  /* left test */
       if not missing (colldate2) then do;
           colldtae1 = colldate2; 
           specimen1 = specimen2;
           testtype1 = testtype2;
          result1 = result2;
          output;
       end;
run;

Now it is easy to count using proc freq or any other method.:

topic Creating a new variable in SAS Programming

Creating a new variable

Re: Creating a new variable