ASSIGNING VISITNUM

Rakesh93 — Tue, 29 Oct 2019 18:42:35 GMT

How to assign visitnum when all the Tests are done on same date?

Re: ASSIGNING VISITNUM

PaigeMiller — Tue, 29 Oct 2019 18:43:13 GMT

Show us a portion of your data.

Re: ASSIGNING VISITNUM

Astounding — Tue, 29 Oct 2019 23:29:02 GMT

The computer is only a tool to carry out your wishes.

If you had the data sitting in front of you, and a pencil, what values would you assign? Give an example.

Re: ASSIGNING VISITNUM

ballardw — Fri, 01 Nov 2019 15:21:32 GMT

@Rakesh93 wrote:
How to assign visitnum when all the Tests are done on same date?

You really should show a brief example of your input data and what you would expect the output to look like.

And if your dates are not SAS Date values then creating such will be the first step.

I am guessing that you want the same visit number for each test on the same day and that the count should start over based on some sort of ID variable(s).

Here may be one way:

data have;
   input id date :date9. test $;
   format date date9.;
datalines;
1  01Jan2019 A
1  01Jan2019 B
1  01Jan2019 Q
1  01Jan2019 T
1  04Jan2019 Q
1  04Jan2019 T
1  08Jan2019 Z
1  08Jan2019 R
;

/* Next step Assumes the data is actually 
sorted by Id and date
*/

data want;
   set have;
   by id date;
   retain visitnum;
   if first.id then visitnum=1;
   else if first.date then visitnum+1;
run;

If it takes more than a single variable to identify an individual then you may need to provide a more detailed example.

topic Re: ASSIGNING VISITNUM in SAS Procedures

ASSIGNING VISITNUM

Re: ASSIGNING VISITNUM

Re: ASSIGNING VISITNUM

Re: ASSIGNING VISITNUM