About jmontefalcon

jmontefalcon · ‎06-26-2024

Hello, The character variables values each represent tooth conditions (tc1_2 for tooth condition 1 for tooth #2 & tc2_2 for tooth condition 2 for tooth #2). There are 28 teeth total with tooth condition codes ranging from 0 to 9 and need to obtain sum variables based on different combinations of tooth conditions for each ID. Not sure if this answers your question, but this is what the code is supposed to be representing.

jmontefalcon · ‎06-25-2024

I would like to use the same if statement across different variables. I have 31 of these variables and would like to avoid typing multiple IF statements. Is there a more elegant way to achieve this? Here is my code: data want; set have; %let ab = ab1-ab31; if a1 = '0' and b1='0' then ab1='1'; else ab1='0'; if a2 = '0' and b2='0' then ab2='1'; else ab2='0'; if a3= '0' and b3='0' then ab3='1'; else ab3='0'; ... if a31 = '0' and b31='0' then ab31='1'; else ab31='0'; n_ab=sum((countc(cats(of &ab),'1'))); drop &ab; run;

jmontefalcon · ‎03-26-2024

Due to the nature of how the data was collected, the data looks like this and is in txt file: Bone 1 ID Bone 2 ID Bone 3 ID Bone 1 Type Bone 2 Type Bone 3 Type Bone 1 Condition Bone 2 Condition Bone 3 Condition 123 156 182 0 1 0 1 2 3 I want to read the txt file in and have it look like this: Bone ID Bone Type Bone Condition 123 0 1 156 1 2 182 0 3 Please let me know how I can achieve this. All variables are character variables. ID length should be $3. Bone type and bone condition should be a length of $1. Thank you!

Online Status	Offline
Date Last Visited	‎06-28-2024 05:56 PM

Re: Same IF statement across different variables

Same IF statement across different variables

Transpose in Data Step

Re: Same IF statement across different variables

Re: Same IF statement across different variables

Same IF statement across different variables

Transpose in Data Step