topic Re: Increase count sequence when encountering a specific visit value in SAS Programming

Increase count sequence when encountering a specific visit value

jenim514 — Wed, 08 Apr 2020 22:27:19 GMT

Hi all!

I have a counting visit question 🙂 For ONE subject, if I had visits A1 A3 D1 LD and again A1 A2 A3 D1 (all on different dates). Whenever encountering 'A1', i want to increase the count variable.

So the sorted visits look like

A1 A3 D1 LD A1 A2 A3 D1

and the counting sequence I want is 1 1 1 1 2 2 2 2

Here is my failed attempt:

data endptx;
set endpt00;
by usubjid vst_num vsdat;
count=0;
if vst_num='A1' then count+1;

run;

Re: Increase count sequence when encountering a specific visit value

ballardw — Wed, 08 Apr 2020 22:30:17 GMT

I suspect that you want to reset the count to 0 when each USUBJID is encountered.

data endptx;
set endpt00;
by usubjid vst_num vsdat;
if first.usubjid then count=0;
if vst_num='A1' then count+1;

run;

If that does not provide what you need then you will need to provide some example data for input and the expected output for the given example. Best is to provide the example data in the form of data step code.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

Re: Increase count sequence when encountering a specific visit value

Patrick — Wed, 08 Apr 2020 22:30:35 GMT

What about:

data endptx;
  set endpt00;
  by usubjid vst_num vsdat;
  if first.usubjid then count=0;
  if vst_num='A1' then count+1;
run;