Hi, I am working on .csv file- importing to SAS for analysis. it's a lab data with columns like patient ID, dob, tests performed, results etc. There's varying # of observations for same ID- each repeatition being the "ID" for each test performed for this patient, sth like this- ID DOB TEST RESULT 001 xx-xx-xxxx test result 002 xx-xx-xxxx test result 002 xx-xx-xxxx test2 result2 002 xx-xx-xxxx test3 result3 003 xx-xx-xxxx test result 003 xx-xx-xxxx test2 result2 I want to create a dataset such that for each ID, i have columns- test1, test2, test3 etc. (and similarly, result result1 result2 etc.) and have all tests, results for this ID in 1 row. How can I accomplish this? I do not necessarily need same IDs in my final dataset (not sure if this makes any difference though) Thank you, T
... View more