topic Better subject line needed in SAS Studio

Count variable value changes

Madhav4114 — Fri, 17 Feb 2023 08:47:00 GMT

Help me find solutions for below problem
Date. Newkey. Flag
Dec16. 13. 0
Jan17. 13. 1
Feb17. 13. 1
Mar17. 13. 1

Need to find total cases as to how many times the flag switched from 0 to 1 in above table

Re: SAS code

PeterClemmensen — Thu, 16 Feb 2023 11:12:55 GMT

What does your desired result look like?

Re: SAS code

RW9 — Thu, 16 Feb 2023 11:19:59 GMT

Not tested (pop test data in the form of a data step please):

data want;
  set have;
  retain num_times 0;
  if lag(flag)=0 and flag=1 then num_times=sum(num_times,1);
run;

Last record would have your total number of times. You could also do it via sql to join lowest previous date to current record as well.

Better subject line needed

PaigeMiller — Thu, 16 Feb 2023 12:15:56 GMT

Please go back to your ORIGINAL post and provide a subject line that describes the problem. A subject line of "SAS Code" could apply to 99% of the posts here, and so has no value in describing the problem. Help us out, please; we're trying to help you.

Re: Count variable value changes

s_lassen — Thu, 16 Mar 2023 08:32:37 GMT

If you just need the count, you can do like this:

data want;
  retain count -1; /* the first record should set count to 0 */
  set have end=done;
  by flag notsorted;
  count+first.flag;
  if done;
  keep count;
run;