Actually I didn't really understand how the proc pml work, and I don't know if it could help me or if there is any better statement ... View more

Unfortunately no...  Allcombi give me an error when I use a N>k where k are the number of possible combinations between X and Y, that's cause it computes the number of combinations of K elements taken N at a time. While the Do loop of ballardw and your code give all the possible combinations between X and Y, but what I need is every possible dataset that contains not only all the combination of X and Y, but also simulate other data (which are other combination of X and Y) for a given N sample size. Basically every dataset/tables is unique and should contain at least once every combinations of X and Y plus other data that can assume the combination of X and Y. For example if i have N=5 X=(0, 1) Y=(0, 1) the dataset that I should have are: X Y        X Y        X Y      X Y 0 0         0 0        0 0       0 0 0 0         1 0        1 0       1 0 1 0         1 0        0 1       0 1 0 1         0 1        0 1       1 1 1 1         1 1        1 1       1 1   The order doesn't count so all that matters are the frequencies of the data.   Other dataset like: X Y 0 0 0 0 0 0 1 0 0 1    have N sample size, but it doesn't contain all the possible combination of X and Y I hope that I had explained better... Thank you for the interesting ... View more

Hi, I explain wrong my problems in first place, sorry... the N value is the number of the sample size that I want, for example, if I want to simulate a case-control study, N is the number of the patient, and the combinations of X and Y are all the possible conditions of the patient (X=disease(1 yes, 0 no), Y=exposure(1 yes, 0 no)). What i need is every dataset of N numerosity that contain all the possible case of the data (the order doesn't count), and all the possible combination of X and Y (1 1, 1 0, 0 1, 0 0) ... View more

Hi, I wrong explain my problems in first place, sorry... the N value is the number of the sample size that I want, for example, if I want to simulate a case-control study, N is the number of the patient, and the combinations of X and Y are all the possible conditions of the patient (X=disease(1 yes, 0 no), Y=exposure(1 yes, 0 no)). What i need is every dataset of N numerosity that contain all the possible case of the data (the order doesn't count), and all the possible combination of X and Y (1 1, 1 0, 0 1, 0 0) ... View more

If i have N=5 X=(0, 1) Y=(0, 1) I expect to have 4 unique datasets with every combination of X and Y: X Y        X Y        X Y      X Y 0 0         0 0        0 0       0 0 0 0         1 0        1 0       1 0 1 0         1 0        0 1       0 1 0 1         0 1        0 1       1 1 1 1         1 1        1 1       1 1 since order doesn't count. I know the number of different unique dataset by this formula: N=given numerosity of the sample K=number of combination of X and Y (0 0, 0 1, 1 0, 1 1 in this case) (n-1)!/[(k-1)!(n-k)!]   ... View more

Hello everyone, I'm a freshly new Sas User, I need to generate various dataset of N sample numerosity with every possible combination of the value of X and Y. Y is a binary variable (0, 1) and X can vary (it can be binary or -1,0,1 or -2,-1,0,1,2 etc, but always with integers number). I need to simulate every possible dataset which has N numerosity and every observation of the dataset has an X and a Y value. So if I have N=5 X=(0, 1) Y=(0, 1) my datasets will look like: X   Y  ID                 X   Y  ID                 X   Y   ID           1   0   1                  0    0   1                 1    1   1 1   1   2                  0    1   2                 1    0   2 1   1   3                  1    0   3                 0    0   3 0   1   4                  1    1   4                 1    1   4 0   0   5                  0    1   5                 0    1   5     etc.. etc..   And so on with every possibly combination P.S. it's not strictly necessary that the result are in different dataset, and it's better if there are only the datasets with ALL the combination of X and Y  (in this case 1 1,  1 0,  0 1,  0 0) I had tried to find a function but i can't find anything... Thanks Everyone ... View more