topic Specify carriage return in specific position in SAS Procedures

Specify carriage return in specific position

SannaSanna — Tue, 11 Dec 2012 19:21:57 GMT

Hello-

I have the following code and need to place a carriage return at a specific position in a text file. The start position of the carriage return/CRLF must be at 325. Can anyone help me?

DATA _NULL_;

file 'I:\ENCTv1.TXT' LRECL= 325;

IF _N_ = 1 THEN DO;

SET LEVEL_HDR;

PUT

@1 FILE_TYPE

@51 TOTAL_RECORDS_IN_FILE

@61 FILE_NAME

@86 FILE_ID

@118 FILE_RPT_PERIOD;

END;

SET LEVEL_body;

PUT @1 RECORD_NUM @11 ZIP @13 AGG_NUM @15 AGG_ID @49 TABLE_NAME @69 GRADE

@84 RESI @114 TOTAL_INDICATOR @315 COUNT;

RUN;

Re: Specify carriage return in specific position

data_null__ — Tue, 11 Dec 2012 20:09:53 GMT

Add the FILE statement option PAD.

data _null_; 
   file '~/exp.txt' dsd pad lrecl=75; 
   set sashelp.class;
   put (_all_)(=);
   run; 
data _null_; 
   infile '~/exp.txt'; 
   input; 
   list; 
   run;

Re: Specify carriage return in specific position

Haikuo — Tue, 11 Dec 2012 20:10:39 GMT

DATA _NULL_;

file 'I:\ENCTv1.TXT' LRECL= 325;

IF _N_ = 1 THEN DO;

SET LEVEL_HDR;

PUT

@1 FILE_TYPE

@51 TOTAL_RECORDS_IN_FILE

@61 FILE_NAME

@86 FILE_ID

@118 FILE_RPT_PERIOD;

END;

SET LEVEL_body;

PUT @1 RECORD_NUM @11 ZIP @13 AGG_NUM @15 AGG_ID @49 TABLE_NAME @69 GRADE

@84 RESI @114 TOTAL_INDICATOR @315 COUNT @325 '0D'x;

RUN;

Haikuo

Re: Specify carriage return in specific position

Haikuo — Tue, 11 Dec 2012 20:11:48 GMT

Liked!

Re: Specify carriage return in specific position

SannaSanna — Tue, 11 Dec 2012 20:19:40 GMT

Awesome! Placed the carriage return at 325- but now I have a blank row record after every data record??

Re: Specify carriage return in specific position

Ksharp — Wed, 12 Dec 2012 01:15:23 GMT

Why not use :

file '~/exp.txt' dsd pad lrecl=75 termstr=CRLF;