topic Re: mixing up data in New SAS User

mixing up data

VDD — Sat, 26 Oct 2019 02:28:21 GMT

I have a deck of cards using the following data step.

How can I mix-up the cards in the dataset so that I can play 21?

data cards(keep=card suit c2);
do c1= 1 to 4;
	if c1=1 then suit='C';
	else if c1=2 then suit='D';
	else if c1=3 then suit='H';
	else if c1=4 then suit='S';
	do c2= 1 to 13;
		card=c2||suit;
		output;
	end;
end;
run;

Re: mixing up data

Reeza — Sat, 26 Oct 2019 02:38:04 GMT

Maybe this can help:

https://blogs.sas.com/content/iml/2018/06/06/sample-random-order.html

Re: mixing up data

VDD — Sat, 26 Oct 2019 03:00:21 GMT

thank you @Reeza

Re: mixing up data

PGStats — Sat, 26 Oct 2019 03:11:00 GMT

Keep it simple:

data cards;
length card $3;
do suit = "C", "D", "H", "S";
	do c2= 1 to 13;
		card=cats(c2,suit);
		output;
		end;
	end;
run;

proc sql;
create table shuffled as select * from cards order by rand("uniform");
quit;