About karora1

karora1 · ‎01-17-2025

Thanks everyone for the feedback. My original thought was to create 1 variable with different values as opposed 7 different variables. In terms of min/max etc., for the most part it's the minimum (i.e. if it had options of 0 and 25, chosse 0 and assign it to "within 3 days"). However, there is an exception and that was for values below -14. For these i didn't want them to take precedence (e.g. if it was -100 and 2, I wanted it to take the 2). This was why i tried to assign the categories using the else/if statements, but it sounds like this is not possible do to the nature of how the array works. So i might be to do an array to create the extra variables and then do if/then statements based on those variables to create the 1 variable that i want.

karora1 · ‎01-17-2025

I may collapse the number of categories later but for right now I'm using them look up some of the far outliers (e.g. below category and above 365)

karora1 · ‎01-17-2025

Hello, I have an array that searches seven variables for numbers. The seven variables contain the number of days between two dates (this could range from -300 to +300). Based on the numbers that it finds it is classified into 1 of 8 categories. In this case I want certain categories to take precedence over others, so I have created IF/else statements so that if the best match is found. My code is the following: Treat_cat = "No treatment listed"; array diff{7} Days_bt_PHAC_Tx1-Days_bt_PHAC_Tx7; do i= 1 to 7; if diff(i) GE -14 and diff(i) LE 3 then Treat_cat = "1. Within 3 days"; else if diff(i) GE 4 and diff(i) LE 7 then Treat_cat = "2. Between 4 to 7 days"; else if diff(i) GE 8 and diff(i) LE 14 then Treat_cat = "3. Between 8 to 14 days"; else if diff(i) GE 15 and diff(i) LE 30 then Treat_cat = "4. Between 15 to 30 days"; else if diff(i) GE 31 and diff(i) LE 365 then Treat_cat = "5. Between 31 to 365 days"; else if diff(i) GT 365 then Treat_cat = "6. More than 365 days"; else if diff(i) NE '' and diff(i) LE -15 then Treat_cat = "7. Below categories"; end; drop i; However, i'm finding that the code is working in that it is assigning all cases to a category. However it will assign them to the last category in the set of else/if statements. For example, if the days between dates for a case are 0, 16, the case will be assigned to the "Between 15 and 30 days" instead of "within 3 days". If the same case had 0, 16, and 76 then they would be assigned to "Between 31 and 365". It seems to always take the last category in my else if statements instead of the first. Any help would be appreciated.

karora1 · ‎01-16-2022

nevermind I found a "By" option that I can put in the network name and remove the group=networkname option.

karora1 · ‎01-16-2022

Hello I'm trying to calculate Age-std rates for a variety of geographies at once. I've used proc stdrate in the past to do my calculations in SAS for direct agestd rates but just realized that up until now I have often calculated the rates for two groups only in SAS. However this time I would like to calculate a death rate using the direct method but for all of the networks in our region (in this case 6 areas). The rate ratios are not needed but the rates and confidence intervals for each of the geographies is required. My code is the following proc stdrate data=deathrategeo2 refdata=Can2011 method=direct stat=rate(mult=100000) cl = GAMMA; population group = network_name event=death total=Pop; reference total=Pop; strata age18up ; title "Age std death rates by Network"; ods output StdRate = netstdrate; run; However, i get the following error message " At most two study populations can be used for METHOD=DIRECT" and the procedure isn't run. I know many people have to calculate direct age-std rates for more then 2 groups at a time, so there must be away to calculate it, but i can't seem to find the right way to do it.

karora1 · ‎10-30-2020

I tried the timeseries option and it worked great. Thanks a lot for the suggestions, much appreciated.

karora1 · ‎10-28-2020

If i remove the "from = day" then the transformin = (setmiss 0) does not add the blank days and zero counts to those days. This is problematic for the moving average part of the transformout part of the code. When I leave that section in the program does add zero's for blank days; however in 3 cases it adds a 1 instead. Do I have to rearrange the code so that the transformin code still works?

karora1 · ‎10-27-2020

