cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ginak
‎12-23-2020
  • 81 Posts
  • 43 Likes Given
  • 0 Solutions
  • 1 Likes Received

Array with a Character Variable (Using a Do-Until Loop)

by Quartz | Level 8 in SAS Programming
‎07-07-2016 10:38 PM
‎07-07-2016 10:38 PM
Hello,   I have a question. I have 15 character variables, DX1 through DX15, which look at ICD9 medical codes. So different numbers can be possible entries. Possible answers could be, say, 3310, 29040, V313, E234, etc.    For each person, I want to know if they have hypertension. Hypertension is between 401.00 through 405.90, but this is coded as 40100 through 40490. They could have hypertension listed in any of the DX1 through DX15 codes. It doesn't matter if they have, say, 40100 in DX1 and then their DX7 variable is 40490. They'll still have HYPERTENSION = 1.   This is the type of array I would want to use. So suppose for Person #1 I want to determine if they have hypertension. Which could be any of the numbers found between 40100 through 40490.    ARRAY diagn {15} dx1-dx15; DO i = 1 TO 15 UNTIL (diagn{i} IN ('40100' THROUGH '40490')); HYPER= diagn{i}; IF HYPER NOT IN ('40100' THROUGH '40490') THEN HYPER= '0'; END;   IF HYPER= '0' THEN HYPERA= 0; IF HYPERNE '0' THEN HYPERA= 1;   Here's the problem... this is a character variable, so how do I indicate the 40100 through 40490? Do I have to find every single diagnosis code and list it out? This is too difficult.. like 40200, 40201, 40211, 40290, .., 40519 etc. I was thinking to just convert this to a numeric variable but the problem is that the DX variables could also equal say, E5001 or something that starts with an E or a V. Any suggestions?   Thank you :') I have attached the .rtf output file of the proc freq which looks at one of the 15 diagnosis variables, DX1. You can see how it's coded weird. Basically I think the last two digits on the right signify what comes after the decimal point. So the hypertension variable that I'm looking for has 5 digits as well, signifying somethign like "401.00"   I hope this isn't confusing, but please let me know if it is and I can clarify! Thanks 🙂   ... View more

Simple Macro Discussion

by Quartz | Level 8 in SAS Programming
‎05-19-2015 04:03 PM
‎05-19-2015 04:03 PM
Hello! I have a simple macro question; if anyone has better sources to read up on macros, I would also appreciate it (I've been reading up a bit on google, but can't seem to find my error here) I have two datasets called: data.neds09merge1 and data.neds10merge1 I want to add a variable for each year (2009, 2010) for the corresponding data sets above. So Data.neds09merge1 will have 2009 for everyone in the variable "year," and data.neds10merge1 will have 2010 for everyone in the variable "year." Then, I want "yearz" to be 09 or 10, corresponding to the 2009 and 2010. So basically I'm trying to do this but make a macro for it data one;      set data.neds09merge1;      year = 2009; run; data two;      set data.neds10merge1;      year = 2010; run; but for some reason my macro is giving me trouble. %Macro stack(set,yearz);   data &set;   set data.neds&&year&merge1;   year = 20&yearz;   run; %mend stack; %stack(set = one, year = 09); %stack(set = two, year = 10); The error I get: WARNING: Apparent symbolic reference MERGE not resolved. I think it has something to do with the & after "year" and preceding "merge1." I'm not 100% sure though. Thoughts?Thanks! -Gina ... View more

Re: Question about a simple array

by Quartz | Level 8 in SAS Programming
‎06-03-2014 07:46 PM
‎06-03-2014 07:46 PM
thank yoU ... View more

Re: Question about a simple array

by Quartz | Level 8 in SAS Programming
‎05-20-2014 01:58 PM
‎05-20-2014 01:58 PM
Good idea, just added some more information for two sample cases. ... View more

Re: Question about a simple array

by Quartz | Level 8 in SAS Programming
‎05-20-2014 01:57 PM
‎05-20-2014 01:57 PM
Just added some more info ... View more

Question about a simple array

