It does work I had put in something wrong. I will accept it as a solution. ... View more

I will give it a try later but the prior post resolved the issue. ... View more

I tried your code and got the following log which indicates that ka1 is being read as invalid numeric data. Can you tell me why NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 487:30 488:13 NOTE: Invalid numeric data, temp1='ka1' , at line 487 column 30. Param=ka1 COL2=. Treat=BREF subn2=0.649437562 subj1=. subj2=1.914463759 subj3=. subj4=. subj5=. subj6=. subj7=. subj8=. subj9=. subj10=. subj11=. subj12=. subj13=. subj14=. subj15=. subj16=. subj17=. subj18=. subj19=. subj20=. subj21=. subj22=. subj23=. subj24=. subj25=. subj26=. subj27=. subj28=. subj29=. subj30=. subj31=. subj32=. subj33=. subj34=. subn1=. subn3=. subn4=. subn5=. subn6=. subn7=. subn8=. subn9=. subn10=. subn11=. subn12=. subn13=. subn14=. subn15=. subn16=. subn17=. subn18=. subn19=. subn20=. subn21=. subn22=. subn23=. subn24=. subn25=. subn26=. subn27=. subn28=. subn29=. subn30=. subn31=. subn32=. subn33=. subn34=. i=35 temp1=ka1 temp2=ka2 _ERROR_=1 _N_=8 I also tried to remove the double quotes "ka1" then the log read: NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 487:28 488:13 NOTE: Variable ka1 is uninitialized. NOTE: Variable ka2 is uninitialized. ... View more

As pointed out it was a mistake on my part to try and drop a data set.  The issue was resolved by having the original macro to start at 2 instead of 1: (%macro bootr; %do i=1% to 34; %do j=2% to 10;)   ... View more

When I used your code: %MACRO bootR; %do i=1% to 34; %DO j=1% to 3; DATA AREF&i._&j(keep=an1 col&j); set ref1_1; Treat='BREF'; run; I get the following errors in the log. SYMBOLGEN: Macro variable J resolves to 3 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATA, DBLABEL, DBMS, DEBUG, FILE, LABEL, OUTFILE, OUTTABLE, REPLACE, TABLE, _DEBUG_. SYMBOLGEN: Macro variable J resolves to 3 200: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

EXTERNAL In words this is my best explanation: For the data set aref1._1, I would like to retain the columns an1, col1, and treat whereas for aref1._2 I would like to retain columns an1, col2, and treat. For aref1._3 I would like to retain an1, col3, and treat. Hopefully this will sufficiently clarify what I want. I will try again.   For each data set DATA  AREF&i._&j where &i refers to subject and &j refers to replicate.The data ref&i._&j which are replicate data sets for a subject in this case subject 1.  These will be set to AREF&i._&j dependent upon the &i and &j values.The data sets REF&i._&j (i.e., ref1_1 and ref1_2) contain the following columns an1, col1,col2, and col3For each data set the columns contain values (e.g., col2     0.649438 1.004508 7.486796 8.70274 2.528415 1.673499 0.333883 )   For any given subjects  AREF1_1 and AREF1_2 I would like to have REF1_1 and REF1_2 set to those AREF files respectively.  The set files and the column to be kept are determined by the subject and the replication.  For AREF1_1 col1 is kept while for AREF1_2 col2 is kept.  In summary,  the col number corresponding to the &j value is kept.   Hopefully this is a clearer explanation. ... View more

I have 3 data sets named ref&i._&j where &i refers to the number of subj while the &j refers to the repetition. The data sets contain the following columns an1 COL1 COL2 COL3 Treat These ref data set will be set to aref&i._&j respective data sets. For the data set aref1._1, I would like to retain the columns an1, col1, and treat whereas for aref1._2 I would like to retain columns an1, col2, and treat. For aref1._3 I would like to retain an1, col3, and treat. Hopefully this will sufficiently clarify what I want. ... View more

This will not work because I will have in my actual runs %DO j=1% to 1000 which means that I would have to code the set ref1_1 many times up to set ref1_1000 which is not practical. ... View more