I'm trying my hand at incorporating time-dependent variables in cox proportional hazard modeling through the counting process.   I am up to the first step - creating indicator variables to tell me when the "nlr" status changes:   DATA change; SET change; ARRAY nlr_(*) nlr_0-nlr_3; *call in the time-varying nlr variables; ARRAY chng(3); *the new indicator variables; t=1; *initialise the position variable for the indicator variables; DO i = 1 to 3; if nlr_(i) NE nlr_(i-1) THEN DO; *detects whether there is a change in nlr status; chng(t) = i-1; *assigns the last timept the status remained constant; t=t+1; END; END; RUN;   However, this message is popping up in my log -  ERROR: Array subscript out of range at line 2863 column 20.   This is from the change dataset: subjid3 nlr_0 nlr_1 nlr_2 nlr_3 A1 0 0 0 0 A10 1 0 0 1 A100 0 0 0 0   And I am aiming for it to look like this: subjid3 chng1 chng2 chng3 nlr_0 nlr_1 nlr_2 nlr_3 A1 . . . 0 0 0 0 A10 . . 2 1 0 0 1 A100 . . . 0 0 0 0   Not sure what I am doing wrong - appreciate any input (sorry am a beginner at this!) ... View more

Hi,   I have the dataset as below (at the bottom) - I have put the first 3 patients but my total dataset is over 1000 .   I would like to calculate the mean for STL0-STL24 and 95% CI for each subjid3. I would like to calculate mean for nlr0 to nlr24 and 95%CI for each subjid3.   How do I create a macro and loop to achieve this?   Thanks in advance,   subjid3 STL0 STL6 STL12 STL18 STL24 nlr0 nlr6 nlr12 nlr18 nlr24 TRT 1 113 137 155 . . 2 1.5 1.25 . . 0 2 225 194 188 205 . 6 3 3.4 7 . 1 3 336 306 . 260 . 2 1.7 . 1.9 . 1 ... View more

Hi   I am a beginner at SAS - I have produced a KM curve but having trouble editing the axes.    I used the code below: ODS graphics on; ODS select survivalplot(persist) failureplot(persist); PROC lifetest data=solo2_date plots=survival (test atrisk (maxlen=8 outside (0.15))); Time ttpfs*pfs(0); strata randtrt; run; ODS graphics off;   It gives me the KM curve but I would like to edit : y axis - instead of 0.0 to 1.0 in increments of 0.2 , i would like 0 to 100 in increments of 20 (%) x axis - instead of days 0 to 1000 in increments of 200 I would like in months in increments of 3 I've tried reading other posts and guides but just not getting it right. Any help appreciated, thanks. ... View more

Hi,   After transposing my long dataset to wide, I realised some variables were the same but titled differently (one is serum, and the other plasma). So now I would like to clean my data further by merging the variables but having trouble with the coding.    For example (see sample data below): For subject E01, I would like to put the data for 'var_Alanine_Aminotransferase__P' under the first variable 'var_Alanine_Aminotransferase__Se' and delete 'var_Alanine_Aminotransferase__P' . Similarly, I would like to put the data under 'var_Alkaline_Phosphatase__Plasma' under the 3rd variable 'var_Alkaline_Phosphatase__Serum_'.   What is the best way to go about doing this? Thanks in advance.     SUBJECT var_Alanine_Aminotransferase__Se var_Albumin__Serum_ var_Alkaline_Phosphatase__Serum_ var_Aspartate_Aminotransferase__ var_Bilirubin__Total__Serum_ var_Calcium__Serum_ var_Carbohydrate_Antigen_125__Se var_Creatinine__Serum_ var_Gamma_Glutamyltransferase__S var_Hemoglobin__Blood_ var_Lactate_Dehydrogenase__Serum var_Leucocytes__Particle_Concent var_Lymphocytes__Particle_Concen var_Neutrophils__Particle_Concen var_Platelets__Particle_Concentr var_Protein__Total__Serum_ var_Alanine_Aminotransferase__Pl var_Alkaline_Phosphatase__Plasma var_Bilirubin__Total__Plasma_ var_Calcium__Plasma_ var_Creatinine__Plasma_ var_Gamma_Glutamyltransferase__P var_Lactate_Dehydrogenase__Plasm var_Lymphocytes__Blood_ var_Protein__Total__Plasma_ var_Albumin__Plasma_ E02 27 43 129 34 6 2.54 5 68 29 122 241 7.3 2.5 3.8 175 75                     E01       26     39     115   5.11 2.5 2.2 187   37 72 3.249 2.36 83.98 18 231 49.7 74   ... View more

