topic Decimal in macro variable in SAS Programming

Decimal in macro variable

SASdevAnneMarie — Mon, 15 Apr 2024 08:57:35 GMT

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 !

Re: Decimal in macro variable

sbxkoenk — Mon, 15 Apr 2024 09:18:44 GMT

I think you don't have any decimals (the sum is an integer).

Anyway,

if you absolutely want decimals

, here's one way to get them.

proc sql noprint;
            select put(avg(Weight),comma14.7) 
            into :Montant_EU trimmed 
            from sashelp.class;
quit;

%PUT &=Montant_EU;

Koen

Re: Decimal in macro variable

SASdevAnneMarie — Mon, 15 Apr 2024 10:36:51 GMT

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

Re: Decimal in macro variable

PaigeMiller — Mon, 15 Apr 2024 10:49:19 GMT

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

What about this doesn't work?

Re: Decimal in macro variable

sbxkoenk — Mon, 15 Apr 2024 10:57:16 GMT

You could use "sysevalf" :

proc sql noprint;
            select put(avg(Weight),comma14.7) 
            into :Montant_EU trimmed 
            from sashelp.class;
quit;

%PUT &=Montant_EU;

%LET tx=%sysevalf(&Montant_EU.+1);
%PUT &=tx;

Koen

Re: Decimal in macro variable

Kurt_Bremser — Mon, 15 Apr 2024 11:04:37 GMT

%EVAL is for integer evaluations, for floating point you need %SYSEVALF.

Re: Decimal in macro variable

SASdevAnneMarie — Mon, 15 Apr 2024 11:43:49 GMT

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

Re: Decimal in macro variable

sbxkoenk — Mon, 15 Apr 2024 12:06:39 GMT

Can you copy / paste the full code (as part of the full log)?

Copy in EGuide
Then use the </> icon in the header
Then paste in the pop-up window.
(Avoid screenshots here)

Thanks,
Koen

Re: Decimal in macro variable

Quentin — Mon, 15 Apr 2024 12:54:53 GMT

That looks like an un-related problem. It looks like at some point in the SAS session, you may have submitted a block of code with unmatched quotation marks. If you get this problem repeatedly, the easiest thing is to exit EG and then restart, and then search your code for unmatched quotation marks.

Re: Decimal in macro variable

Tom — Mon, 15 Apr 2024 13:09:54 GMT

@Quentin wrote:

That looks like an un-related problem. It looks like at some point in the SAS session, you may have submitted a block of code with unmatched quotation marks. If you get this problem repeatedly, the easiest thing is to exit EG and then restart, and then search your code for unmatched quotation marks.

No need to exit Enterprise Guide. Just restart the SAS session that Enterprise Guide is using to run the SAS code.

Re: Decimal in macro variable

Quentin — Mon, 15 Apr 2024 13:48:50 GMT

@Tom wrote:

@Quentin wrote:

That looks like an un-related problem. It looks like at some point in the SAS session, you may have submitted a block of code with unmatched quotation marks. If you get this problem repeatedly, the easiest thing is to exit EG and then restart, and then search your code for unmatched quotation marks.

No need to exit Enterprise Guide. Just restart the SAS session that Enterprise Guide is using to run the SAS code.

But is there an easy way to restart the session? The best way I have found is to right-click the server and select disconnect, then right-click again and select connect. I would love it if there was a "restart session" button / menu item I could refer folks to.

Re: Decimal in macro variable

Tom — Mon, 15 Apr 2024 14:21:13 GMT

Disconnect/select sounds the same as restart, just in two steps instead of one. Still better than leaving the application completely and having to restart the application.