topic Re: identifying a particular type of value in SAS Programming

identifying a particular type of value

sasq — Mon, 23 May 2016 15:58:44 GMT

I have various values for different variables in mutiple rows and columns showing 0/2 or 0/3 or 0/4 and so on ..

I have a total of 7 columns depicting treatmentand they have values like "0/some numeral"

I was to assign these values a "0" value. Can anyone please tell me how do i do this?

I can try to use index but for multiple row and multiple column it is not reading.

Re: identifying a particular type of value

LinusH — Mon, 23 May 2016 16:01:34 GMT

Test if the first position is a 0 then assign it to 0.
You can use an array to reuse that code.

Re: identifying a particular type of value

sasq — Mon, 23 May 2016 16:18:57 GMT

Thankx for the responce. It is not the first position. i have 200 rows and 7 columns and these values come randomly as 0/some numeral.. So i do not know how to assign them in such scenario.

Re: identifying a particular type of value

ballardw — Mon, 23 May 2016 17:38:19 GMT

Show some example data and the desired result.

Re: identifying a particular type of value

Astounding — Mon, 23 May 2016 18:12:08 GMT

Well, you don't tell us the names of the variables, so I will call them COL1 through COL7.

This is the way you would correct a single variable:

if col1 =: '0/' then co1='0';

This assumes that '0/' would appear at the beginning of the variable's value. If that's not the case, it can be done but becomes more complex.

To apply the same logic to all 7 variables, you would use an array:

array cols {7} col1-col7;

do _n_=1 to 7;

if cols{_n_} =: '0/' then cols{_n_} = '0';

end;

Good luck.

Re: identifying a particular type of value

sasq — Tue, 07 Jun 2016 14:58:29 GMT

Thankx for reaching out.

The data looks like

trta_1 trta_2 trta_3 ,trtb_1 trtb_2 trtb_3 wher trta and trtb are different drugs

trta_1 and trta _2 are two different time points of the same drug.

trta_3 will be the sum of same drug at the different time point.

trta_1 trta_2 trta_3 trtb_1 trtb_2 trtb_3

1/5 0/5 1/5 7/5 0/5 7/5