topic Data step in SAS Programming

Data step

umesh1 — Fri, 31 Mar 2017 18:18:13 GMT

Hi All,

I have below sample data set and I would like to get the desire result as follows.

data test;

input A B C D;

cards;

10 9 13 10

7 7 9 8

6 7 6 8

2 3 3 4

3 4 6 6

6 7 6 7

8 7 7 7

9 8 11 10

9 9 9 9

;

run;

Reslt is as follows

A	B	C	D	Count
10	9	13	10	3
7	7	9	8	3
6	7	6	8	3
2	3	3	4	3
3	4	6	6	3
6	7	6	7	4
8	7	7	7	4
9	8	11	10	4
9	9	9	9	4

Re: Data step

Kurt_Bremser — Fri, 31 Mar 2017 18:20:29 GMT

And what is the logical rule for the intended result?

Re: Data step

ballardw — Fri, 31 Mar 2017 20:00:10 GMT

What are you "counting"?

Re: Data step

PGStats — Sun, 02 Apr 2017 04:03:02 GMT

Shouldn't the result be

A	B	C	D	Count
10	9	13	10	3
7	7	9	8	3
6	7	6	8	4
2	3	3	4	1
3	4	6	6	3
6	7	6	7	2
8	7	7	7	2
9	8	11	10	4
9	9	9	9	4

Re: Data step

LittlesasMaster — Sun, 02 Apr 2017 11:34:44 GMT

What is that you want to accomplish?

Re: Data step

art297 — Sun, 02 Apr 2017 13:22:12 GMT

If your 'want' represents a card related scoring table, where a pair of numbers-3, and anything greater than 1 pair (e.g., 2 pairs, 3 of a kind, 4 of a kind or a straight=4), then you might want to simply modify the code offered at https://communities.sas.com/t5/SAS-Procedures/Allocating-Values-to-Poker-Hands/td-p/146459

It does all of the above, but was written to evaluate all possible poker hands and rank them according to the rules of poker, but you're only working with 4 cards, don't consider suit, and consider anything greater than a pair to be equal to 4.

Art, CEO, AnalystFinder.com