Dear Everyone, I would like to discuss with you three items. 1) 'count' vs. 'array'. I appreciate your comments on this topic - 'count' vs. 'array'. In this example of HIV cohort, I was looking how many comorbidity that subjects had developed with comorbidity after their initial treatment. I compared results between 'count' and 'array' in which I received the same results. A colleague of mind thought that 'count' may not be a proper method for analyses. In deeded, I admire array as this method is simple. Please kindly see my codes and SAS outputs below: **count** if dxyear ge arv_startyr then HTN_howmany=count(dxcode, "HTN"); if dxyear ge arv_startyr then DYSLIPID_howmany=count(dxcode, "DYSLIPID"); if dxyear ge arv_startyr then KIDNEY_UN_howmany=count(dxcode, "KIDNEY_UN"); if HTN_howmany=1 or DYSLIPID_howmany=1 or KIDNEY_UN_howmany=1 then comorbid_sta=1; else comorbid_sta=0; format comorbid_sta dx_staf.; **array** array array_comorbid[3] $20 ('HTN', 'DYSLIPID', 'KIDNEY_UN'); comorbid_number=0; do I=1 to dim(array_comorbid); if dxyear ge arv_startyr and dxcode=array_comorbid(I) then comorbid_number=comorbid_number+1; end; format comorbid_number dx_staf.; The FREQ Procedure Cumulative Cumulative comorbid_sta Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ dx_prior_art 6929 99.91 6929 99.91 dx_post_art 6 0.09 6935 100.00 comorbid_ Cumulative Cumulative number Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ dx_prior_art 6929 99.91 6929 99.91 dx_post_art 6 0.09 6935 100.00 2) In 'count' method, when I used 'and' instead of 'or', I do not get the results. I do this becuase I wonder a subject may have more than one comorbidity. if HTN_howmany=1 and DYSLIPID_howmany=1 and KIDNEY_UN_howmany=1 then comorbid_sta=1; else comorbid_sta=0; 3) Also, I wonder if someone can share with me a simple method replacing 'count' or 'array', and thus I can count over 20 AIDS-defining illness that wrote in a different names with 'string variables', such as 'CANDIDA', 'CMV', 'CRYPTOCO', 'CRYPTSP', ... Thanks everyone in advance for your time sharing your knowledge and skills in SAS. Phan S.
... View more