Hello,   I have a macro that runs a regression over a set of variables. It outputs datafiles from the regressions, manipulates them, and then I have code that joins them all together. However, some of the regressions do not converge, so the output datasets are not generated. Because of this, the combined dataset is not generated because it is trying to use nonexistent datasets to make itself.    Here is the code I use to combine the datasets:  data Combined; set %do i = 1 %to &numo; tt3_&i %end; ; *ends i; run; &numo is the number of variables to be run (1,2,3,4...), so tt3_&i  is the output dataset and might be tt3_121, etc.    I am getting errors like this:  ERROR: File WORK.TT3_16.DATA does not exist. ERROR: File WORK.TT3_34.DATA does not exist. ERROR: File WORK.TT3_64.DATA does not exist. ERROR: File WORK.TT3_72.DATA does not exist. ERROR: File WORK.TT3_104.DATA does not exist. ERROR: File WORK.TT3_109.DATA does not exist. ERROR: File WORK.TT3_125.DATA does not exist. How can I either have the code ignore these missing datasets/errors or create dummy datasets when those don't exist so that the combination step works.    Thanks in advance!  ... View more

Hello,   I am trying to code all of the permutations of given length such that I get the following in one dataset:  a b c .............. a a  a b b a ............. a a a  a a b a a c a a d a a e ........... etc.    Is there a way to do this iteratively in either base SAS or IML? I am able to make this using repetition in IML.        Current code example (but repeated out to however many times): proc IML; c_num=repeat(1,5); perm1=T(1:5); p_num=T(1:5); index=T(1:5); create OutData1_org var {c_num, perm1, p_num, index}; /* create Work.OutData for writing */ append; /* write data in x and y */ close OutData1_org; data OutData1; set OutData1_org; format perm $18.; perm=cats(perm1); drop perm1; run; proc IML; a=T(1:5); c_num=repeat(2,25); perm1=repeat(a, {5 5 5 5 5}); perm2=repeat(1:5,5); p_num=T(6:30); index=T(1:25); create OutData2_old var {c_num, perm1, perm2,p_num, index}; /* create Work.OutData for writing */ append; /* write data in x and y */ close OutData2_old; data OutData2; set OutData2_old; perm_test=put(perm1,$1.)||" "||put(perm2,$1.); perm=put(perm_test, $18.); drop perm1 perm2 perm_test; run;   data Perms; set OutData1 OutData2; run; ... View more