Hello, Thank you!! Proc transpose worked 🙂 just got the request updated-- I would like to get all other variables present in the dataset like result, unit, range etc. along with the SubjectID and test name. All corresponding lab variables are labeled as Result1-13, Unit1-13, Range1-13 like Lab1-13 data Lab; infile datalines; input Subjid $ Lab1 Lab2 Lab3 Lab4 Lab5 Lab6 Lab7 Lab8 Lab9 Lab10 Lab11 Lab12 Lab13 Result1 Result2 Result3 Result4 Result5 Result6 Result7 Result8 Result9 Result10 Result11 Result12 Result13 ; datalines; Subj1 1 3 3 1 1 1 1 2 . 1 1 1 1 01 02 03 04 05 06 07 08 . 010 011 012 013 Subj2 1 1 1 1 1 1 1 1 1 1 1 . 3 011 012 013 014 015 016 017 018 019 0110 0111 . 0113 ; run; Get ALL respective variables like result, unit, range etc. for the records with Any Lab from 1 to 13 has value 3 Data Want; Subject Lab Name Lab Result Lab Units etc.. -------------------------------------------------- Subj1 Lab2 02 Subj1 Lab3 03 Subj2 Lab13 0113
... View more