About Jackwangliang

Jackwangliang · ‎03-29-2018

Thanks for your response, the HCUP only has Elixhauser's comorbidity index.

Jackwangliang · ‎03-28-2018

Hi all, Which SAS macro program that I can use to generate Charlson Comorbidity Index for ICD-9 and ICD-10? Thanks, Jack Liang

Jackwangliang · ‎03-28-2018

Thank you

Jackwangliang · ‎03-28-2018

Thanks you.

Jackwangliang · ‎03-28-2018

Thank you.

Jackwangliang · ‎03-27-2018

Hi all, How can I drop lowercase variable? For example, original variable set: CHF VALVVE PULMCIRC OBESE oCHF oVALVVE oPULMCIRC oOBESE target variable set: CHF VALVVE PULMCIRC OBESE Best, JackLiang

Jackwangliang · ‎03-16-2018

Thank you. 🙂

Jackwangliang · ‎03-16-2018

Hi all, How can I create a new variable that is the count of other variables? For example, DATA TESTTEMP; INFILE DATALINES TRUNCOVER; INPUT ID DX1 DX2 DX3 DX4 DX5; CARDS; 1 8 32 21 24 45 2 8 23 3 , , 3 23 44 56 3 ; RUN; PROC PRINT DATA=TESTTEMP; RUN; What I am expecting is the output dataset like this ID DX1 DX2 DX3 DX4 DX5 NDX 1 8 32 21 24 45 5 2 8 23 3 3 3 23 44 56 3 4 Best, Liang

Jackwangliang · ‎03-16-2018

How can I post my data as text here? Thanks.

Jackwangliang · ‎03-16-2018

Hi, Reeza. Thanks for your comment. Here is a screenshot of part of my dataset. Variable Diagnosis_Code may contain observations with E, for example, E9505. For this E9505, if its Diagnosis_Sequence is the same as previous observations, then delete this E9505 observation. But if this Diagnosis_Sequence is not the same as the previous one, keep it. How can I code this? Best, Liang

Jackwangliang · ‎03-15-2018

Thank you all for your great replies! What if remove E that the Diag_Sequence is the same as previous observation, but do not remove E that has different Diag_Sequence number, for example, ID DX Diag_Sequence 1 96 1 1 E96 1 (remove) 1 87 2 1 E87 2 (remove) 1 V87 3 1 E23 4 (do not remove) 1 12 5 1 15 6 1 E15 6 (remove) I am a new SAS user, thank you very much for helping. Liang

Jackwangliang · ‎03-15-2018

Thank you all for your great replies! What if remove E that the Diag_Sequence is the same as previous observation, but do not remove E that has different Diag_Sequence number, for example, ID DX Diag_Sequence 1 96 1 1 E96 1 (remove) 1 87 2 1 E87 2 (remove) 1 V87 3 1 E23 4 (do not remove) 1 12 5 1 15 6 1 E15 6 (remove) I am a new SAS user, thank you very much for helping. Liang

Jackwangliang · ‎03-15-2018

Great! Thank you!

Jackwangliang · ‎03-15-2018

Dear all, How can I remove observations that contain a specific character? For example, remove observations contain E ID DX Diag_Sequence 1 96 1 1 E96 1 1 87 2 1 E87 2 1 V87 3 Best, Liang

Jackwangliang · ‎03-20-2017

Thank you! This is the point.

Online Status	Offline
Date Last Visited	‎03-29-2018 04:39 PM

Re: Charlson comorbidity index

Charlson comorbidity index

Re: Drop lowercase variable

Re: Drop lowercase variable

Re: Drop lowercase variable

Drop lowercase variable

Re: Create a variable based on the count of other variables

Create a variable based on the count of other variables

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: Charlson comorbidity index

Charlson comorbidity index

Re: Drop lowercase variable

Re: Drop lowercase variable

Re: Drop lowercase variable

Drop lowercase variable

Re: Create a variable based on the count of other variables

Create a variable based on the count of other variables

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Removing a variable conditionally

Re: Question about two sample ttest