by Quartz | Level 8 in SAS Programming
‎05-20-2014 01:26 PM
‎05-20-2014 01:26 PM
Hello! I have an array I would like to compute. So there are 20 traumas, and 19 possible ages you can endorse each trauma (ages 0 - 18). I would like to  know whether someone endorsed a trauma at each age, regardless of which kind of trauma and then sum up the # of years they endorsed a trauma)  When I do this for 3 traumas (traumas gt1, gt3, gt5) it looks like this: data new;      set old; array gt1a[19] gt1a0-gt1a18;     array gt3a[19] gt3a0- gt3a18;     array gt5a[19] gt5a0 - gt5a18;     array gtnew[19] gta0 - gta18;     do i = 1 to 19;         if (gt1a= 1 | gt3a = 1 | gt5a= 1) then gtnew=1;     end;     if age ne . then duration = sum(of gta0 - gta18); run; Here, the "a0" through "a18" indicates that it's age 0 ,..., age18. How can I do this for all 20 traumas? gt1 through gt20? Without having to type 20 array statements? Thanks! Edit: sorry! Here is what the data would look like for ID #5, who enrolled in the study at age 1.5. We see that he experienced trauma1 at age 1 and 2, and experienced trauma2 at age 0 and 1. the rest of the entries are missing, i.e., he did not experience trauma then. ID age gt1a0  gt1a1 gt1a2 gt1a3 .... gt1a18 gt2a0 gt2a1 gt2a2 gt2a3 gt2a4 , ... , gt2a18 gt3a0,...,gt3a18 gt4a0 ,.........., gt20a0 gt20a1 gt20a2 gt20a3 gt20a4 , ..., gt20a18 5  6         .       1       1      .             .          1      1        .        .       .                 .           .           .          .                       .          .        .        .           .                  . 17  2       1          1      1     .             .           .        .      .        .       1                 .           .          .           .                       .          .       .          .          .                    . This data is in wide format so I am creating a new array of variables called gta0 - gta18; each variable will be '1' if child experienced ANY trauma at that age so for ID # 5: ID age gta0 gta1 gta2 gta3 gta4 , ....., gta18 duration 5   6       1    1       1       .      .                .      3 17   2     1    1       1      .       1                .      4 Since ID#5 experienced trauma 2 at age 0, he has a '1' for gta0. since he experienced traumas 1 and 2 at age 1, he gets a 1 for gta1. since he experienced trauma1 at age 2, he gets a 1 for gta2. since he didn't experience trauma at any other age, he has missing for those. Since ID #17 experienced trauma 1 at age 0,1 and 2,i .e, has a 1 for gt1a0 through gt1a2, he has a '1' for gta0 through gta2. Since he endorsed trauma2 at age 4, he now has gta4=1. Since this is wide format data, I'm still going to keep all the other gt1a0 through gt20a18 variables in the data set. I've just typed what I want the new array to give us. Does this help? I am trying to figure out who is a data error (So ID #6 is ok, because he enrolled at age 6 and endorsed trauma up til age 2. However, ID #17 enrolled at age 2 but endorsed a trauma at age 4. this is problematic and this is what I am exploring). Hope this is helpful, please let me know if it is not or needs more clarification ... View more

Re: Best way to create certain variables

by Quartz | Level 8 in SAS Programming
‎05-02-2014 03:04 PM
‎05-02-2014 03:04 PM
Hello! I haven't used the 'select' statement before; I guess it might be worth looking up So I've narrowed my sample down to only those in groups 1-6. Regarding the subtype variables, they are dichotomous (you either have "1" for "yes," or missing "." for "no"). Does this help? Thanks! Best, Gina ... View more

Best way to create certain variables

