About SASdevAnneMarie

SASdevAnneMarie

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

SASdevAnneMarie

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

SASdevAnneMarie

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 !

SASdevAnneMarie · ‎03-14-2024

Thank you, Patrick, How could I have the total value in column (not just in the last line), please ?

SASdevAnneMarie · ‎03-13-2024

Hello Experts, I would like to calculate sum (Quantity) by Id (group by Id) and the sum(Quantity) as total, but I don’t know how to do it in the same proc sql statement. Thank you for your help!

Online Status	Offline
Date Last Visited	4 weeks ago

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: Decimal in macro variable

Re: Decimal in macro variable

Re: Comparing the dates

Re: Select a right value

Re: Select a right value

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

Re: Sql summing

Sql summing

SAS Analytics Explorers