topic Re: Switching the variable information based on the certain conditions? in SAS Procedures

Switching the variable information based on the certain conditions?

ybz12003 — Wed, 04 Sep 2019 14:23:32 GMT

Hello experts:

I would like to do the following steps.

The dataset has the variables list below:

Error
Dose1_Group1
Date1_Group1
Productor1_Group1
Manufacture1_Group1
Dose2_Group2
Date2_Group2
Productor2_Group2
Manufacture2_Group2

When variable 'Error' =1, I would like to switch the group 1 variables which are 'Dose1,' 'Date1,' 'Productor1,' 'Manufacture1.' with the group 2 variable 'Dose2,' 'Date2,' 'Productor2,' 'Manufacture2.'
When variable 'Error' =0, I DO NOT want to switch the group 1 variables which are 'Dose1,' 'Date1,' 'Productor1,' 'Manufacture1.' with the group 2 variable 'Dose2,' 'Date2,' 'Productor2,' 'Manufacture2.'

I am wondering if the SAS could perform this procedure. Thanks ahead.

Re: Switching the variable information based on the certain conditions?

PaigeMiller — Wed, 04 Sep 2019 14:35:55 GMT

data want;
    set have;
    if error=1 then do;
        temp=dose1_group1;
        dose1_group1=dose2_group2;
        dose2_group2=temp;
        /* Repeat the above for all other variables */
        /* which could be done using ARRAYs if desired */
    end;
    drop temp;
run;

By the way, why make your variable names so complicated? Wouldn't dose1 and dose2 be sufficient, instead of dose1_group1 and dose2_group2?

Re: Switching the variable information based on the certain conditions?

Jagadishkatam — Wed, 04 Sep 2019 14:40:05 GMT

If you consider that except error variable, all the other variables are character then you can use arrays as below

data want;
set have;
array grp1(*) $ Dose1_Group1 Date1_Group1 Productor1_Group1 Manufacture1_Group1;
array grp2(*) $ Dose2_Group2 Date2_Group2 Productor2_Group2 Manufacture2_Group2;
array grp3(*) $ temp1 temp2 temp3 temp4;
do i = 1 to dim(grp1);
grp3(i)=grp1(i);
if error=1 then do;
grp1(i)=grp2(i);
grp2(i)=grp3(i);
end;
end;
run;

Re: Switching the variable information based on the certain conditions?

ybz12003 — Wed, 04 Sep 2019 14:56:18 GMT

I apologize I didn't specify the variables. Some variables like dose, date, and product are numeric, some variable like manufacture is character.

Re: Switching the variable information based on the certain conditions?

Jagadishkatam — Wed, 04 Sep 2019 14:59:34 GMT

Then you can try the below code so as to reduce the number of the lines

data want;
set have;
array grp1(*) Dose1_Group1 Date1_Group1 Productor1_Group1 ;
array grp2(*) Dose2_Group2 Date2_Group2 Productor2_Group2 ;
array grp3(*) temp1 temp2 temp3 ;
do i = 1 to dim(grp1);
grp3(i)=grp1(i);
if error=1 then do;
grp1(i)=grp2(i);
grp2(i)=grp3(i);
end;
end;
if error=1 then do;
temp4=Manufacture1_Group1;
Manufacture1_Group1=Manufacture2_Group2;
Manufacture2_Group2=temp4;
end;
run;

Re: Switching the variable information based on the certain conditions?

ybz12003 — Mon, 16 Sep 2019 20:25:00 GMT

Hello, Jagadishkatam

Most of your codes are correct, except adding one "$" to the character switch. It's because I have multiple character variables.