topic Re: Data step put statement in SAS Programming

Data step put statement

jacksonan123 — Tue, 26 Nov 2019 15:35:27 GMT

data bat;
do i=1 to 3;
com2="rem@echo off";
com="call nmgo" || compress("TEST"||i);
com1="call nmgo" || compress("TEST"||i) ||COMPRESS(".CTL -MAXLIM=3"||""); 
output;
end;
run;
data _null_;
  set bat;
  file '/folders/myfolders/BOOTSTRAP_PED/BATFILEPREP/booti.bat';
  put @1 com2 ; 
  put @2 com1;
run;

I have the attached code which works for what I want to do. However for the put statement I need to limit the rem@echo off to the first line of booti. What I have is this with rem@echo off in every other line:

rem@echo off
CALL NMGO TEST1.CTL -MAXLIM=3

rem@echo off
CALL NMGO TEST2.CTL -MAXLIM=3

but what I want is this for the rem@echo off to appear in only line 1:

rem@echo off
CALL NMGO TEST1.CTL -MAXLIM=3
CALL NMGO TEST2.CTL -MAXLIM=3

Re: Data step put statement

Tom — Tue, 26 Nov 2019 15:34:01 GMT

You can test the automatic iteration counter, _N_, to know when you are on the first iteration of the data step.

Do you want the space after NMGO that appears in the example output or not?

data bat;
  com2="rem@echo off";
  do i=1 to 3;
    com ='call nmgo' || cats("TEST",i);
    com1='CALL NMGO ' || cats("TEST",i,'.CTL -MAXLIM=3);
    output;
  end;
run;
data _null_;
  set bat;
  file '/folders/myfolders/BOOTSTRAP_PED/BATFILEPREP/booti.bat';
  if _n_=1 then put com2 ; 
  put @2 com1;
run;

Re: Data step put statement

ballardw — Tue, 26 Nov 2019 15:38:50 GMT

If I understand what you want try

data _null_;
  set bat;
  file '/folders/myfolders/BOOTSTRAP_PED/BATFILEPREP/booti.bat';
  If _n_ = 1 then put @1 com2 ; 
  put @2 com1;
run;

_n_ is an automatic variable that SAS increments at each "loop" through the data step. In this case it is, in effect, the "line read count".

So test that variable and only create the output the first time.

Unless you need that BAT data set elsewhere this could be done with

data _null_;
   file 'your file';
   put @1 "rem@echo off";
   do i=1 to 3;
      com="call nmgo" || compress("TEST"||i);
      com1="call nmgo" || compress("TEST"||i) ||COMPRESS(".CTL -MAXLIM=3"||""); 
      put @2 com1;
   end;
run;

Re: Data step put statement

jacksonan123 — Tue, 26 Nov 2019 15:50:18 GMT

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.

Re: Data step put statement

ballardw — Tue, 26 Nov 2019 15:56:28 GMT

Please post log entries in a code box. By now you should have realized that the message windows reformat the text and make the diagnostic characters that SAS supplies appear in the wrong location as well as sometimes inserting extra newline characters.

Re: Data step put statement

Tom — Tue, 26 Nov 2019 15:57:24 GMT

You are missing at least one closing quote mark in this line:

78 com1='call NMGO' || cats ("TEST",i,'.CTL -MAXLIM=3);

Re: Data step put statement

jacksonan123 — Tue, 26 Nov 2019 16:00:18 GMT

Works well.

Thanks for the help

Re: Data step put statement

jacksonan123 — Tue, 26 Nov 2019 16:03:18 GMT

I forgot about doing that, next time I will to avoid that mistake.

Re: Data step put statement

jacksonan123 — Tue, 26 Nov 2019 16:07:18 GMT

Your solution also works after I put in the missing (').

Thanks for the help and it is accepted as a solution.