BookmarkSubscribeRSS Feed
ChrisHemedinger
Community Manager

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.

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
egamorim
Calcite | Level 5

@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.

ChrisHemedinger
Community Manager

@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

 

 

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
egamorim
Calcite | Level 5

Ok, vou contatá-los, obrigado.

CaseySmith
SAS Employee

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


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 19 replies
  • 4955 views
  • 3 likes
  • 5 in conversation