Hi   Apologies as this is quite simple but I haven't been able to address it. I am transposing a long dataset into wide and I have been able to do so but in the process, lost 3 subjects. Because an ID value occurs twice in the same BY group, SAS is omitting the subject altogether so that in total i have 292 subjects (rather than 295 in total). "Error: The ID value "var_Aspartate_Aminotransferase__" occurs twice in the same BY group...3 BY groups omitted due to earlier errors."(i think it's because sas does not recognise the full name as it exceeds the character limit as one is actually serum and the other plasma).    I tried to modify by dataset and command "if labname=Aspartate_Aminotransferase__Plas then remove;" but the log comes up as "Variable Aspartate_Aminotransferase__Plas is uninitialized."    I would like to take out the culprit duplicated aspartate_aminotransferase variable before doing my proc transpose command and essentially keep all 295 subjects if it means either deleting the whole variable (as i dont need it in my final analyses) or being able to pick out how to delete the offending 'duplication'.   I have copied in the long data format of 2 of the subjects with duplicated aspartate_aminotransferase that led to it being omitted.   Thanks,   subject labname labvalue E03 Albumin (Plasma) 47 E03 Albumin (Serum) 43.3 E03 Alkaline Phosphatase (Plasma) 80 E03 Alkaline Phosphatase (Serum) 74 E03 Aspartate Aminotransferase (Plasma) 22 E03 Aspartate Aminotransferase (Serum) 31 E03 Basophils, Particle Concentration (Blood) 0.01 E03 Bilirubin, Total (Plasma) 9 E03 Bilirubin, Total (Serum) 13.68 E03 Calcium (Plasma) 2.39 E03 Calcium (Serum) 2.4451 E03 Carbohydrate Antigen 125 (Serum) 17.8 E03 Creatinine (Plasma) 58 E03 Creatinine (Serum) 70.72 E03 Eosinophils, Particle Conc. (Blood) 0.08 E03 Erythrocytes, Mean Cell Volume (Blood) 101 E03 Erythrocytes, Particle Concentration (Blood) 3.56 E03 Gamma-Glutamyltransferase (Plasma) 13 E03 Gamma-Glutamyltransferase (Serum) 15 E03 Hemoglobin (Blood) 122 E03 Lactate Dehydrogenase (Plasma) 164 E03 Lactate Dehydrogenase (Serum) 399 E03 Leucocytes, Particle Concentration (Blood) 3.6 E03 Lymphocytes, Particle Concentration (Blood) 0.97 E03 Magnesium (Plasma) 0.93 E03 Magnesium (Serum) 0.94622 E04 Albumin (Plasma) 44 E04 Albumin (Serum) 36 E04 Alkaline Phosphatase (Plasma) 57 E04 Alkaline Phosphatase (Serum) 58 E04 Aspartate Aminotransferase (Plasma) 25 E04 Aspartate Aminotransferase (Serum) 22 E04 Basophils, Particle Concentration (Blood) 0.03 E04 Bilirubin, Total (Plasma) 5 E04 Bilirubin, Total (Serum) 7.866 E04 Calcium (Plasma) 2.38 E04 Calcium (Serum) 2.2954 E04 Carbohydrate Antigen 125 (Serum) 15.4 E04 Creatinine (Plasma) 67 E04 Creatinine (Serum) 67.184 E04 Eosinophils, Particle Conc. (Blood) 0.16 E04 Erythrocytes, Mean Cell Volume (Blood) 94 E04 Erythrocytes, Particle Concentration (Blood) 3.72 E04 Gamma-Glutamyltransferase (Plasma) 24 E04 Gamma-Glutamyltransferase (Serum) 30 E04 Hemoglobin (Blood) 117 E04 Lactate Dehydrogenase (Plasma) 211 E04 Lactate Dehydrogenase (Serum) 212 E04 Leucocytes, Particle Concentration (Blood) 5 E04 Lymphocytes, Particle Concentration (Blood) 1.46 E04 Magnesium (Plasma) 0.75 E04 Magnesium (Serum) 0.777546 ... View more

Hi,   I am having trouble transposing this long data set (see attachment) into a wide one. I'd like for each row to correlate with a subject and for the blood results to go horizontally (wide) rather than vertically (long) as it stands presently. Appreciate any help!   Attached excel spreadsheet is a sample of the data I am dealing with and shows how I would like the data transposed but unsure how to go about this with the PROC transpose command. I am using SAS 9.4.   E.G.  PROC TRANSPOSE DATA=bloods2 OUT=bloodswide prefix=labvalue; BY SUBJECT; ID labname; VAR labvalue; RUN ; ==>  lots of error comes up in the log 'ERROR: The ID value "labvalue_Ery__Mean_Cell_Hemoglob" occurs twice in the same BY group.'   Many thanks ... View more