topic Re: I want to create a new variable and see if the entire column has 0 or any value in SAS Programming

I want to create a new variable and see if the entire row has 0 or any value

venkatard — Fri, 12 Apr 2013 10:15:28 GMT

course class user score post forum quiz assign main group

In this example if we see the third and fourth column has all zeros. i want to know which row has all zeros and which has atleast one value.

Any help please

LinusH — Fri, 12 Apr 2013 10:23:10 GMT

sql: select max(score)...?

venkatard — Fri, 12 Apr 2013 10:31:36 GMT

Sorry for the confusion it is row and not column

LinusH — Fri, 12 Apr 2013 11:04:13 GMT

sum(score, post...)

esjackso — Fri, 12 Apr 2013 11:15:07 GMT

Here is a simple flagging in a dataset. If you just want a dataset of the ids you could just keep those variables.

data out;

set in;

flag = 1 + sum(score, post, forum, quiz, assign, main, group);

if flag = 1 then output;

run;

If you want to just produce a report you could use sql;

Proc sql;

select course, class, user

(1 + score + post + forum + quiz + assign + main + group ) as flag

from in

where calculated flag = 1

;

quit;

Just some thoughts, hope it helps!

ChrisNZ — Fri, 12 Apr 2013 11:30:30 GMT

FOUND_VALUE_FLAG=sum(of SCORE--GROUP) ne 0;

provided the values can only be positive.

Otherwise something like

FOUND_VALUE_FLAG=lengthn(compress(cats(of SCORE--GROUP),'0.')) ne 0;

will take care of any real number.