topic SAS Programming - COVID-19 PROJECT!! in SAS Programming

SAS Programming - COVID-19 PROJECT!!

add4514 — Tue, 19 May 2020 22:52:59 GMT

@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!!

Re: SAS Programming - COVID-19 PROJECT!!

ballardw — Tue, 19 May 2020 23:15:27 GMT

Question, why are your + and - values character? Pretty much a trivial exercise if they are numeric.

For example if the score is numeric:

proc summary data=have nway;
   class id;
   var score;
   output out=work.summary (drop=_type_) min=;
run;

Would create a new data set with the Id, the smallest score (and an extra variable _freq_ with the number of records that ID had in the starting set , you could remove it by adding it to the Drop list).

Here is how to read that data in so score is numeric:

data have;
   infile "d:\path\SASQuestion.csv" dlm=',' ;
   input id $ score;
run;

Re: SAS Programming - COVID-19 PROJECT!!

ChrisNZ — Tue, 19 May 2020 23:21:05 GMT

>I have a very large datasets

Are these SAS data sets? If so just run this:

proc sql;

select ID, min(SCORE) from TABLE group by ID;

quit;

Re: SAS Programming - COVID-19 PROJECT!!

add4514 — Wed, 20 May 2020 02:51:54 GMT

I didn't even think of that!!!!

Thank you!!! 🙂

Re: SAS Programming - COVID-19 PROJECT!!

add4514 — Wed, 20 May 2020 02:52:39 GMT

great idea!!!!