Remove duplicate date variable

[Haydo]

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.

Weekending	CLLS	TFS
9-Jul-23		25629
9-Jul-23	187061
16-Jul-23		5227
16-Jul-23	906430
23-Jul-23		48448
23-Jul-23	515269
30-Jul-23		23582
30-Jul-23	593329

Desired result.

Weekending	CLLS	TFS
9-Jul-23	187061	25629
16-Jul-23	906430	5227
23-Jul-23	515269	48448
30-Jul-23	593329	23582

[ballardw · Accepted solution]

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.