1320 PROC EXPAND DATA=COVIDmontests1 OUT = COVIDmontests2 1321 FROM=DAY TO =DAY METHOD=NONE; 1322 BY overallSAG_ID; 1323 ID COLLECTION_DATE; 1324 CONVERT poscount = MOVESUM7 / TRANSFORMIN =(SETMISS 0) TRANSFORMOUT = (MOVSUM 7); 1325 CONVERT poscount = MOVEAVE7 / TRANSFORMIN =(SETMISS 0) TRANSFORMOUT =(MOVAVE 7); 1326 RUN; WARNING: 1 observations have been omitted before observation number 6 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/13/2020, the previous is COLLECTION_DATE=10/11/2020. WARNING: 1 observations have been omitted before observation number 16 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/24/2020, the previous is COLLECTION_DATE=10/22/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1011 WARNING: 1 observations have been omitted before observation number 73 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/25/2020, the previous is COLLECTION_DATE=10/23/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1022 WARNING: 1 observations have been omitted before observation number 79 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/12/2020, the previous is COLLECTION_DATE=10/10/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1031 WARNING: 1 observations have been omitted before observation number 103 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/18/2020, the previous is COLLECTION_DATE=10/16/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1032 WARNING: 1 observations have been omitted before observation number 141 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/19/2020, the previous is COLLECTION_DATE=10/17/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1042 WARNING: 3 observations have been omitted before observation number 150 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/13/2020, the previous is COLLECTION_DATE=10/09/2020. WARNING: 1 observations have been omitted before observation number 155 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/19/2020, the previous is COLLECTION_DATE=10/17/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1043 WARNING: 1 observations have been omitted before observation number 183 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/13/2020, the previous is COLLECTION_DATE=10/11/2020. NOTE: The above message was for the following BY group: overallSAG_ID=1052 WARNING: 2 observations have been omitted before observation number 217 in data set WORK.COVIDMONTESTS1 according to the FROM=DAY specification and the ID variable values. The current ID is COLLECTION_DATE=10/12/2020, the previous is COLLECTION_DATE=10/09/2020. NOTE: Further warnings for gaps in data will not be printed. NOTE: The above message was for the following BY group: overallSAG_ID=1054 NOTE: The data set WORK.COVIDMONTESTS2 has 2062 observations and 6 variables. NOTE: PROCEDURE EXPAND used (Total process time): real time 0.06 seconds cpu time 0.01 seconds Sure here is the log. I'm still getting errors related to the blanks but wasn't sure if that was because the errors were occurring at the By and ID statements before the setmiss option is run.

karora1 · ‎10-27-2020

I've been working with proc expand do some simple backward 7 day moving averages and sums. However, I was doing some verifications on my data and i seem to be off in the sum of my original variable in output file and correspondingly the sum and averages. I have exported the file right before the proc expand and seem to be correct but after the expand procedure the count is off by a few. I am clearly missing something but can't figure it out. The additional counts all seem to be right when there should be a blank (no data) and right before a count of 1 in the next day of data. However there are other cases where this happens and the increase does not happen. If i run the same code by a different geographic By variable, the counts line up. I tried to address the missing days by using the transformin = (setmiss 0) so I thought I was okay. Any suggestions are greatly appreciated. proc summary data=Cmontest nway missing; class overallSAG_ID overall_SAG_name COLLECTION_DATE; var poscount tottestcount; output out=Cmontests3(drop=_type_ _freq_) sum=; run; proc sort data = Cmontests3; by overallSAG_ID COLLECTION_DATE; run; PROC EXPAND DATA=COVIDmontests3 OUT = COVIDmontests10 FROM=DAY METHOD=NONE; BY overallSAG_ID; ID COLLECTION_DATE; CONVERT poscount = MOVESUM7 / TRANSFORMIN=(SETMISS 0) TRANSFORMOUT = (MOVSUM 7); CONVERT poscount = MOVEAVE7 / TRANSFORMIN=(SETMISS 0) TRANSFORMOUT=(MOVAVE 7); RUN;

karora1 · ‎11-15-2018

I was going to run a two sample ttest for a project i am working on that has 111 in one group and 121 in the other. However after exploring the data one of the groups appears to have a non-normal distribution. I wanted to run a man whitney non parametric test and discovered this code for SAS. proc NPAR1WAY data=IVPO_final wilcoxon; title "Nonparametric test to compare Age"; class convert_total; var Age_on_Admission; exact wilcoxon; run; However, when i run it i get the warning that it will take a lot of time and memory. I have yet to see the results of the analysis. Is there a better way to run this type of analysis or a different code to use. etc.?

karora1 · ‎09-19-2018

That was the answer. i didn't realise there were fourth parameters in the intck, i though it was only for the intnx function that had the 4th options. Anyway if you adjust the code to be the following (C is for continuous) then I get what i want. /*AGE AT ADM*/ age_at_adm = intck('month',DATE_OF_BIRTH,DATE_ADMINISTERED,'C');

