Hi. I am reading in an Excel spreadsheet and need to convert a character variable to a numeric one.  I'm trying to create a new variable using the INPUT command   Days_to_Event=input(Days_to_Event_A, 8..);    but I keep getting this error:  NOTE: Invalid argument to function INPUT at line 480 column 20   Most of the converted data is missing. What am I missing here? Is it possible that  for the variable in question in the Excel spreadsheet that some of the values are character and some numeric? I need help moving forward.    All help is appreciated.    Thank you   ... View more

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.   ... View more

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.      ... View more