by Quartz | Level 8 in SAS Programming
‎05-01-2014 02:53 PM
‎05-01-2014 02:53 PM
Hello! i have two questions.. I think they are related though. I'll present both issues just in case. So I have 6 mutually exclusive groups. Group 1 is people who only have trauma#1, group 2 is only people who have trauma#3, group 3= people who only have Trauma#5, group 4= people who have only Trauma#1 and Trauma#3, group 5 = people who only have trauma#1 and trauma#5, and group 6 = people who only have trauma#3 and trauma#5. Each trauma has the same variables, but they are modified to reflect which trauma they apply to. So I want to see, for example, who had trauma inflicted on them by a parent. the variable is t"x"perp, where x = the trauma#. So I have this the code, but I feel that it is pretty messy. I do this for sibling, other adult, and other youth. /*Parent*/ if group = 1 and t1perp=1 then parent = 1; else if group = 2 and t3perp=1 then parent = 1; else if group = 3 and t5perp=1 then parent = 1; else if group = 4 and (t1perp =1 or t3perp =1) then parent =1; else if group = 5 and (t1perp =1 or t5perp =1) then parent =1; else if group = 6 and (t3perp =1 or t5perp =1) then parent =1; /*Other adult relative*/ if group = 1 and t1perar=1 then otheradult = 1; else if group = 2 and t3perar=1 then otheradult = 1; else if group = 3 and t5perar=1 then otheradult = 1; else if group = 4 and (t1perar =1 or t3perar =1) then otheradult =1; else if group = 5 and (t1perar =1 or t5perar =1) then otheradult =1; else if group = 6 and (t3perar =1 or t5perar =1) then otheradult =1; /*Sibling*/ if group = 1 and t1persb=1 then sibling = 1; else if group = 2 and t3persb=1 then sibling = 1; else if group = 3 and t5persb=1 then sibling = 1; else if group = 4 and (t1persb =1 or t3persb =1) then sibling =1; else if group = 5 and (t1persb =1 or t5persb =1) then sibling =1; else if group = 6 and (t3persb =1 or t5persb =1) then sibling =1; What would be the best way to condense this? Macro?Array? I think hard-coding the way I have is very elementary/amateurish and susceptible to error . Second issue: I want to know for those who are in groups 3, 5, or 6 (i.e., they're the groups with subjects who have endorsed trauma#5), I want to see the type of subtypes they have if they have 3 subtypes. There are multiple combinations though, Any ideas on how to condense this code? You can endorse any 3 of the 5.       array subtype {5} t5typt5 t5typen t5typva t5typed t5typoth; if group in (3,5,6) and subtype{1}=. & subtype{2}=. & subtype{3} = . & subtype{4}=. and subtype{5}=.             then combotype3=0;       if group in (3,5,6) and subtype{1}=1 & subtype{2}=1 & subtype{3} = 1 & subtype{4} ne 1 & subtype{5} ne 1 then combotype3=1; else       if group in (3,5,6) and subtype{1}=1 & subtype{2}=1 & subtype{4} = 1 & subtype{3} ne 1 & subtype{5} ne 1 then combotype3=2; else       if group in (3,5,6) and subtype{1}=1 & subtype{2}=1 & subtype{5} = 1 & subtype{3} ne 1 & subtype{4} ne 1 then combotype3=3; else       if group in (3,5,6) and subtype{1}=1 & subtype{3}=1 & subtype{4} = 1 & subtype{2} ne 1 & subtype{5} ne 1 then combotype3=4; else       if group in (3,5,6) and subtype{1}=1 & subtype{3}=1 & subtype{5} = 1 & subtype{2} ne 1 & subtype{4} ne 1 then combotype3=5; else       if group in (3,5,6) and subtype{1}=1 & subtype{4}=1 & subtype{5} = 1 & subtype{2} ne 1 & subtype{3} ne 1 then combotype3=6; else       if group in (3,5,6) and subtype{2}=1 & subtype{3}=1 & subtype{4} = 1 & subtype{1} ne 1 & subtype{5} ne 1 then combotype3=7; else       if group in (3,5,6) and subtype{2}=1 & subtype{3}=1 & subtype{5} = 1 & subtype{1} ne 1 & subtype{4} ne 1 then combotype3=8; else       if group in (3,5,6) and subtype{2}=1 & subtype{4}=1 & subtype{5} = 1 & subtype{1} ne 1 & subtype{3} ne 1 then combotype3=9; else       if group in (3,5,6) and subtype{3}=1 & subtype{4}=1 & subtype{5} = 1 & subtype{1} ne 1 & subtype{2} ne 1 then combotype3=10; Also if you know of any resources I can consult to learn more about arrays I'd appreciate it.. suggestions are welcome Thanks! ... View more

Re: How to indicate duplicates in long format data set

by Quartz | Level 8 in SAS Procedures
‎03-11-2014 10:51 PM
‎03-11-2014 10:51 PM
Hi Reeza! Thank you so much. The code worked I just had to change input to put. You always are so fast to respond and help me, which I really appreciate. I am, unfortunately, not the best programmer, but try to google things before I come here and ask you guys. If you have any advice on how I can learn little tricks like the one you showed me, I'd really appreciate it! Just simple things like using the retain, first.variable types of statements. Thanks again!!!! ... View more

