@Programming Novice SAS Programmer here: I have a very large datasets I am combing through, however I am running into a issue with how I might go about automating the consolidation of a repeated measures arrangement into a new dataset. Some background information which might help orient the community to the attached sample document "SAS_question.csv": The score uses the "+" and "-" as they are meaningful -- these are stored as text variables in SAS. I want to find and select the lowest value (this will exclusively be the "-" values) for a given individual (denoted by ID) After locating the lowest value for a given individual, I want to put that into a new dataset How should the code be written to accomplish this? I am willing to learn what will be the easiest way to accomplish this. Further background -- this will be for COVID-19 related research and I am trying to get this valuable information out to the medical community ASAP. Any help would be greatly appreciated!!
... View more