About joesmama

joesmama · ‎11-10-2022

Thank you Paige. I was definitely over thinking it.

joesmama · ‎11-10-2022

Hello, I'm trying to calculate blood pressure means per subject over the course of multiple blood pressure readings. Subjects can have a range of visits from few to many. My data is organized as follows PAT_ID Date Systolic Diastolic Meds 1 2-Nov-22 155 85 1 3-Nov-22 135 90 1 5-Nov-22 145 77 1 6-Nov-22 145 82 2 7-Nov-22 158 98 2 22-Apr-22 130 70 2 22-May-22 140 80 med 1 2 4-Oct-22 130 72 2 11-Oct-22 142 65 3 14-Oct-22 154 61 3 18-Oct-22 145 70 4 23-Oct-22 150 69 4 30-Oct-22 144 71 4 22-Apr-22 165 90 med 2 4 22-Jun-22 160 80 med 2 5 22-Aug-22 . . med 3 5 4-Oct-22 128 93 5 8-Oct-22 162 96 5 9-Oct-22 158 96 6 11-Oct-22 149 91 6 14-Oct-22 154 86 I know some of my analysis will involve FIRST and LAST, but how do I calculate the mean per subject when the number of visits per subjects is not necessarily the same. I think I need to use an array here but need a little help getting started. Thank you in advance for your help.

joesmama · ‎11-10-2022

Thank you Tom. I'm going to give this one a try as well.

joesmama · ‎11-10-2022

Thanks Reeza. I used your second suggestion and it worked nicely. Appreciate the help.

joesmama · ‎11-09-2022

Thanks for you response. Assuming the SBP, DBP and TI are in the same order, how can I simplify this?

joesmama · ‎11-08-2022

Hello, I am trying to use Proc Transpose to restructure my dataset. I've been given an Excel file that contains dates, blood pressures and notes (fictitious data). The data read the long way (across) but I need to get the file to read down. The same date appears three times to because each blood pressure is recorded as systolic, diastolic and notes. Name 22-Apr 22-Apr 22-Apr 22-May 22-May May-22 SBP DBP TI SBP DBP TI AAA 120 60 BBB 130 70 140 80 ACT CCC 165 90 start ACE DDD 115 70 EEE 135 75 BCT This is how I'd like the dataset to look. Name Date SBP Name Date DBP Name Date TI Name Date SBP Name Date DBP Name Date TI I'm a bit stuck because of the data headers being in two rows. I've been looking at numerous examples but can't figure out how to do this. And help would be appreciated. Thank you.

joesmama · ‎04-21-2021

Brilliant! I can't believe I didn't think of that. Thank you.

joesmama · ‎04-21-2021

Hello, I haven't used SGPLOT aside from the very basics. I have a Forest plot for which I would like to edit the labels. I would also like to reorder the variables so they match the order in the odds ratio table. In my example below, I would like to remove the variables names "Race_new" and "Sex" but keep "Age". I would also like to put "Age" in top followed by "Sex" and then "Race". I've been scouring SAS resources but I can't seem to find anything to address these questions specifically. My code can be found below. Any help would be greatly appreciated. proc sgplot data=orci_a; scatter x=oddsratioest y=effect / xerrorlower=lowercl xerrorupper=uppercl markerattrs=or (symbol=DiamondFilled size=8); refline 1 / axis=x; xaxis label="OR and 95% CI " min=0; yaxis label="Covariates"; run;

joesmama · ‎02-22-2021

Looks like one of my parentheses was out of order. It worked like a charm. Thank you!

joesmama · ‎02-22-2021

That sounds like it might work. I'm not familiar with how to do that. Can you point me in the right direction please? Thanks.

joesmama · ‎02-22-2021

Thank you. I've tried that and it keeps coming back blank. I've tried with FINDW as well and that comes back blank or empty as well. Am I missing something? . Why would it come back as blank? Alsp, my string is actually 232 characters long. Appreciate your help.

joesmama · ‎02-22-2021

Hello, I am trying to search an 80 character variable in my dataset called PROCDUCT and categorize its contents. For example, I'd like to search PRODUCT for any of the words related to a book (paperback, volume, etc) and then create a new product variable that contains with word BOOK for that record. I've tried FIND and FINDW but its not returning the results I'm looking for. What is the best way to go about this? Thank you.

joesmama · ‎01-25-2021

Thank you very much Rick.

joesmama · ‎01-24-2021

Thank you for the response. That clarifies things. One question: do we still report the estimates from the Firth analysis or just the confidence limits and likelihood tests?

joesmama · ‎01-22-2021

Hello, I am running proc logistic on my dataset and have come across a quasi-complete separation error. I've managed to figure out which variable is causing the issue: a cross tabulation of two variables (dependent x independent) showed that one of the cells in the 2x2 is 0. My original logistic regression model yielded a enormous odds ratio for this variable and CIs that are essentially +-infinity. Using Paul Allison's suggestions on dealing with the quasi-complete separation, I narrowed it down to adjusting the model to use the Firth method. Now my results look much more reasonable, although the CIs (using profile likelihood CIs) are still quite wide (n=220). My question is: Do I now report these "modified" ORs and CIs as I normally would and just mention that the Firth method was used or do I need to go into additional detail. Any input is appreciated.

Online Status	Offline
Date Last Visited	‎01-28-2024 01:15 AM

Re: Longitudinal Data: How do I calculate blood pressure means per sub...

Longitudinal Data: How do I calculate blood pressure means per subject...

Re: Proc transpose for Excel file with two rows for headers

Re: Proc transpose for Excel file with two rows for headers

Re: Proc transpose for Excel file with two rows for headers

Proc transpose for Excel file with two rows for headers

Re: Editing labels on Forest Plot in SGPlot and reordering variables

Editing labels on Forest Plot in SGPlot and reordering variables

Re: FInding a word in a string and assigning it to a new variable

Re: FInding a word in a string and assigning it to a new variable

Re: make new variable from repeated measurements?

Re: Proc transpose for Excel file with two rows for headers

Re: SAS Tip: Conversion from Excel Date to SAS Date

Re: Convert a Column Title to Date Format

Re: How to convert Character String (in yyyy-mm-dd format) to Date

Re: Proc transpose for Excel file with two rows for headers

Re: "Unable to load Java Virtual Machine" SAS 9.4 while running PHREG

SAS 9.4 not responding

Re: Longitudinal Data: How do I calculate blood pressure means per sub...

Longitudinal Data: How do I calculate blood pressure means per subject...

Re: Proc transpose for Excel file with two rows for headers

Re: Proc transpose for Excel file with two rows for headers

Re: Proc transpose for Excel file with two rows for headers

Proc transpose for Excel file with two rows for headers

Re: Editing labels on Forest Plot in SGPlot and reordering variables

Editing labels on Forest Plot in SGPlot and reordering variables

Re: FInding a word in a string and assigning it to a new variable

Re: FInding a word in a string and assigning it to a new variable

Re: FInding a word in a string and assigning it to a new variable

Finding a word in a string and assigning it to a new variable

Re: quasi-complete separation in proc logistic: question about Firth m...

Re: quasi-complete separation in proc logistic: question about Firth m...

quasi-complete separation in proc logistic: question about Firth metho...