How to indicate duplicates in long format data set

by Quartz | Level 8 in SAS Procedures
‎03-11-2014 07:32 PM
‎03-11-2014 07:32 PM
Hi! I have a question regarding how to indicate a value is repeated in a data that's long format. Example: ID name_of_former_variable ageofonset numberoftraumas 1   ageonsettrauma14               12             1 1   ageonsettrauma7                 13             2 2   ageonsettrauma6                 8               1 2   ageonsettrauma7                 8               2 2   ageonsettrauma16               8               3 2   ageonsettrauma18               8               4 2   ageonsettrauma20               9               5 3   ageonsettrauma4                 5               1 3   ageonsettrauma18               5                2 So basically, numberoftraumas is a counter variable to see the number of traumas each ID endorsed. I am interested in earliest age of onset (so for ID # 1, it is 12, for ID #2 it is 8). I also want to know the number of traumas endorsed (So for ID #1 it is 2, for ID #2 it is 5). I can get these by splitting these into two data sets and merging the largest "numberoftraumas" variable with the smallest "ageofonset" THen I was able to use a substring function to indicate which trauma # is associated with the earliest age of onset. But I'd like to indicate if there is a tie. So for example, for ID #2, the earliest age of onset is 8. However, there are multiple traumas endorsed at age 8. I want to create a variable which indicates if there are ties, specifically, the first two traumas (because I want to indicate that they had multiple traumas at that earliest age of onset, if that makes sense). I can't just use the largest "numberoftraumas' to indicate this because, as you can see with ID #1, even though they had two traumas, they occurred at two different ages. So if subject has multiple traumas occurring at the earliest age of trauma, then their 'firsttrauma'=99 Otherwise, it is the number of the trauma. So for ID1, their earliest age of trauma was trauma#14 and occured at age 12. No other trauma was endorsed at age 12, so their firsttrauma variable is 14. But for ID2,  they had 4 traumas at age 8, and one trauma at age 9, so I don't care which traumas they experienced at age 8, I just want to indicate that there was more than one experienced at age 8, so their firsttrauma=99. ID3 had 2 traumas at age 5, so their firsttrauma=99. So this is what I will see: ID name_of_former_variable ageofonset numberoftraumas  firsttrauma 1   ageonsettrauma14               12             1                          14 2   ageonsettrauma20               8               5                          99 3   ageonsettrauma18                 5               2                          99 But ultimately, I don't care about the name_of_former_variable so I'd delete that and want to see this: ID ageofonset numberoftraumas  firsttrauma 1        12             1                          14 2          8               5                         99 3          5               2                         99 Thank you so much!! Sorry for the long explanation. I wasn't sure how to find this online , I couldn't find anything in my searches Last time I asked a question someone requested for more details so I thought I'd provide more. ... View more

Re: Question about summing something in long format

by Quartz | Level 8 in SAS Programming
‎02-19-2014 06:13 PM
‎02-19-2014 06:13 PM
Hi Reeza, Thank you so much! This is soooo close to what I'm looking for. How could you modify it such that the ties aren't double counted? FOr example, So here, for display purposes, you see that ID #000511 has had trauma at 4 years of their life (year 3,4,5, and 8). But the code you gave me will give me 6 instead of 4.. i.e., it double counts the year. How could we modify it such that it doesn't double count years 5 and 8 (in this case)? The years of trauma endorsed for each are separated in the way that I told you above (tr1age, tr2age, tr3age), but I also created a variable that puts them all into one varaible by id number (it ended up not being necessary for your code) Thanks again ... View more

Re: Question about summing something in long format

by Quartz | Level 8 in SAS Programming
‎02-19-2014 05:28 PM
‎02-19-2014 05:28 PM
Yes, you're right. It's definitely a combo because of that reason! I guess what I'd like to have is a variable called numyearstrauma or something, where it gives the same answer for both lines, if that makes sense? The other variables repeat per row (I guess it's kind of dumb but oh well.. my boss wants me to keep the data set in this format). Basically I'm trying to calculate this score per person, because eventually I want to calculate the mean numyearstrauma/age score per group (There are 6 groups). ... View more

