topic Re: how to remove values in a row in SAS Programming

how to remove values in a row

Amy0223 — Thu, 24 Sep 2020 19:15:43 GMT

Hi everyone!

I have a SAS question about how to remove some values in a row and only keep the first column and the last column which is the total. Thanks so much!

Re: how to remove values in a row

PaigeMiller — Thu, 24 Sep 2020 19:19:02 GMT

The easiest thing to do is simply delete variables c0 through c4.

Re: how to remove values in a row

Amy0223 — Thu, 24 Sep 2020 19:22:12 GMT

Thanks! How to program it to delete those values?

Re: how to remove values in a row

PaigeMiller — Thu, 24 Sep 2020 19:24:14 GMT

Clarification: I said delete the variables, not delete the values.

data want;
    set have;
    drop c0-c4;
run;

Re: how to remove values in a row

Amy0223 — Thu, 24 Sep 2020 19:29:27 GMT

Is there a way to keep the variables but only delete c0-c4 values?

Re: how to remove values in a row

PaigeMiller — Thu, 24 Sep 2020 19:33:32 GMT

You would have to have a missing value which is a dot, as these variables are numeric.

In a SAS data step, use

call missing(c0,c1,c2,c3,c4);

Re: how to remove values in a row

CurtisMackWSIPP — Thu, 24 Sep 2020 20:41:33 GMT

@PaigeMiller wrote:

You would have to have a missing value which is a dot, as these variables are numeric.

In a SAS data step, use
call missing(c0,c1,c2,c3,c4);

Or for a little added flair

call missing(of c0-c4);