How to get an output for inconsistenc in a sequence number in a variable and other variable mismatch

Ravindra_ — Wed, 21 Apr 2021 09:33:51 GMT

I have got a requirement where i the variable is having multiple timepoints and they need to be in a sequence that were specified as per the specification and there are other two timepoint variables. here first i need to add a condition, if the sequence of first timepoint variable is not as per the order then the whole record must come in the output and also if the timepoint in either of the other two variables(TP2, TP3) if it is not matching with the first one(TP1) then it should come in the output. I was able to achieve the second requirement but i am not able to find a solution for the first requirement. In the first requirement the sequence of TP1 variable should be (1,2,3,5,7,8,9,10,11) in this sequence 4 and 6 were missing as that will be present in other dataset. if this is not in sequence then it must be in output. Can someone please help.

example dataset

data ndsn;
infile datalines;
input subject visit $4. TP1 TP2 TP3;
datalines;
101 Day1 1  1  1
101 Day1 2  4  2
101 Day1 3  2  3
101 Day1 5  4  5
101 Day1 7  7  7
101 Day1 8  8  8
101 Day1 9  8  9
101 Day1 10 10 10
101 Day1 11 10 11
101 Day2 1  1  1
101 Day2 2  4  2
101 Day2 5  2  3
101 Day2 3  4  5
101 Day2 5  7  7
101 Day2 8  8  8
101 Day2 7  8  9
101 Day2 10 10 10
101 Day2 8 10 11
;
run;

desired output

data ndsn;
infile datalines;
input subject visit $4. TP1 TP2 TP3;
datalines;
101 Day1 2  4  2
101 Day1 3  2  3
101 Day1 5  4  5
101 Day1 9  8  9
101 Day1 11 10 11
101 Day2 2  4  2
101 Day2 5  2  3
101 Day2 3  4  5
101 Day2 5  7  7
101 Day2 7  8  9
101 Day2 8 10 11
;
run;

Re: How to get an output for inconsistenc in a sequence number in a variable and other variable mism

maguiremq — Wed, 21 Apr 2021 12:41:46 GMT

Use the RANGE function to detect if the results vary. If they don't, then remove them from the data set.

data want_mm (drop = flag);
	set have;
	if range(of tp1-tp3) = 0 then flag = "1";
		else flag = "0";
	if flag = "0" then output;
run;

Obs subject visit TP1 TP2 TP3 
1 101 Day1 2 4 2 
2 101 Day1 3 2 3 
3 101 Day1 5 4 5 
4 101 Day1 9 8 9 
5 101 Day1 11 10 11 
6 101 Day2 2 4 2 
7 101 Day2 5 2 3 
8 101 Day2 3 4 5 
9 101 Day2 5 7 7 
10 101 Day2 7 8 9 
11 101 Day2 8 10 11

Re: How to get an output for inconsistenc in a sequence number in a variable and other variable mism

Ravindra_ — Thu, 22 Apr 2021 10:14:06 GMT

thanks for the help maguiremq

topic How to get an output for inconsistenc in a sequence number in a variable and other variable mismatch in SAS Programming

How to get an output for inconsistenc in a sequence number in a variable and other variable mismatch

Re: How to get an output for inconsistenc in a sequence number in a variable and other variable mism

Re: How to get an output for inconsistenc in a sequence number in a variable and other variable mism