topic Re: SAS_Specific Value for rows in SAS Programming

Set value based on other value

Khaladdin — Thu, 12 Jan 2017 11:35:05 GMT

I want to give the value for some specific rows. I think showing it by example would be better. I have following datasheet;

 Date                 Value
01/01/2001          10
02/01/2001          20
03/01/2001          35
04/01/2001          15
05/01/2001          25
06/01/2001          35
07/01/2001          20
08/01/2001          45
09/01/2001          35

My result should be:

 Date                 Value    Spec.Value
 01/01/2001          10        1
 02/01/2001          20        1
 03/01/2001          35        1
 04/01/2001          15        2
 05/01/2001          25        2
 06/01/2001          35        2
 07/01/2001          20        3
 08/01/2001          45        3
 09/01/2001          35        3

As you can see, my condition value is 35. I have three 35. I need to group my date by using this condition value.

Re: SAS_Specific Value for rows

RW9 — Thu, 12 Jan 2017 10:58:51 GMT

I haven't run this, as not typing in that test data. For future reference post test data in the form of a datastep:

data want;
  set have;
  retain spec_value 1;
  output;
  if value=35 then spec_value=sum(spec_value,1);
run;

Re: SAS_Specific Value for rows

Khaladdin — Thu, 12 Jan 2017 11:07:17 GMT

Many thank. It works:)

Re: SAS_Specific Value for rows

Reeza — Thu, 12 Jan 2017 13:33:03 GMT

@Khaladdin Please mark the question answered.

Re: SAS_Specific Value for rows

Khaladdin — Thu, 12 Jan 2017 13:37:41 GMT

I accept the answer as a right answer. Is that enough? @Reeza