topic Re: Creating Tab dlm file. in SAS Procedures

Creating Tab dlm file.

tejeshwar — Wed, 17 Jun 2009 17:42:46 GMT

Hi,

GoodMorning!
I am trying to create a Tab dlm file using the file statement.

Currently below is the code I am using
data _null_;
set A;
file 'D:\final.txt' delimiter ='09'X ;
put acct scr ;
run;

My objective is to achieve 2 things
1) Have a header, meaning coloumn names in the first row, using the above only the data is copied.
2) I want scr to be right justified, is this possible.

Appreciate any help!

Regards,
Tejeshwar

Re: Creating Tab dlm file.

Doc_Duke — Wed, 17 Jun 2009 18:04:24 GMT

To add a header, include this line above the first put statement:

PUT 'acct'||'09'x||'scr';

I think (untested) that you can get scr to be right justified by using a $char format for it, as in

FORMAT scr $char5.;

Re: Creating Tab dlm file.

tejeshwar — Wed, 17 Jun 2009 18:24:55 GMT

Thanks.
Tried the below, SAS throwed an error.

data _null_;
set A;
file 'D:\final.txt' delimiter ='09'X ;
put 'acct'||'09'x||'scr';
put acct scr ;
run;

--
22
-----
200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname,
#, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_.

ERROR 200-322: The symbol is not recognized and will be ignored.

Also, If I just put put 'acct' in the first line, SAS is populating this btw each observation of data, something like

acct
123432133 323
acct
432233243 322

Regards

Re: Creating Tab dlm file.

Doc_Duke — Wed, 17 Jun 2009 18:35:54 GMT

try this, then.

IF _N_ =1 THEN PUT 'accr' 'scr';

The "IF _n_=1 THEN" clause will put out the row only once.

Re: Creating Tab dlm file.

sbb — Wed, 17 Jun 2009 21:18:47 GMT

The PUT statement does not call for a concatenation nor an explicit delimiter, since you have the DLM= coded on the FILE statement. And you will want to review the DSD option on the FILE statement.

Also, if you have no data for the input file, you will have no header row, either. You will want to code the header row PUT statement ahead of the SET statement to ensure at least a header row is generated.

Scott Barry
SBBWorks, Inc.

Re: Creating Tab dlm file.

tejeshwar — Thu, 18 Jun 2009 02:42:26 GMT

Thanks Scott.
I managed to write the below code and it accomplishes one of the objectives to get the header for this file but I still cant get Nw_L to right-justify in the output file

data _null_;
set WORK.AB end=EFIEOD;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
%let _EFIREC_ = 0; /* clear export record count macro variable */
file 'D:\ab.txt' delimiter='09'x DSD DROPOVER
lrecl=32767;
format ACCT $20. ;
format AB_ID $10. ;
format CY_CD best12. ;
format Nw_L $7. ;
format Type $1.;
if _n_ = 1 then /* write column names */
do;
put
'ACCT'
'09'x
'AB_ID'
'09'x
'CY_CD'
'09'x
'Nw_L'
'09'x
'Type'

;
end;
do;
EFIOUT + 1;
put ACCT $ @;
put AB_ID $ @;
put CY_CD @;
put Nw_L @;
put Type $ ;

;
end;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
if EFIEOD then call symputx('_EFIREC_',EFIOUT);
run;

Any thoughts as to if/how we can accomplish that?

Regards,
Tejeshwar

Message was edited by: tejeshwar Message was edited by: tejeshwar

Re: Creating Tab dlm file.

DanielSantos — Thu, 18 Jun 2009 11:43:56 GMT

You should override the default alignment for the put statement (in your case -R option).

put -;

for example: put X $10 -R; /* x right aligned in a 10 char space */

Please, check online documentation here:
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000175758.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Creating Tab dlm file.

tejeshwar — Thu, 18 Jun 2009 12:15:58 GMT

Thanks Daniel,

This actually works in terms of right-justify but gives me some problem with the attribute after that attribute
ex: if the data was
acct scr type
123432 234 B
323246 36 C

Now after right justifying scr, it becomes like
acct scr type
123432 234B
323246 36C

It seems its not able to create a tab dlm between the attribute which is right justify and the next value
Any suggestions?

Message was edited by: tejeshwar Message was edited by: tejeshwar