topic Re: output file in SAS Procedures

output file

Tal — Fri, 19 Sep 2014 13:45:20 GMT

hi guys,

i am supposed to write these four var to an output file and my id must be a char variable starting from position 111 ending position 125

but they get left justified ,probably cuz they are numeric . is there a way i can move them to start from position 111 without beeing converted to char var?

put @001 fname 25.

@026 lname 25.

@051 email 60.

@111 id 15.

Re: output file

CTorres — Fri, 19 Sep 2014 13:51:24 GMT

Try this:

put @001 fname $25.

@026 lname $25.

@051 email $60.

@111 id Z15. ;

Re: output file

rcwright — Fri, 19 Sep 2014 14:04:44 GMT

Try 25.-L as format (-L left aligns, -C Centers, -R right aligns)

Re: output file

Tal — Fri, 19 Sep 2014 14:29:41 GMT

sorry i dont understand what you mean

Re: output file

rcwright — Fri, 19 Sep 2014 14:38:28 GMT

PUT @1 fname

...

@111 id 15.-L

;

sorry about the 25. - I thought id was the first variable

In your question you state id gets left aligned, but I'm assuming you misstated that - I think you meant right aligned.

This will left align id starting at column 111.

If you wanted to center the value, use -C, if you want to right align(default for numeric variables), use -R

Look in online manual under PUT formatted for explanation and other examples.

Re: output file

Tal — Sat, 20 Sep 2014 02:52:03 GMT

yes i meant right aligned,sorry

but see,i did not know about this L,R and C. Very handy.

Thanks a lot!

Re: output file

RCW — Sat, 20 Sep 2014 16:15:46 GMT

Ahh ... but I did - that's what makes these communities so handy. Learn something new every day. And I've been doing this about 30 years.