topic Re: How to reshape data? in SAS Programming

How to reshape data?

GPatel — Thu, 26 May 2016 22:09:47 GMT

ballardw — Thu, 26 May 2016 22:38:48 GMT

Is this for a report or a data set?

GPatel — Thu, 26 May 2016 23:06:51 GMT

This is for data set and then Proc GChart.

Astounding — Fri, 27 May 2016 00:13:38 GMT

Arrays would come in handy, especially if you actually have more than six variables:

data want;

set have;

array flags {6} Flag_A Flag_B Flag_C Flag_D Flag_E Flag_F;

do _n_=1 to 6;

if flags{_n_} > ' ' then do;

FlagVar = vname(flags{_n_});

Flag = flags{_n_};

end;

keep FLagVar Flag N;

run;

GPatel — Fri, 27 May 2016 01:10:25 GMT

Our community "Astounding" user provided excellent solutions.

GPatel — Fri, 27 May 2016 01:14:29 GMT

Our community "Astounding" user provided excellent and timely solutions.

Reeza — Fri, 27 May 2016 02:52:43 GMT

@GPatel wrote:

Our community "Astounding" user provided excellent and timely solutions.

Please mark that solution as the correct answer 🙂

Reeza — Wed, 01 Jun 2016 15:07:20 GMT

You should have marked @Astounding solution as correct, not mine!

Maybe @ShelleySessoms can fix this?

Thanks

ShelleySessoms — Wed, 01 Jun 2016 15:16:37 GMT

All fixed! Thanks for alerting us to the incorrect mark, @Reeza. We definitely want to acknowledge the correct answer!

Astounding — Wed, 01 Jun 2016 15:22:58 GMT