_null_ and export file

[SannaSanna]

Hello. 

I am trying to export a text file with specific position points for columns.  I am having difficulty with removing the extra blank line after each row of data.   This text file must have line record length of 455 and CRLF return but it seems like my file is producing CR after each row of data.   This is the code I am using.  Can anyone see what needs to be modified.  Any help would be greatly appreciated.  Thank you. 

DATA _NULL_;

file 'D:\EF/VACHLINVARMv1.TXT' Ls= 445;

   IF _N_ = 1 THEN DO;

   SET E.tatehdr;

   PUT

      @1    FILE_TYPE

      @51 TOTAL_RECORDS_IN_FILE

      @61 FILE_NAME

      @86 FILE_IDREC

      @118 FILE_RPT_PERIOD ;

END;

      SET E.slevel;    

PUT @1 RECORD_NUM @11 FIPS @13 AGNCY_NUM  @49 TABLE_NAME @69 WEA

    @119 TYPE @169 FinalWea  @184 TYPE2 @234 TOTAL_INDICATOR @435 COUNT @445 '0D'x;

RUN;

[Peter_C]

Have a look at FILE statement options
RECFM= F
with that you would probably use
LRECL= 455

[Patrick]

Your code with a few tweaks as below should return what you're after.

DATA _NULL_;
  file 'D:\EF/VACHLINVARMv1.TXT' lrecl=455 pad termstr=crlf;
  IF _N_ = 1 THEN
    DO;
      SET E.tatehdr;
      PUT
        @1    FILE_TYPE
        @51   TOTAL_RECORDS_IN_FILE
        @61   FILE_NAME
        @86   FILE_IDREC
        @118  FILE_RPT_PERIOD
        ;
    END;
  SET E.slevel;
  PUT 
    @1 RECORD_NUM 
    @11 FIPS 
    @13 AGNCY_NUM  
    @49 TABLE_NAME 
    @69 WEA
    @119 TYPE 
    @169 FinalWea  
    @184 TYPE2 
    @234 TOTAL_INDICATOR 
    @435 COUNT 
    ;
RUN;

[Tom]

Why are you writing a CR at column 455 if you don't WANT a CR at column 455?

If you want to write fixed length records then change the settings in the FILE statement.

file 'myfile' lrecl=455 ;

If you don't want any end-of-line characters then use RECFM=F instead of the default RECFM=V.

If you want to make a variable length file, but have every line padded to the full LRECL then add the PAD option.

If you want to control what  end-of-line characters written the use the TERMSTR= option of the FILE statement.  You can choose to have CRLF ( a DOS aka Windows file), LF (a Unix file) or CR (the abandoned standard of the 1980's MacOS).

[SannaSanna]

Hi. Do you mean something like this (see below)? Still did not work. My system tells me the line is incorrect as it found record length of 456 when the expected length must be 444-445.


DATA _NULL_;
file 'D:\EF/VACHLINVARMv1.TXT' pad termstr=crlf lrecl=445 ;
IF _N_ = 1 THEN
DO;
SET E.tatehdr;
PUT
@1 FILE_TYPE
@51 TOTAL_RECORDS_IN_FILE
@61 FILE_NAME
@86 FILE_IDREC
@118 FILE_RPT_PERIOD
;
END;
SET E.slevel;
PUT
@1 RECORD_NUM
@11 FIPS
@13 AGNCY_NUM
@49 TABLE_NAME
@69 WEA
@119 TYPE
@169 FinalWea
@184 TYPE2
@234 TOTAL_INDICATOR
@435 COUNT
;
RUN;

[Peter_C · Accepted solution]

SAS adds the TERMSTR (depending on platform, LF or CRLF)  to the results of PUT statements, unless you set RECFM=F 
(the default for RECFM is V).

Of course, you can use FILE statement options PAD and TERMSTR= CRLF (assuming default is still RECFM=V)


That is why you might get 446 or larger, instead of the 445.

( by adding that TERMSTR)


Avoid that problem by using RECFM=F and LRECL=445. Then the record length should be truncated to 445.


Just because the last item on the PUT statement places a 0Dx at 445 doesn't mean that is the total line width:
Beware using the implied format for variable COUNT in 
  @435 COUNT 

A default numeric format might use character width 12 which results in 446 characters before the TERMSTR is added, when RECFM=V

Also, earlier variables might be big enough to overflow that 445


Full clarity needs something like a PROC Contents report of the input dataset and the log of the session including the NOTEs following this export step

[SannaSanna]

Thank you so very much for this response.

[Tom]

Read the file back in with SAS.  The NOTEs will show you the min and max line length.

data _null_;
  infile 'D:\EF/VACHLINVARMv1.TXT' ;
  input;
run;   

If that is showing 455 then the problem is with the other software.  What software is it that is saying the lines have more than 455 characters?

Things to check.

• Does the other software expect the lines to have just LF as end-of-line marker? If so it will count the CR as one of the characters on the line.
• Does the variable COUNT have values that take more than one character to print? Such as 10 or -1 or 1.5 ?
• Do any of the character values use non 7-bit ASCII characters?  What encoding is your SAS session using?  What encoding is the target system expecting.  
  • Note it really only makes sense to use a single byte encoding when using fixed position files.

[Kurt_Bremser]

You explicitly create the CR with this:

@445 '0D'x;

0D is the carriage return.