Question about summing something in long format

by Quartz | Level 8 in SAS Programming
‎02-19-2014 05:16 PM
‎02-19-2014 05:16 PM
Hello! So my data set is in long format (I can't transform it to wide format.. too many variables). I have 3 traumas, trauma #1, #3 and #5. People either have one or two of the traumas. Each record/line indicates a trauma. So the data set might look like this: ID group traumatype tr1age0 tr1age1 tr1age2 [...] tr1age18 tr3age0 tr3age1 tr3age2 [.. until] tr3age18 tr5age1 tr5age2 [...] trage0 trage1 trage2 trage3 [...] trage18 duration 1   6        trauma1         1        1            .                 .          .            .            .                      .            .         .                1          1       .         .               .            2 1   6        trauma3          .         .           .                   .        .            1           1                      .            .         .                 .          1       1        .                            2 2    1       trauma1                    1                                                                                                                                                                                            1 So   here ID #1 is in group 6, which means they have endorsed trauma1 and trauma3. ID # 2 is in group 1, so they've only endorsed trauma1 (so depending on whether they've endorsed only one of the three traumas or two, that will determine if they're in group 1,2,3,4,5 or 6.). So suppose now we have these two people. I want to calculate the # years endorsed trauma. So for ID#1, they have endorsed a trauma at ages 0,1 and 2. Notice that they endorsed both traumas at age 1. That's ok, it still counts as 1 year. So their years endorsed = 3. Now, How can I get SAS to do this? I made the new variable, trage0 through trage18 to indicate whether they endorsed their trauma at that age (because I thought it might be easier to have the same variable name). I was thinking of taking the maximum at each age. so for ID#6, their max at age 0=1, max at age1=1, max at age 2=1, max at age 3=., ..., max at age 18=. (missing). So then I'd sum the max's and get 3 as the number of years having endorsed a trauma. Any help as to how I can do this? I feel like I could use an array but I'm not sure. Also the fact that the index starts at 0 and not 1 is trouble some.. I think i need to go from -1 to 18 so sas doesn't freak out. Thanks!!! Gina PS- in general, where can one find information on using long format data to calculate things like this on the web? I'm not sure ... View more

Re: How Index on a number in a macro when it's in the middle of the va...

by Quartz | Level 8 in SAS Programming
‎02-11-2014 03:06 PM
‎02-11-2014 03:06 PM
Ahh thank you!! Totally forgot about the dot. Also, I'm not sure how a transposed data set would work here? Each person (one record) has a value for all of those variables (maybe I'm misunderstanding your suggestion). But thanks everyone for your help! ... View more

How Index on a number in a macro when it's in the middle of the variab...

by Quartz | Level 8 in SAS Programming
‎02-10-2014 06:06 AM
‎02-10-2014 06:06 AM
Hello, I'm trying to write a macro which does a data step on several variables. I have a set of 4 variables for 20 different trauma types (lot of variables!) I'd like to sum over each of the 15 variables. The problem is, the number which indicates which trauma group its from is in the middle of the variable so I have say, for each of the 20 groups: gt1roy gt1margie gt1time gt1tempo gt2roy gt2margie gt2time gt2tempo . . . gt20roy gt20margie gt20time gt20tempo I'd like to take a sum of gt1roy through gt1tempo (which has gt1=1 or 2 or 99). i'd like to sum over gt2roy through gt2tempo  (which has gt2=1 or 2 or 99), ...., and finally gt20roy through gt20tempo  (which has gt20=1 or 2 or 99). I'm interested in those cases with their gt variables = 2. And I want to do it when each group, So I want somethign like %macro sumz(n);      %do i = 1 %to &n.;      data new&i;      set olddataset;      where gt&i=2;      traumasum&i = sum (of  gt&iroy gt&imargie gt&itime gt&itempo); run; %end; %mend; proc print data = new&i;      var idnumber gt&iroy gt&imargie gt&itime gt&itempo; run; %sumz(20);    But the problem is, sas doesn't recognize the index when it's in the middle of a variable. if all my variables ended with a number I could refer to variables like gtmargie&i gtroy&i etc and it would be fine. Help?Thanks!! x ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-23-2020 07:22 AM
Likes given to
View All
Likes from
View All
Quick links