About OJohn_StaT

OJohn_StaT · ‎04-20-2023

Your code worked and I wrote the following codes and I got what I wanted so for. I have a questions. How can I adjust your code for using a sas dataset instead of datalines statement for creating patient_icd dataset. I tried but I could not do it. Can you help me? data patient_icd_2; set patient_icd; icd_codes = scan(icd_var, -2, '()'); run; proc transpose data=patient_icd_2 out=patient_icd_3; by patient_id; var icd_codes; run; /* Rename the variable and remove the prefix 'COL' */ data patient_icd_4; set patient_icd_3; rename col1=icd_var1 col2=icd_var2 col3=icd_var3 col4=icd_var4 col5=icd_var5 col6=icd_var6 col7=icd_var7 col8=icd_var8 col9=icd_var9 col10=icd_var10; drop _name_; run;

OJohn_StaT · ‎04-20-2023

Thank you for your help. I am trying to see each patients different diagnosis separately as a icd_var1, icd_var2,...

OJohn_StaT · ‎04-20-2023

I have a dataset that contains several ICD-10 codes along with their explanations. I would like to generate new variables based on the ICD-10 codes in the dataset. New variables will be like ICD_var1,ICD_var2,... on the table. I would like to improve my abilities for this kind of variables. I could not find similar examples. Could you please help me? Thank you in advance.(The screenshot is what I want to have) /***My data creating code***/ data patient_icd; input Patient_ID ICD_CODES $100.; ICD_VAR1 = scan(ICD_CODES, 1, '|'); ICD_VAR2 = scan(ICD_CODES, 2, '|'); ICD_VAR3 = scan(ICD_CODES, 3, '|'); ICD_VAR4 = scan(ICD_CODES, 4, '|'); ICD_VAR5 = scan(ICD_CODES, 5, '|'); ICD_VAR6 = scan(ICD_CODES, 6, '|'); ICD_VAR7 = scan(ICD_CODES, 7, '|'); ICD_VAR8 = scan(ICD_CODES, 8, '|'); ICD_VAR9 = scan(ICD_CODES, 9, '|'); ICD_VAR10 = scan(ICD_CODES, 10, '|'); ICD_VAR11 = scan(ICD_CODES, 11, '|'); ICD_VAR12 = scan(ICD_CODES, 12, '|'); ICD_VAR13 = scan(ICD_CODES, 13, '|'); datalines; 234423 (#1) Sickle-cell disease without crisis (D57.1) [POA=] | (#2) Idiopathic aseptic necrosis of unspecified bone (M87.00) [POA=] | (#3) Anxiety disorder, unspecified (F41.9) [POA=] | (#4) Osteonecrosis, unspecified (M87.9) [POA=] | (#5) Other symptoms and signs involving emotional state (R45.89) [POA=] | (#6) Other specified health status (Z78.9) [POA=] | (#7) Other specified counseling (Z71.89) [POA=] | (#8) Other long term (current) drug therapy (Z79.899) [POA=] | (#9) Encounter for therapeutic drug level monitoring (Z51.81) [POA=] | (#10) Counseling, unspecified (Z71.9) [POA=] 8723492 (#1) Sickle-cell disease without crisis (D57.1) [POA=] | (#2) Idiopathic aseptic necrosis of unspecified bone (M87.00) [POA=] | (#3) Osteonecrosis, unspecified (M87.9) [POA=] |

OJohn_StaT · ‎10-03-2022

Thank you!!

OJohn_StaT · ‎07-18-2022

Thank you Tarhell13, I think this is it. It work and I will try it with a bigger sample. I will let you now ASAP after I applied it.

OJohn_StaT · ‎07-15-2022

Hello PaigeMiller, I created second dataset by hand which means deleted some rows to show what I need to have as a final dataset. So Second dataset is what I want to create and I could not created the logic so that is why I asked for help. while showing symptoms=visit_status. This data for doctor visit. Each row is the for each visit. Sometimes patient has symptoms sometimes it does not have it. So if visit_status=1 then patient has symptoms during the dr visit. Thank you

OJohn_StaT · ‎07-14-2022

Hello PaigeMiller, Thank you for your time and help. Sorry there was a mistake and I fixed it. Here is my dataset. data Member_Data; input VISIT_DATE :date9. MEMBER_ID $ VISIT_YEAR VISIT_STATUS; format VISIT_DATE :date9.; datalines; 06NOV2013 AA10450Z 2013 0 05JUN2014 AA10450Z 2014 1 26JUN2014 AA10450Z 2014 1 21AUG2014 AA10450Z 2014 1 18SEP2014 AA10450Z 2014 1 03DEC2014 AA10450Z 2014 1 11MAR2015 AA10450Z 2015 1 15APR2015 AA10450Z 2015 1 07OCT2015 AA10450Z 2015 1 13OCT2015 AA10450Z 2015 1 26OCT2015 AA10450Z 2015 1 09NOV2015 AA10450Z 2015 1 07DEC2015 AA10450Z 2015 1 21DEC2015 AA10450Z 2015 1 19APR2017 AA10450Z 2017 1 10SEP2018 AA10450Z 2018 0 15APR2019 AA10450Z 2019 1 ; run; data want; set Member_Data; by member_id visit_year; delta_days=visit_date-lag(visit_date); if first.visit_year then do; delta_days=.; counter=0; end; counter+1; do; if VISIT_STATUS=0 then counter=0;else counter=counter; end; run; I created the following dataset using the above code; The data set below is the data set I want to create; What I would like to find are those who visit at least once a year while showing symptoms of the disease. If anyone has visited while showing symptoms more than once during the year, then how many times did they visit in total and the difference in days between their first visit and their second visit. delta_days=day difference between the current visit date and the previous visit date Visit_status =showing symptoms of illness when visiting counter=Calculation of the number of visits while showing symptoms of the disease in the same year Thank you so much

OJohn_StaT · ‎07-14-2022

Hello , This is my dataset; data Member_Data; input VISIT_DATE :date9. MEMBER_ID $ VISIT_YEAR VISIT_STATUS; format VISIT_DATE :date9.; datalines; 06NOV2013 AA10450Z 2013 0 05JUN2014 AA10450Z 2014 1 26JUN2014 AA10450Z 2014 1 21AUG2014 AA10450Z 2014 1 18SEP2014 AA10450Z 2014 1 03DEC2014 AA10450Z 2014 1 11MAR2015 AA10450Z 2015 1 15APR2015 AA10450Z 2015 1 07OCT2015 AA10450Z 2015 1 13OCT2015 AA10450Z 2015 1 26OCT2015 AA10450Z 2015 1 09NOV2015 AA10450Z 2015 1 07DEC2015 AA10450Z 2015 1 21DEC2015 AA10450Z 2015 1 19APR2017 AA10450Z 2017 1 10SEP2018 AA10450Z 2018 0 15APR2019 AA10450Z 2019 1 ; run; data Member_Data_New; set Member_Data; by member_id visit_year; delta_days=visit_date-lag(visit_date); if first.visit_year then do; delta_days=.; counter=0; end; counter+1; run; And I am trying to create a new variable for total number of visit for each calendar year. Could you please help me for this issue because I am struggling. Here is a sample of the wanted dataset(below). Thank you for your time and your help in advance.

OJohn_StaT · ‎07-11-2022

Hello , I am trying to create a new variable for days between just the first visit and the second visit in each year. Also I am trying to create another variable for number of visit for each year. Could you please help me for this issue because I am struggling. Here is a sample of the dataset. Thank you for your time and your help in advance. data Member_Data_Sample; input VISIT_DATE :date9. MEMBER_ID $ VISIT_YEAR VISIT_STATUS; format VISIT_DATE :date9.; datalines; 06NOV2013 AA10450Z 2013 0 05JUN2014 AA10450Z 2014 1 26JUN2014 AA10450Z 2014 1 21AUG2014 AA10450Z 2014 1 18SEP2014 AA10450Z 2014 1 03DEC2014 AA10450Z 2014 1 11MAR2015 AA10450Z 2015 1 15APR2015 AA10450Z 2015 1 07OCT2015 AA10450Z 2015 1 13OCT2015 AA10450Z 2015 1 26OCT2015 AA10450Z 2015 1 09NOV2015 AA10450Z 2015 1 07DEC2015 AA10450Z 2015 1 21DEC2015 AA10450Z 2015 1 19APR2017 AA10450Z 2017 1 10SEP2018 AA10450Z 2018 0 15APR2019 AA10450Z 2019 1 ; run; data Member_Data_Sample; input VISIT_DATE :date9. MEMBER_ID $ VISIT_YEAR VISIT_STATUS; format VISIT_DATE :date9.; datalines; 06NOV2013 AA10450Z 2013 0 05JUN2014 AA10450Z 2014 1 26JUN2014 AA10450Z 2014 1 21AUG2014 AA10450Z 2014 1 18SEP2014 AA10450Z 2014 1 03DEC2014 AA10450Z 2014 1 11MAR2015 AA10450Z 2015 1 15APR2015 AA10450Z 2015 1 07OCT2015 AA10450Z 2015 1 13OCT2015 AA10450Z 2015 1 26OCT2015 AA10450Z 2015 1 09NOV2015 AA10450Z 2015 1 07DEC2015 AA10450Z 2015 1 21DEC2015 AA10450Z 2015 1 19APR2017 AA10450Z 2017 1 10SEP2018 AA10450Z 2018 0 15APR2019 AA10450Z 2019 1 ; run;

OJohn_StaT · ‎05-19-2022

Thank you so much for your time and your contribution!

OJohn_StaT · ‎05-19-2022

This observation above is one of thousands of observations in my dataset. Member name JD25654 has a subscription between these dates. Using this data, I want to make a new dataset like the following dataset. Subscription dates of each member are changing. Some of them have been members for 10 years, some of them have been a member for 1 year. I tried ways like lagging etc, but I couldn't get this dataset I need. Could you help?

OJohn_StaT · ‎04-19-2022

I had progress. I remove the interaction between race and plan_1_enrolled and I also use TYPE=IND instead of TYPE=UN. Now I can get the estimates and Z values and Pr>|Z|. Thank you for the help!

OJohn_StaT · ‎04-18-2022

Thank you for your help again. Okay I will try your suggestions and I will share the results. Thank you!

OJohn_StaT · ‎04-18-2022

Hello @ StatDave_sas , Thank you for taking the time to help me to solve the issue. I change the distribution comment to dist=bin and link comment to link=logit. But I had the same issue on the results again. Also, I had the warning of "WARNING: Iteration limit exceeded." after using "dist=bin and link=logit". I also investigated these 2 problematic variables but there is no missing data issue or something like that. The variables seem fine. I do not know what is the problem here? Thank you in advance.

OJohn_StaT · ‎04-14-2022

Hello Everyone, I run the code below. GEE parameter estimate table have some coefficient estimates with Coefficient Value 0 and missing Z values. Data is a patient level data and collected each year for each patient from 2014 to 2018. Number of observation=2789036 Dependent Variables; hospital_visit=0-1 Independent Variables; plan_1_enrolled=0-1 patient_race=White Black Asian Hispanic urban_area=0-1 patient_age=16-64 patient_gender=0-1 care_type=1-2-3-4-5 calender_year=2014-2015-2016-2017-2018 plan_2_enrolled=0-1 plan_3_enrolled=0-1 Patient_ID=12 digit id number The Code proc genmod data = online ; format calender_year patient_gender care_type patient_age plan_1_enrolled patient_race care_type plan_2_enrolled plan_3_enrolled urban_area; class Patient_ID calender_year patient_gender (ref='1') care_type(ref='1') patient_race(ref='WHITE') plan_1_enrolled(ref='0') plan_2_enrolled(ref='0') plan_3_enrolled (ref='0') urban_area (ref='0') ; model hospital_visit (event='1') = plan_1_enrolled*patient_race plan_1_enrolled urban_area patient_race patient_age patient_gender care_type calender_year plan_2_enrolled plan_3_enrolled / dist=normal link=IDENTITY type3 ; repeated subject=Patient_ID/type=un; lsmeans plan_1_enrolled*patient_race urban_area plan_1_enrolled patient_race patient_gender care_type calender_year plan_2_enrolled plan_3_enrolled / cl diff ilink exp; run; title'MODEL results for question '; proc genmod data = online ; format calender_year patient_gender care_type patient_age plan_1_enrolled patient_race care_type plan_2_enrolled plan_3_enrolled urban_area; class Patient_ID calender_year patient_gender (ref='1') care_type(ref='1') patient_race(ref='WHITE') plan_1_enrolled(ref='0') plan_2_enrolled(ref='0') plan_3_enrolled (ref='0') urban_area (ref='0') ; model hospital_visit (event='1') = plan_1_enrolled*patient_race plan_1_enrolled urban_area patient_race patient_age patient_gender care_type calender_year plan_2_enrolled plan_3_enrolled / dist=normal link=IDENTITY type3 ; repeated subject=Patient_ID/type=un; lsmeans plan_1_enrolled*patient_race urban_area plan_1_enrolled patient_race patient_gender care_type calender_year plan_2_enrolled plan_3_enrolled / cl diff ilink exp; run;

Online Status	Offline
Date Last Visited	‎04-23-2023 07:04 PM

Re: Creating new variables from a complex text variable

Re: Creating new variables from a complex text variable

Creating new variables from a complex text variable

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: creating new variable and dataset

creating new variable and dataset

Creating new variables

Re: Creating new rows of observation from the new range of date

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: Creating new rows of observation from the new range of date

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: Creating new variables from a complex text variable

Re: Creating new variables from a complex text variable

Creating new variables from a complex text variable

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: creating new variable and dataset

Re: creating new variable and dataset

creating new variable and dataset

Creating new variables

Re: Creating new rows of observation from the new range of date

Creating new rows of observation from the new range of date

Re: Proc Genmod Coefficient Value 0 and missing Z value on GEE paramet...

Re: Proc Genmod Coefficient Value 0 and missing Z value on GEE paramet...

Re: Proc Genmod Coefficient Value 0 and missing Z value on GEE paramet...

Proc Genmod Coefficient Value 0 and missing Z value on GEE parameter e...