About kathryn_jackson1_northwestern_edu

kathryn_jackson1_northwestern_edu · ‎07-16-2013

Thanks, data_null, this is helpful. It will return the ordered number of the first variable it hits, correct? So if my data row were to look like T1 T2 T3 T4 8 9 10 7 has1 = whichN(9, of T1-T4) would return has1=2 This could work, because then I would just need to add a line of code if has1 > 0 then has1=1. Thanks! -Katie

kathryn_jackson1_northwestern_edu · ‎07-16-2013

Hi all, I am trying to create indicator variables, based on information in other variables in my table. I have a data set in wide format (which I created from long) that has subject data at many (up to 700) different timepoints. Basically, if ANY of those time points have a specific value, I'd like to create an indicator. For example, if any of T1-T100 = 1, then I want INDICATOR=1. Can I have SAS specify a range of variable to check in my IF statement? I know I can us multiple "or" statements, but this is not practical, given the large number of time points. Also, I considered writing it into my array when I converted from long to wide format, but this did not seem to work and I did not see documentation on this particular issue. This is what I tried.. data wide (keep=id T1-T&mm var1-var&mm); array T(&mm); array var(&mm); do j = 1 by 1 until (last.id); set data1; by id; T(j) = Time; var(j) = score; if var(j) = 20 then HIGH = 1; else HIGH=0; end; Thanks for your help! -Katie

kathryn_jackson1_northwestern_edu · ‎07-08-2013

Thank you all for your help. You are right, 140 should not be picked up by the format. Thanks for the information on the blanks, and that characters could be smaller than a blank. I think what I was missing here was that a blank value is actually less than a 0 (correct?), and therefore in the above code, 14 would not be in the range, but 15 would. Thanks again for all of your help! -Katie

kathryn_jackson1_northwestern_edu · ‎07-03-2013

Thanks, Tom. So, in this case, should '140' also be within the range? That would suggest that 140=1400, right? Thanks! -Katie

kathryn_jackson1_northwestern_edu · ‎07-02-2013

Hi all, I am using an already established format program to create a format for specific character codes. An example of the code is the following: "1400 "-"1729 " = "TUMOR" I have a couple of questions: 1) what is the purpose of the space (here, there is one after the 0 and after the 9). I thought it could be a wildcard, but did not see any documentation about this. Also, I has always used a ":" in the past if I needed a wildcard feature... 2) I am getting the code "140" to format as "TUMOR" I am wondering if this should be the case, and if it is related to the spaces in the range provided. Any thoughts would be helpful - thanks! -Katie

Online Status	Offline
Date Last Visited	‎08-03-2016 01:55 PM

Re: Using a range of variables in an "IF" statement

Using a range of variables in an "IF" statement

Re: Character Formatting - Use of space

Re: Character Formatting - Use of space

Character Formatting - Use of space

Re: Using a range of variables in an "IF" statement

Using a range of variables in an "IF" statement

Re: Character Formatting - Use of space

Re: Character Formatting - Use of space

Character Formatting - Use of space