topic how to share files to each group equally in SAS Programming

how to share files to each group equally

thanikondharish — Mon, 20 May 2019 15:16:51 GMT

data have ;

input id group$ ;

cards ;

101 group1

102 group1

103 group1

104 group2

105 group2

106 group2

;

1)Group1 has 88 files

2)Group2 has 99 files

How to share files each group equally like see below

101 group1 file1

101 group1 file2

..................

106 group2 file99

Re: how to share files to each group equally

noling — Mon, 20 May 2019 18:49:47 GMT

Not exactly clear what you're asking. Please clarify your needs if this isn't helpful:

data want;
	length id 8. group file $10.;
	do id = 101 to 106;
		group = 'group1';
		do i= 1 to 88;
			 file=cats("file",i);
			 output;
		end;
		group = 'group2';
		do i = 1 to 99;
			file=cats("file",i);
			output;
		end;
	end;
	drop i;
run;

Re: how to share files to each group equally

thanikondharish — Tue, 21 May 2019 02:57:19 GMT

One office has 6 employees now we should give work to them they are total
36 files .Now we have distribute equally like see below
101 office1 file1
101 office1 file2
101 office1 file3
101 office1 file4
101 office1 file5
101 office1 file6
102 office1 file7
............
106 office1 file36

Re: how to share files to each group equally

noling — Tue, 21 May 2019 12:21:20 GMT

See if you can modify my previous datastep to get your desired output. Looks like this may need to be a separate table.

You should be able to use the mod function to find values that are divisible by 6 - http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245916.htm