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