About SASdevAnneMarie

SASdevAnneMarie · ‎06-10-2024

Thank you! If CSV is larger than Excel I need to open the CSV with Notepad ?

SASdevAnneMarie · ‎06-10-2024

Hello Experts, My data is to big for Excel exports : 261 520 Ko. I'll export the file on csv. Do you know, please, the max of Ko that I can export on csv and excel via sas? Thank you !

SASdevAnneMarie · ‎04-15-2024

This code doesn't work on my EG, I have this erros :

SASdevAnneMarie · ‎04-15-2024

Thank you! Why %eval function doesn't work for this macro variable : %let tx=%eval(&Montant_EU+1) ?

SASdevAnneMarie · ‎04-15-2024

Hello Experts, I'm wondering how to get the decimal after the sum statement, the decimal doesn't appear in my macro variable Montant_EU. My code is : proc sql noprint; select sum("Montant EU "n) into : Montant_EU from base_finale; quit; Thank you for your help !

SASdevAnneMarie · ‎04-07-2024

Thank you Quentin.

SASdevAnneMarie · ‎04-05-2024

Hello Experts, I'm wondering why this data comparing doesn't work (I have also the date> 01/04/2024 in base finale) data base_finale; set base2; if month("Date de réception"n)<="01APR2024"d; run; The format of coulmn is "Date de réception"n Thank you !

SASdevAnneMarie · ‎04-04-2024

Thank you very much !

SASdevAnneMarie · ‎04-04-2024

Thank you ! That works ! Do you know please how to add the condition and in this expression, like "/\b2,25|\b2\.25|\b1,75|\b1\.75/ and 'RATE'".

SASdevAnneMarie · ‎04-04-2024

Hello Experts, With prxmath function I would like to select only the values 2,25 or 2.25, 1.75 or 1,75. So, in my code I have : if prxmatch("m/2,25|2.25|1,75|1.75/oi",lb)>0 , but I don't know why this doesn't work, beacause I have in my selection 2.50. Thank your for your help !

SASdevAnneMarie · ‎03-29-2024

Thank you, Tom ! So I can't do any modification in code, it is Excel settings ?

SASdevAnneMarie · ‎03-28-2024

Yes, my Excel setting is point. I’m creating the xlsx files with points. I’m asking if it is possible to create the file with comma without changing the settings.

SASdevAnneMarie · ‎03-28-2024

Thank you, Tom! Do you know, please the option for comma in ods excel?

SASdevAnneMarie · ‎03-28-2024

Thank you for your answer, Tom. Yes, I would like to have 1,25 instead 1.25. The file is created via proc export.

SASdevAnneMarie · ‎03-28-2024

Hello Experts, I joined the xlsx file to ma e-mail via excel with options ATTACH= ("XXX.xlsx" content_type="application/xlsx") Do you know please how to change the point on comma in digits without changing the parameteres of my PC ? There is some sas options ? Thank you for your help !

Online Status	Offline
Date Last Visited	‎09-16-2024 06:49 PM

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: Exports file

Exports file

Re: Decimal in macro variable

Re: Decimal in macro variable

Decimal in macro variable

Re: Comparing the dates

Comparing the dates

Re: Select a right value

Re: Select a right value

Select a right value

Re: Change the format of digits in Excel file

Re: Change the format of digits in Excel file

Re: Change the format of digits in Excel file

Re: Change the format of digits in Excel file

Change the format of digits in Excel file

SAS Analytics Explorers