Works well. Thanks for the help ... View more

When I ran the code I got this error in the log. data bat; 75 com2="rem@echo off"; 76 do i=1 to 3; 77 com='call NMGO' || cats ("TEST",i); 78 com1='call NMGO' || cats ("TEST",i,'.CTL -MAXLIM=3); 79 output; 80 end; 81 run; 82 data _null_; 83 set bat; 84 file '/folders/myfolders/BOOTSTRAPAPTENSIO_PED/BATFILEPREP/boot.bat'; 85 IF _N_=1 THEN put com2 ; 86 put @2 com1; 84 file '/folders/myfolders/BOOTSTRAPAPTENSIO_PED/BATFILEPREP/boot.bat'; ________ 557 ERROR 557-185: Variable boot is not an object. 87 run; 88 89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90 ODS HTML CLOSE; 91 &GRAPHTERM; ;*';*";*/;RUN;QUIT; ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. ... View more

I followed your bullet point #1 and I did output a batch file titled boot1.bat using this code: DATA _NULL; LENGTH MYOUT $200; FILE '/folders/myfolders/BOOTSTRAP_PED/BATFILEPREP/boot1.bat' FILENAME=MYOUT; PUT MYOUT; RUN; The file contents was the path name /folders/myfolders/BOOTSTRAP_PED/BATFILEPREP/boot1.bat which I do not want. If boot1.bat were empty that would be best. I have not tried your point #2 but maybe you can address the question that if I follow point #2 will that allow me to populate boot1.bat with NMGO TEST1.CTL -MAXLIM=3? ... View more

I have tried all of the things you suggested and none worked. To determine if the I had access to the programs, I opened a sas program from the directory on the side. It loaded without issue so I am unsure if that tells me anything or not. I returned to the shared files set up to see if I had made an error but I saw no issue. ... View more

A summary confidence interval will be calculated so data order is not important. ... View more

This is the log but same error. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 DATA NEWt1; 75 INPUT SUBJ TRT $ AUCL AUCI CPEAK HALF TPEAK TLAG ; 76 CARDS; NOTE: The data set WORK.NEWT1 has 3 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 80 ; 81 run; 82 83 %macro splitdsnbyobs(dsn,splitby); 84 %local no_obs firstobs finalobs; 85 %RecsInDS(&dsn,no_obs); 86 87 %do i=1 %to %sysfunc(ceil(&no_obs/&splitby)); 88 /*calculate the first and final obs for each do loop iteration*/ 89 %let firstobs=%sysfunc(floor((&i.-1)*&splitby.+1)); 90 %let finalobs=%sysfunc(ceil(&i * &splitby.)); 91 %let finalobs=%sysfunc(min(&finalobs,&no_obs)); 92 93 /* keep the observations from firstobs= and obs=*/ 94 data &dsn.&i.; 95 set &dsn (firstobs=&firstobs. obs=%finalobs.); 96 run; 97 %end; 98 %mend splitdsnbyobs; 99 100 %splitdsnbyobs(newt1,1); NOTE: Line generated by the invoked macro "SPLITDSNBYOBS". 100 %RecsInDS(&dsn,no_obs); _ 180 WARNING: Apparent invocation of macro RECSINDS not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: Argument 1 to function CEIL referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %sysfunc(ceil(&no_obs/&splitby)) ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro SPLITDSNBYOBS will stop executing. 101 102 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 114 User: sasdemo ... View more

I got the following log with the same errors as before with new code same data set. DATA NEWT1; INPUT SUBJ TRT $ AUCL AUCI CPEAK HALF TPEAK TLAG ; CARDS; 1 A 2079.16 2087.26 2556.76 1.1 1.5 1 2 A 1377.26 . 777.38 . 8 8 3 A 1899.42 1908.64 2002.591 1.13 1.5 1 ; RUN; 85 %macro splitdsnbyobs(dsn,splitby); /* defined macro with arguments to be used in code */ 86 %RecsInDS(&dsn,no_obs); /* Read more about this macro at 86 ! http://sastechies.blogspot.com/2009/11/ways-to-count-number-of-obs-in-datase t.html */ 87 88 /*calculate the final obs for each do loop iteration*/ 89 90 %macro finalobs; 91 %if %sysfunc(ceil(&i * &splitby.)) gt &no_obs %then &no_obs; 92 %else %sysfunc(ceil(&i * &splitby.)); 93 %mend finalobs; 94 /* keep the observations from firstobs= and obs=*/ 95 %do i=1 %to %sysfunc(ceil(&no_obs/&splitby)); 96 data &dsn.&i.; 97 set &dsn (firstobs=%sysfunc(floor(&i.-1)*&splitby.+1) obs=%finalobs); 98 run; 99 %end; 100 %mend splitdsnbyobs; 101 102 %splitdsnbyobs(newt1,3); /* line added to execute the macro code */ NOTE: Line generated by the invoked macro "SPLITDSNBYOBS". 102 %RecsInDS(&dsn,no_obs); %macro finalobs; %if %sysfunc(ceil(&i * &splitby.)) gt &no_obs %then &no_obs; %else _ 180 102 ! %sysfunc(ceil(&i * &splitby.)); %mend finalobs; WARNING: Apparent invocation of macro RECSINDS not resolved. MPRINT(SPLITDSNBYOBS): %RecsInDS(newt1,no_obs); ERROR 180-322: Statement is not valid or it is used out of proper order. WARNING: Apparent symbolic reference NO_OBS not resolved. WARNING: Apparent symbolic reference NO_OBS not resolved. ERROR: Argument 1 to function CEIL referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %sysfunc(ceil(&no_obs/&splitby)) ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro SPLITDSNBYOBS will stop executing. 103 104 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ... View more

I used your code with the following data set below (newt1) and got the following error. 100 %splitdsnbyobs(newt1,3); /* line added to execute the macro code */ NOTE: Line generated by the invoked macro "SPLITDSNBYOBS". 100 %RecsInDS(&dsn,no_obs); %macro finalobs; %if %sysfunc(ceil(%eval(&i * &splitby.))) gt &no_obs %then &no_obs; _ 180 100 ! %else %sysfunc(ceil(%eval(&i * &splitby.))); %mend finalobs; WARNING: Apparent invocation of macro RECSINDS not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. WARNING: Apparent symbolic reference NO_OBS not resolved. WARNING: Apparent symbolic reference NO_OBS not resolved. ERROR: Argument 1 to function CEIL referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %sysfunc(ceil(&no_obs/&splitby)) ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro SPLITDSNBYOBS will stop executing. 101 DATA NEWt1; INPUT SUBJ TRT $ AUCL AUCI CPEAK HALF TPEAK TLAG ; CARDS; 1 A 2079.16 2087.26 2556.76 1.1 1.5 1 2 A 1377.26 . 777.38 . 8 8 3 A 1899.42 1908.64 2002.591 1.13 1.5 1 ; run; ... View more

Because I will have 200 such files and trying to convert each would be very time consuming. A prior response gave the correct answer. I needed to name the variables and then it an okay. ... View more