topic Remove duplicate date variable in SAS Programming

Remove duplicate date variable

Haydo — Wed, 30 Aug 2023 05:18:18 GMT

Below is a sample of the data I get. Basically I want 1 row per Weekending so CLLS and TFS are on 1 row per date.

Desired result.

ballardw — Wed, 30 Aug 2023 06:35:35 GMT

Are there more variables involved in the data set?

Are the variables CLLS and TFS numeric?

If the answer to the first is NO and Yes to the second this may be the easiest:

Proc summary data=yourdataset nway;
   class weekending;
   var clls tfs;
   output out=want (drop=_: ) max=;
run;

If there are other variables you will need to provide a more complete example and what is done with the other variables.