topic Re: Export txt in SAS Enterprise Guide

Export txt

egamorim — Tue, 18 Jul 2017 18:53:22 GMT

When I export a file in txt, at the beginning and end of each line appears "(quotes) how do I prevent this from happening?

Re: Export txt

ChrisHemedinger — Tue, 18 Jul 2017 18:58:42 GMT

How are you exporting this? Using EG menus or code? Try File->Export->Export [DATANAME], and select a CSV type.

Re: Export txt

Reeza — Tue, 18 Jul 2017 18:59:20 GMT

Post the code you're using.

Re: Export txt

egamorim — Tue, 18 Jul 2017 20:28:51 GMT

Não estou exportando através de código.
Com a tabela aberta estou indo em Export >> Export Step in Project
Seleciono o formato, no caso txt e fim.

Quando faço esse procedimento ele está colocando aspas no início e no fim de cada linha.

Re: Export txt

egamorim — Tue, 18 Jul 2017 20:30:41 GMT

I am not exporting through code.
With the table open I'm going to Export >> Export Step in Project
I select the format, in case txt and end.

When I do this procedure it is putting quotation marks at the beginning and end of each line.

Re: Export txt

egamorim — Tue, 18 Jul 2017 20:31:56 GMT

I need to export in txt
With the table open I'm going to Export >> Export Step in Project
I select the format, in case txt and end.

When I do this procedure it is putting quotation marks at the beginning and end of each line.

Re: Export txt

CaseySmith — Tue, 18 Jul 2017 20:47:29 GMT

What version of EG (listed in Help->About) are you using? In newer versions of EG, only values that contain the delimiter will be wrapped in quotes when exported to text (to avoid the ambiguity).

Re: Export txt

egamorim — Tue, 18 Jul 2017 20:53:55 GMT

version 5.1

Re: Export txt

Kurt_Bremser — Wed, 19 Jul 2017 06:19:52 GMT

@egamorim wrote:

I am not exporting through code.
With the table open I'm going to Export >> Export Step in Project
I select the format, in case txt and end.

When I do this procedure it is putting quotation marks at the beginning and end of each line.

There is ALWAYS code in SAS. EG is just a code generator, and as soon as a node is run, you get a tab with the code that was sent to the workspace server.

To be able to recreate your situation, we need

- that code I mentioned (to make sure that our actions in EG generate the same code)

- your dataset that you exported. Use the macro provided in https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 to convert your dataset to a data step, and post that here in a code window (6th or 7th icon above the posting window).

Re: Export txt

ChrisHemedinger — Wed, 19 Jul 2017 11:51:14 GMT

Actually, as much as I hate to correct my friend @Kurt_Bremser, there is no SAS code for this step initated from "Export as a Step". EG reads the data and uses local routines to generate a text file. As Casey said, earlier versions of EG added unnecessary quotes -- this is corrected in EG 7.1.

You can, however, use SAS code to achieve what you need. PROC EXPORT, ODS CSV, and simple DATA step can all be used to generate text files from data. Your challenge would then be to copy that data file from your SAS server to your local PC, and that's what the Copy Files task is good for. Here's a blog post that leads you through the steps.

Re: Export txt

egamorim — Wed, 19 Jul 2017 12:38:13 GMT

Yes, as mentioned by ChrisHemedinger, there is no code for the way I am doing it.

My table contains only 1 column called Mailing in text format.

Could you code in code how can I export this table into text format?

Re: Export txt

Kurt_Bremser — Wed, 19 Jul 2017 12:47:42 GMT

@egamorim wrote:

Yes, as mentioned by ChrisHemedinger, there is no code for the way I am doing it.

My table contains only 1 column called Mailing in text format.

Could you code in code how can I export this table into text format?

That's simple:

data have;
input email :$100.;
cards;
user.user@domain.com
another_user@some-domain.com
;
run;

data _null_;
file '$HOME/test.txt';
set have;
put email;
run;

The file test.txt looks like that:

user.user@domain.com
another_user@some-domain.com

As you can see, no quotes.

Re: Export txt

egamorim — Wed, 19 Jul 2017 13:53:11 GMT

Okay, but it still did not work out.

I am illustrating in the attached image.

Notice that in EG the quotes do not appear, but in the yes txt.

Re: Export txt

Kurt_Bremser — Wed, 19 Jul 2017 14:04:17 GMT

You are using the export task from EG instead of the code I gave you. Don't be surprised.

Re: Export txt

egamorim — Wed, 19 Jul 2017 14:17:08 GMT

Can I export txt to my local machine?
On my desktop?

Re: Export txt

ChrisHemedinger — Wed, 19 Jul 2017 14:20:54 GMT

Hi @egamorim - the way to do this is by using a SAS program node with code like @Kurt_Bremser provided, and then a Copy Files step. In EG 5.1 you will need to add Copy Files to your environment; it's not built in.

Those steps are all shown by example in this blog post. I understand that English is not your primary language so I can appreciate that you have to interpret the steps. See if you can follow the steps in the blog article though, and report back.

Re: Export txt

egamorim — Wed, 19 Jul 2017 15:50:32 GMT

@ChrisHemedinger really English is not my primary language.
Let us therefore communicate through my language.

A configuração deste processo de exportação deu certo, porém, o export em csv permanece com o mesmo problema.

Com aspas no inicio e no final de cada linha.

Re: Export txt

ChrisHemedinger — Wed, 19 Jul 2017 15:57:47 GMT

@egamorim - you might find a quicker resolution by working with SAS Tech Support in Brazil..

Você pode encontrar uma resolução mais rápida trabalhando com o SAS Tech Support no Brasil:

http://www.sas.com/offices/latinamerica/brazil/suporte/contato.html

Re: Export txt

egamorim — Wed, 19 Jul 2017 16:02:32 GMT

Ok, vou contatá-los, obrigado.

Re: Export txt

CaseySmith — Thu, 20 Jul 2017 17:43:14 GMT

Ok, from the screenshot I can tell what is going on... it is as I alluded to in earlier post...

The values in your column contain your default delimiter, which is the semi-colon given your locale settings. When you export as "Text Files (*.txt)", the values are separated by your default list separator (aka. delimiter). Any values that contain your delimiter character are wrapped in quotes (so they aren't ambiguous with the delimiters).

So, if you do not want your values quoted, export to a text format that uses delimiters which are not contained in your values. For example, in this case (where your values contain semi-colons and semi-colon is the default list separator in your locale) export to space-delimited or tab-delimited text file instead.

Casey