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: 
PhanS
‎03-04-2025
  • 121 Posts
  • 6 Likes Given
  • 1 Solutions
  • 0 Likes Received

proc format - format count not be loaded

by Obsidian | Level 7 in SAS Programming
‎02-10-2018 03:45 PM
‎02-10-2018 03:45 PM
Please see in the attachment - anyone can help, much appreciate.   ... View more

Re: Find/search ID/Douplicates

by Obsidian | Level 7 in SAS Programming
‎02-08-2018 11:33 AM
‎02-08-2018 11:33 AM
Thank you. I will try.   Phan S. ... View more

Re: Find/search ID/Douplicates

by Obsidian | Level 7 in SAS Programming
‎02-08-2018 08:03 AM
‎02-08-2018 08:03 AM
I want to identify if there are duplicates among subjects. Sub_IDs 005023 and 005003 are identical. I want to find these two subjects.   ... View more

Find/search ID/Douplicates

by Obsidian | Level 7 in SAS Programming
‎02-07-2018 06:18 PM
‎02-07-2018 06:18 PM
Hello,   Anyone can help much appreciated. How can I know whether if a duplicate of my sub_IDs that they are not the same. Example  DATA have; INPUT sub_id : $6. gender : $1. dob : DATE9. race : $1. education : $1.; FORMAT dob DATE9.; LABEL sub_id = "id of a subject" gender = "gender" dob = "dob" race = "race" education = "level od education" ; DATALINES; 002039 F 27mar1971 1 G 001204 M 12jan1972 1 H 005023 M 15jun1969 2 C 003025 M 17apr1968 2 G 001204 M 23feb1972 1 H 003029 F 30dec1970 1 G 001106 F 25oct1973 2 C 002034 M 31jan1962 3 H 005003 M 15jun1969 2 C 001204 M 01jan1972 1 H 006101 F 08jul1970 2 C ; proc print data = have; run;     ... View more

Re: Missing data on repeat measurements

by Obsidian | Level 7 in SAS Programming
‎02-06-2018 12:23 PM
‎02-06-2018 12:23 PM
Hello Satish,   Your code appears not work - I am not sure why. May you retest with a mock dataset.   Thank you.   Phan S.    ... View more

Re: Missing data on repeat measurements

by Obsidian | Level 7 in SAS Programming
‎02-06-2018 12:21 PM
‎02-06-2018 12:21 PM
Hello Reeza,   Thank you for your suggestions.  For methodologies, I will choose either use only available data, replacing mean/median or imputation (I know a bit).  The LOCF, Random, and calculate predict value -- I do not know.    Regarding programming, I would like to ask your help, assuming I have a data set that collected data for 3 cycles same subjects. I would like to know each cycle how many subjects participated in the study. In the other word, I would like to know many subjects were not returned in cycle 2 and cycle 3.   I thank you very much in advanced, Reeza.    PS: BP -- you are absolutely correct, systolic and diastolic BP. It was a fake number.    Phan S.     ... View more

Missing data on repeat measurements

by Obsidian | Level 7 in SAS Programming
‎02-03-2018 07:01 PM
‎02-03-2018 07:01 PM
I want to follow-up: missing data on repeat measurement. Anyone helps much appreciated and thanks in advanced.     Assuming I measured blood pressure for 6 subjects at 3 times, week 1, week 2 week3. How can I deal with the missing value? data bp; input id age bp1 bp2 bp3; datalines; 1 45 110 165 90 2 56 124 . . 3 60 142 . 137 4 61 . 94 120 5 39 130 130 . 6 55 157 130 124 ; run; Phan S.   ... View more

Re: Missing value

by Obsidian | Level 7 in SAS Programming
‎02-03-2018 03:59 PM
‎02-03-2018 03:59 PM
Hello,   I am sorry, I mean I give the solution (credit) to you, bu accidentally check to Reeza.    Thank you for you code.   Phan S.    ... View more

Missing value

by Obsidian | Level 7 in SAS Programming
‎02-03-2018 02:38 PM
‎02-03-2018 02:38 PM
I am handling a cross-sectional data set. I identified that a number of my variable of interests were missing values, including continued, bi-variate and ordinal data.  I am wondering if I can replace the missing values by its mean or median.      And I want to know if there is a cap for allowing the replacing its value, e.g., missing values must less than 10% or so.     Anyone can help much appreciated.   Phan S.   ... View more

Re: Create an Index

by Obsidian | Level 7 in Statistical Procedures
‎01-24-2018 07:37 PM
‎01-24-2018 07:37 PM
I forgot the attachment. ... View more

Re: Create an Index

by Obsidian | Level 7 in Statistical Procedures
‎01-24-2018 07:36 PM
‎01-24-2018 07:36 PM
Hello Reeza,   I attached a file - a researcher used what it called VACS Index to predict HIV mortality. The VACS Index contains: age, CD4 cells, Viral loads, Hemoglobin, FIB-4 and renal function.  I have no idea how they created. For instance, age. The index were 0 if <50 year; 12 if 50-64 year and 65 if 65+ year.   Thank you.   Phan S.       ... View more

Re: Create an Index

by Obsidian | Level 7 in Statistical Procedures
‎01-24-2018 07:16 PM
‎01-24-2018 07:16 PM
Thank your for your input. I just replied to Reeza.   Phan S.  ... View more

Re: Create an Index

by Obsidian | Level 7 in Statistical Procedures
‎01-24-2018 07:14 PM
‎01-24-2018 07:14 PM
Hello Reeza, I am sorry - was not feel well.  I attached a file that contains four questions to evaluate 100% adherence to medications.   The index will be used to see if it correlates with:  a) Length of treatment b) Length of HIV diagnosis c) CD4 cells counts after 6 months of treatment  d) Viral loads after 6 months of treatment    Thank you.   Phan S.              ... View more

Create an Index

by Obsidian | Level 7 in Statistical Procedures
‎01-22-2018 08:22 PM
‎01-22-2018 08:22 PM
Hello,   I have a project that I want to create an index for adherence index to antiretroviral therapy (ART).   Adherence questionnaire composed three questions: dose, instruction and schedule. a. dose is binary answer y/n b. instruction: b1. is binary answer y/n b2. is ordinal answer 1-5 c. schedule is ordinal answer 1-5   Anyone can help is greatly appreciated and thanks in advance.   Regards,   Phan S.        ... View more

Re: Export SAS data to Excel

by Obsidian | Level 7 in ODS and Base Reporting
‎12-04-2017 08:07 PM
‎12-04-2017 08:07 PM
Hello Kurt,   The software has an up-to-date licence and 64 bit. I used proc export as provided by Reeze -- it worked. This method appears not work: File, export, library/member,...   Thanks you.   Phan S.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-04-2025 12:31 PM
Likes given to
Quick links