topic Re: Trouble with count variable in SAS Programming

Trouble with count variable

edu — Fri, 03 Feb 2017 03:37:07 GMT

Hi, I am new in SAS and trying to do a basic count varible but after it count the first observation the count variable remains the same.

Here the code:

DATA WORK.A;

SET B;

IF (X NE . OR X NE 0)

THEN

DO;

COUNT + 1;

END;

;RUN;

Thanks for the help.

Re: Trouble with count variable

art297 — Fri, 03 Feb 2017 03:54:17 GMT

If you want to increment count when x doesn't equal either missing or 0, then you're boolean logic is wrong. Try:

DATA WORK.A;
SET B;
 
IF (X NE . and X NE 0)
THEN
DO;
 COUNT + 1;
END;
 
RUN;

HTH,

Art, CEO, AnalystFinder.com

Re: Trouble with count variable

Kurt_Bremser — Fri, 03 Feb 2017 09:06:35 GMT

If you already have a variable count in dataset b, this won't work, as the values read from the dataset will override your increment.

Re: Trouble with count variable

RW9 — Fri, 03 Feb 2017 09:50:30 GMT

Tip 1, make your code nice and readble, this is more important than what it actually does in most cases:

data work.a; 
  set b;
  if _n_=1 then count=0;
  count=count + ifn(x not in (.,0),1,0);
run;

Note the consistent casing, and the indentations, and also the use of the code window (either {i} above your post or the SAS one). I would also avoid naming datasets a and b.

Tip 2, post test data in the form of a datastep:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Remember we cannot see your computer, we don't know what your data looks like.