topic Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini in SAS Enterprise Guide

Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

loky — Tue, 06 Aug 2013 09:28:33 GMT

Hi all,

I'm doing a query between two sequential files that i've imported in sas using "sas enterprise guide".

The result is a new dataset that i must export in a sequential txt fixed lenght.

I've used the file schema.ini to defined the type and the lenght of all the fileds.

I'm not able to put numeric fileds right aligned.

I've used only three process: import, query and export.

Any help please ?

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

TomKari — Tue, 06 Aug 2013 14:02:46 GMT

Hi, Loky

Here's a workaround you can use, by converting your numbers to right-aligned character fields BEFORE exporting them.

Start a new query on your file, and add all of the fields EXCEPT your numbers to the "Select Data" pane.

Now, for each number that you want right aligned:

Create a new advanced expression;

In the advanced expression, enter

right(put(xxxxx, 5.))

where xxxxx is your variable name, and 5 is the number of characters you want the field to occupy.

Finish defining the advanced expression, and when you run the query you should have a correctly defined character field, that you can export.

Tom

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

ChrisHemedinger — Tue, 06 Aug 2013 14:07:02 GMT

If you're willing to write a little bit of code, you will find that you have more flexibility in creating a flat file in the exact format that you need using DATA step.

Then you can automate the "transfer" of that file from SAS to your local PC using this technique:

Export and download any file from SAS Enterprise Guide - The SAS Dummy

Chris

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

loky — Wed, 07 Aug 2013 09:02:18 GMT

Hi TomKari, you have open me a world.

I've modified your advanced expression to right aligned and to replace space with zero.

translate(right(put(nameofthefield, numberofcharacter.)),"0"," ")

Thanks a lot.

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

loky — Wed, 07 Aug 2013 09:05:47 GMT

Hi Chris, thanks for your answer.

I prefer don't write code but I'll study your suggestion.

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

TomKari — Sat, 10 Aug 2013 00:53:11 GMT

Hey, Loky

Glad I could help. Functions and formats in SAS are amazing!

Instead of

translate(right(put(xxxxx, 5.)),"0"," ")

try

put(nameofthefield, z5.)

The zn. format in SAS automatically zero-fills the number.

Best,

Tom

Re: Right aligned numeric fields doing export on TXT fixed lenght using schema.ini

Tom — Sat, 10 Aug 2013 15:00:40 GMT

The RIGHT() function is not doing anything in that expression. PUT() always places the number on the right of the string.