topic Re: Put statement problem in SAS Programming

Put statement problem

Kwok — Fri, 09 Apr 2010 18:48:59 GMT

I try to do a quick and dirty extract of portions from a huge flat file and write out to
another file with the same position using the following code.

DATA ONE;
INFILE INF TRUNCOVER;
INPUT VAR1 $ 127-165
VAR2 $ 265-434
VAR3 $ 457-507
VAR4 $ 527-597
VAR5 $ 660-860
VAR6 $ 861-1060
VAR7 $ 1061-1207
;
RUN;

DATA _NULL_ ;
SET ONE;
FILE OUTC ;
PUT VAR1 127-165
VAR2 265-434
VAR3 457-507
VAR4 527-597
VAR5 660-860
VAR6 861-1060
VAR7 1061-1207
;
RUN;

However, there is nothing in the output file. Can anyone offer some tips why this is not writing out and how to resolve this porblem, ?

Thanks

Re: Put statement problem

sbb — Fri, 09 Apr 2010 19:15:14 GMT

Likely your SAS log reveals warnings, possibly error msgs, related to what you are seeing (or not in this case).

Suggest you simplify your SAS program - there is no need for two DATA steps, also you can use a PUT _INFILE_; statement, coded after your INPUT statement in your first DATA step -- eliminating the need for any additional code. And your first DATA step can specify _NULL_ instead of a SAS dataset since you are reading and writing the external file without needing to create a SAS file. Also, if you are not intending to re-format the file, then the INPUT statement can be simplified to INPUT ; (no SAS variables input).

Confirm some information though, such as what OS platform where the external file resides?

And if you must re-post a reply, provide your exact SAS log output (with COPY and PASTE) while revealing all SAS code and SAS-generated messages.

Scott Barry
SBBWorks, Inc. Message was edited by: sbb

Re: Put statement problem

Kwok — Mon, 12 Apr 2010 12:51:33 GMT

Thanks Scott, you idea works.