Thank you, Warren. You are completely right, it was the showstopper  )   proc freq data=sample&i noprint; tables class*survived / chisq; output out=sampleX&i (keep=_PCHI_ P_PCHI)chisq; run; ... View more

Hi all,   Here it is the desicion using the link provided by Reeza.   proc means data=sample&i noprint; var fare; output out=sampleX&i(drop=_type_ _freq_) mean= std= / autoname; run; data sampleY&i; length sample_no $2 seed_no $5; set sampleX&i; sample_no=&i; seed_no=&&seed&i; run; ... View more

Thank you! It resolves the issue.   Just one question. Is 'i' local or global macrovariable?   Here below is the full code libname mylib 'C:\MYLIB_KP3'; data _null_; infile datalines dlm=','; input seedX @@; n+1; call symput('seed'!!strip(put(n,2.)),strip(seedX)); datalines; 12345,23456,34567,45678,56789,67891,78912,89123,91234,92345 ; run; %macro team; %do i=1 %to 10; proc surveyselect data = mylib.titanic method = srs n = 100 out = sample&i noprint seed=&&seed&i; run; %end; %mend team; %team; and the log: 1361 libname mylib 'C:\MYLIB_KP3'; NOTE: Libref MYLIB was successfully assigned as follows: Engine: V9 Physical Name: C:\MYLIB_KP3 1362 1363 data _null_; 1364 infile datalines dlm=','; 1365 input seedX @@; 1366 n+1; 1367 call symput('seed'!!strip(put(n,2.)),strip(seedX)); 1368 datalines; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 1367:52 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 1370 ; 1371 run; 1372 1373 %macro team; 1374 1375 %do i=1 %to 10; 1376 1377 proc surveyselect data = mylib.titanic 1378 method = srs 1379 n = 100 1380 out = sample&i 1381 noprint 1382 seed=&&seed&i; 1383 run; 1384 1385 %end; 1386 1387 %mend team; 1388 1389 %team; MLOGIC(TEAM): Beginning execution. MLOGIC(TEAM): %DO loop beginning; index variable I; start value is 1; stop value is 10; by value is 1. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample1 noprint seed=12345; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE1 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 2; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample2 noprint seed=23456; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE2 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 3; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample3 noprint seed=34567; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE3 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 4; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample4 noprint seed=45678; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE4 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 5; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample5 noprint seed=56789; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE5 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 6; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample6 noprint seed=67891; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE6 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 7; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample7 noprint seed=78912; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE7 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(TEAM): %DO loop index variable I is now 8; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample8 noprint seed=89123; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE8 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(TEAM): %DO loop index variable I is now 9; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample9 noprint seed=91234; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE9 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(TEAM): %DO loop index variable I is now 10; loop will iterate again. MPRINT(TEAM): proc surveyselect data = mylib.titanic method = srs n = 100 out = sample10 noprint seed=92345; MPRINT(TEAM): run; NOTE: The data set WORK.SAMPLE10 has 100 observations and 6 variables. NOTE: PROCEDURE SURVEYSELECT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(TEAM): %DO loop index variable I is now 11; loop will not iterate again. MLOGIC(TEAM): Ending execution. 1390   ... View more