topic Transpose a dataset and create buckets in SAS Programming

Transpose a dataset and create buckets

chandan_mishra — Fri, 22 Sep 2017 20:26:16 GMT

I have input data like this:

I want to create bucket out of this data by creating a separate variable called Metric. The dataset should look like this:

Thanks

Chandan Mishra

Astounding — Fri, 22 Sep 2017 21:14:00 GMT

It looks like you need:

data want;

set have;

length metric $ 2;

METRIC = 'R';

BUCKET1 = R1;

BUCKET2 = R2;

output;

METRIC = 'TR';

BUCKET1 = TR1;

BUCKET2 = TR2;

output;

keep CLIENT_ID PRD METRIC BUCKET1 BUCKET2;

run;

chandan_mishra — Fri, 22 Sep 2017 21:20:21 GMT

@AstoundingThanks for such an easy solution.