09-29-2017 05:29 AM
I have the below code with conditions and when i run it it creates double observations.
I am creating a dataset which gives 1 if it satisfies a condition for each treatment group. But it resolves seperately and creates duplictes.
i use the below condition to have treatment wise but it duplicates like below in my datastep
%** Loop for each arm (to avoid transposing the data later) **;
%do k = 1 %to %sysfunc(countw(&ArmList., #)); %** Start for each ArmVar **;
if compress(&ArmVar.) = "%scan(&ArmList.,&k., #)" then do; %** if ArmVar condition **;
and it is resolved to code attached.
Can any one help me what i am doing wrong
09-29-2017 06:32 AM
Check subjid S1287, it will be outputted 3 times, the reason is that it fulfills these conditions:
if compress(actarm) = "BLINDED"
All of these has an output statement, you have to check your conditions again if this is not the desired result
09-29-2017 07:09 AM
If it fulfills all conditions then it should be multiple. But what i get is multiple obs of subjids for almost most of them
Then they all fulfill multiple conditions. Maxim 3: Know your data.