topic How to replace values of set of variables in SAS Data Management

How to replace values of set of variables

khalidamin — Mon, 10 Apr 2017 22:34:41 GMT

Hi guys,

Can someone help me to change the dataset according to the following?

Thank you.

Khalid

Re: How to replace values of set of variables

Reeza — Mon, 10 Apr 2017 22:45:33 GMT

Whats the rule? All 8s or all the same value? What if you have two the same value and one is missing.

You can use MIN/MAX logic - if the min=max then the values are the same and you can use CALL MISSING to set variables to missing.

Useful functions:

N - returns number of non missing

NMISS - returns the number of missing

MIN - returns minimum value

MAX - returns max value

CALL MISSING() - sets variables designated to as missing - doesn't matter if they're character or numeric.

PS. Post data not in images but at least as text, ideally as a data step. We can't write code based on an image so that would mean typing out your dataset.

Re: How to replace values of set of variables

art297 — Tue, 11 Apr 2017 00:19:50 GMT

or just use something like:

data want;
  set have;
  array vars(*) v1-v3;
  if v1=v2=v3 then call missing(of vars(*));
run;

Art, CEO, AnalystFinder.com

Re: How to replace values of set of variables

khalidamin — Tue, 11 Apr 2017 14:50:52 GMT

Thank you for your comments. I want to consider 8s as missing when they are in all variables. For example, if v1=v2=v3=8, then

v1=v2=v3=missing. @Reeza

Re: How to replace values of set of variables

khalidamin — Tue, 11 Apr 2017 14:52:34 GMT

I want 'if v1=v2=v3=8 THEN 'v1=v2=v3=missing'.

Re: How to replace values of set of variables

Reeza — Tue, 11 Apr 2017 14:55:37 GMT

If v1=8 and v2=8 and v3 =8 then call missing(v1, v2, v3);

Re: How to replace values of set of variables

art297 — Tue, 11 Apr 2017 15:05:38 GMT

Nothing wrong with grouping them together. e.g.:

data want;
  set have;
  if v1=v2=v3=8 then call missing(of v1-v3);
run;

Art, CEO, AnalystFinder.com

Re: How to replace values of set of variables

khalidamin — Tue, 11 Apr 2017 16:32:07 GMT

Awesome! Thank you @art297 🙂