About SASdevAnneMarie

SASdevAnneMarie · ‎07-20-2020

It doesn't work 😞

SASdevAnneMarie · ‎07-20-2020

Thank you for your suggestion. I'm receiving this file, I need to correct it automatically, not manually.

SASdevAnneMarie · ‎07-20-2020

The data is attached. Thank you

SASdevAnneMarie · ‎07-20-2020

Hello, In my data file csv have a lote of "â€™", I need to replace it just by " ' ". I import my row data file with infile statement (infile "&Rep_Travail\xxxx.csv" dsd truncover lrecl=32767 encoding=wlatin2) and I get the table donne.sas When I run the code: data donnee_bis; set donne; var3_correct=tranwrd(var3,"â€™","'"); run; I get the error that SAS "Failed to transcode data from U_UTF8_CE to LATIN_9_CE......." I put already the options locale=FR before the infile. Maybe I need to change encoding option in infile statement? Thank you for your help!

SASdevAnneMarie · ‎07-11-2020

Thank you very much Tom! Yes, some application add the quote to my CSV file.

SASdevAnneMarie · ‎07-11-2020

Thank you Tom! Unfortunately I can’t have the data in xlsx format. 😞

SASdevAnneMarie · ‎07-11-2020

Hello! Do you know some options to import this csv file with Libname XLSX? Thank you!

SASdevAnneMarie · ‎07-10-2020

Thank you Tom! I can't have the data, I must use this file 😞

SASdevAnneMarie · ‎07-10-2020

The data is attached. Thank you

SASdevAnneMarie · ‎07-10-2020

Hello, I need to import the csv file, my second variable (start and end in yellow) has a line break : I use the option: dlm='","'||',"'; infile "XXX\tweet_archives_fr.csv" delimiter=dlm missover lrecl=250 firstobs=2 ; With this options my second variable is truncated. Do you know please the option to read correctly this variable ? Thank you! Best regards, Marie

SASdevAnneMarie · ‎07-08-2020

Thank you very much!

SASdevAnneMarie · ‎07-08-2020

Which is the best way in your opinion to get the number of observations please in this case? Thank you for your help!

SASdevAnneMarie · ‎07-08-2020

Thank you! That works!

SASdevAnneMarie · ‎07-08-2020

Thank you Richard! I'm trying to do that for "real" code but I still have the same error: NOTE: Line generated by the macro variable "PROFILE_NAME". 919 "Profilée Non "Sécuritaire" ____________________________________________________ 49 388 202 ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored.

SASdevAnneMarie · ‎07-08-2020

Hello Richard, It is just a short example, for understanding the probleme. It is NOT a real code, I need the quotation mark beacause I code the ods object report. Thank you!

Online Status	Offline
Date Last Visited	3 weeks ago

Box plot option

Re: Deactivate the sas guide message

Deactivate the sas guide message

Re: Scheduling SAS program with Windows

Re: Scheduling SAS program with Windows

Scheduling SAS program with Windows

Re: Sheduling the task

Re: Sheduling the task

Re: Sheduling the task

Sheduling the task

Re: Box plot option

Re: Deactivate the sas guide message

Re: Scheduling SAS program with Windows

Re: Scheduling SAS program with Windows

Re: Sheduling the task

Re: Spaces in proc odstext

Creating the macro variables with incrementing suffix

Re: Odsout obj() : font Arial

Re: Numeric variable to chracter with a space

Proc odstext with proc tabulate

Re: Transcoding of texte

Re: Transcoding of texte

Re: Transcoding of texte

Transcoding of texte

Re: Import the varaible with a line break

Re: Import the varaible with a line break

Re: Import the varaible with a line break

Re: Import the varaible with a line break

Re: Import the varaible with a line break

Import the varaible with a line break

Re: Quotation mark in quoted macro variable

Re: Quotation mark in quoted macro variable

Re: Quotation mark in quoted macro variable

Re: Quotation mark in quoted macro variable

Re: Quotation mark in quoted macro variable

SAS Analytics Explorers