topic Continue the Count value in the existing variable in SAS Programming

Continue the Count value in the existing variable

Sathish_jammy — Sat, 25 May 2019 08:06:18 GMT

Hi Experts,

I have a dataset which contains 3 visits to ID.

data have;
input Id Count var1;
cards;
12 1 56
12 2 45
12 3 65
25 1 87
25 2 98
25 3 23
;

Now I added,

15 nos - 12

20 nos - 25 in the Id variable. (Only Id not other variables)

I have to continue the count value as followed which already exist.

Please suggest some Ideas to solve this problem.

Thanks in advance!

Re: Continue the Count value in the existing variable

ScottBass — Sat, 25 May 2019 09:12:34 GMT

I don't understand. Post two data steps:

Your changes:

Now I added,

15 nos - 12

20 nos - 25 in the Id variable. (Only Id not other variables)

And your desired results:

I have to continue the count value as followed which already exist.

Huh??? What are you trying to say here?

Re: Continue the Count value in the existing variable

Sathish_jammy — Sat, 25 May 2019 09:43:08 GMT

Dear @ScottBass

I'm Sorry for the trouble, Let me explain in detail...

data Dataset1;
input Id Count var1;
cards;
12 1 56
12 2 45
12 3 65
25 1 87
25 2 98
25 3 23
;

data Dataset2;
input Id;
cards;
12
12
12
12
12
25
25
25
25
;

I merged these 2 datasets as given below. I need to continue the Count value (Mentioned in Bold) which followed by the existing value from 3.

Id	Count	Var1
12	1	56
12	2	45
12	3	65
25	1	87
25	2	98
25	3	23
12	4
12	5
12	6
12	7
12	8
25	4
25	5
25	6
25	7

Re: Continue the Count value in the existing variable

Ksharp — Sat, 25 May 2019 11:15:24 GMT

data Dataset1;
input Id Count var1;
cards;
12 1 56
12 2 45
12 3 65
25 1 87
25 2 98
25 3 23
;
data Dataset2;
input Id;
cards;
12
12
12
12
12
25
25
25
25
;

data temp;
 set dataset1 dataset2(in=inb);
 by id;
 flag=inb;
 drop count;
run;
data want;
 set temp;
 by id;
 if first.id then count=0;
 count+1;
run;
proc sort data=want;
by flag id;
run;

Re: Continue the Count value in the existing variable

PeterClemmensen — Sat, 25 May 2019 11:15:45 GMT

Just to be clear, Var1 will have missing values for those observations, correct?

Re: Continue the Count value in the existing variable

Sathish_jammy — Sat, 25 May 2019 11:41:04 GMT

Exactly...

Re: Continue the Count value in the existing variable

PeterClemmensen — Sat, 25 May 2019 11:46:46 GMT

The desired result is in Dataset1 with this approach

data temp;
   do until (last.Id);
      set Dataset1;
      by Id;
   end;
   call missing(var1);
   do until (last.Id);
      set Dataset2;
      by Id;
      Count=Count+1;
      output;
   end;
run;

proc append base=Dataset1 data=temp;
run;