karora1 · ‎09-19-2018

I'm trying to calculate the number of months between two dates but am have some trouble getting it right using the intck function. Essentially I'm trying to calculate the age of the client when they have had an immunisation. In this case the actual month interval needs to have passed in order for the month to occur. For example a client born Feb 13, 2015 would only be 26 months old if they received the immunisation on May 1, 2017. In order for them to be 27 months they would have to have received the immunisation on May 13 or later. However using the intck formula listed below will calculate them to be 27 months. I believe this is because it has started the next interval (ie. May has started). I'm not sure how to adjust the formula so that it calculates it the way i would like (e.g. can i somehow add and if statement to -1 if the day in date of of admin is < day in the date of birth). Any thoughts welcome. /*AGE AT ADM*/ age_at_adm = intck('month',DATE_OF_BIRTH,DATE_ADMINISTERED);

karora1 · ‎03-05-2018

Thank you for the reply. I was able to correct the problem in the code i shared as well as go through the rest of the code in that file and correct similar errors. I have now run all of the code and it is error free.

karora1 · ‎03-02-2018

I am using SAS 9.4 and keep getting the following note in my SAS log at various locations NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 22:18 here is an example of code which causes the problem. DATA SET1; /*Format data, create new variables*/ SET DAD_RawFile; Length MRD_ICD9_3digit $3 SEX_1 $7; TITLE 'SET 1'; /*Create a CAUSE_ICD9_3digit variable to code for specific causes*/ IF code_indicator = 'ICD9' THEN MRD_ICD9_3digit = substr(MRD,1,3); /*Text variable containing 1st THREE characters of the ‘MRD’ variable*/ ELSE MRD_ICD9_3digit = ''; /*Recode missing rescode as '00000'*/ IF rescode = '' OR rescode = . THEN rescode = 00000; /*Standardize sex variable*/ IF sex =: 'M' THEN SEX_1 = 'Male'; ELSE IF sex =: 'F' THEN SEX_1 = 'Female'; ELSE IF sex= '' THEN SEX_1 = 'Unknown'; ELSE SEX_1 = 'Error'; RUN; and in the results viewer i get the following note 11 12 DATA SET1; /*Format data, create new variables*/ 13 SET DAD_RawFile; 14 Length MRD_ICD9_3digit $3 SEX_1 $7; 15 TITLE 'SET 1'; 16 17 /*Create a CAUSE_ICD9_3digit variable to code for specific causes*/ 18 IF code_indicator = 'ICD9' THEN MRD_ICD9_3digit = substr(MRD,1,3); /*Text variable 18 ! containing 1st THREE characters of the ‘MRD’ variable*/ 19 ELSE MRD_ICD9_3digit = ''; 20 21 /*Recode missing rescode as '00000'*/ 22 IF rescode = '' OR rescode = . THEN rescode = 00000; 23 24 /*Standardize sex variable*/ 25 IF sex =: 'M' THEN SEX_1 = 'Male'; 26 ELSE IF sex =: 'F' THEN SEX_1 = 'Female'; 27 ELSE IF sex= '' THEN SEX_1 = 'Unknown'; 28 ELSE SEX_1 = 'Error'; 29 RUN; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 22:18 I was thinking that when i created the new variable as character and defined its length (i.e. Length MRD_ICD9_3digit $3 SEX_1 $7; Then it would end up as character but it seems as though SAS is converting it to numeric and i'm not sure why or how much it is impacting my data set. I'm also not sure how to fix it.

Online Status	Offline
Date Last Visited	‎01-17-2025 05:26 PM

Re: else if statement not working

Re: else if statement not working

else if statement not working

Re: Need to calculate Age-std rates for more than 2 groups

Need to calculate Age-std rates for more than 2 groups

Re: proc expand altering original variable counts

Re: proc expand altering original variable counts

Re: proc expand altering original variable counts

proc expand altering original variable counts

mann whitney for two sample test

Re: Character values have been converted to numeric values

Re: calculating number of month intervals between 2 dates

Re: else if statement not working

Re: else if statement not working

else if statement not working

Re: Need to calculate Age-std rates for more than 2 groups

Need to calculate Age-std rates for more than 2 groups

Re: proc expand altering original variable counts

Re: proc expand altering original variable counts

Re: proc expand altering original variable counts

proc expand altering original variable counts

mann whitney for two sample test

Re: calculating number of month intervals between 2 dates

calculating number of month intervals between 2 dates

Re: Character values have been converted to numeric values

Character values have been converted to numeric values