About arnouxvr

arnouxvr · ‎03-09-2021

I am currently calling an Excel Macro from withing SAS which works perfectly using DDE commands. *execute the excel marco; put "[run(""&excelMarcoName."")]"; The Excel macro opens another excel file and saves it in a different location. ActiveWorkbook.SaveAs Filename:= _ "C:\Users\testuser\src\reports\new_excel_file.xlsx" Currently, the path of the file is hardcoded in the Excel Macro. When calling the Excel Macro is it possible to include a parameter or additional argument that will contain the location of the directory into which the file should save? That parameter would then be used inside the Excel Marco to determine where to save the new file. https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/154-31.pdf Many thanks,

arnouxvr · ‎06-06-2017

I have been struggling with an issue. Looking at the code below: %put %scan(%str(arg1=A,arg2=B,arg3=C),1); %let string = arg1=A,arg2=B,arg3=C; %put %scan(%str(&string),1); The first %put statement writes arg1=A in the log as expected. The second %put statement gives a warning. WARNING: Argument 2 to macro function %SCAN is out of range. My question is: How do I force the %put statement to first resolve the macro variable &string to arg1=A,arg2=B,arg3=C and then execute the %put statement?

arnouxvr · ‎06-06-2017

This is actually a limitation of Visual Analytics at this stage, as according to the documentation, a custom sort does not work if the data item is assigned to one of the legend data roles (either Colour or Group). The same restriction applies when sorting on the raw values of a data item that has a user-defined format. Creating a user-defined format is a possible workaround. Instead of having your Risk Rating - Raw column having values such as AA, A, B1 etc. you would have the column as a number format (1, 2, 3), then add a user-defined format to invoke the Risk Ratings (example, 1 = ""AA"", 2 = ""A"", 3 = ""B1"" etc.)

arnouxvr · ‎02-07-2017

I have a variable that I changed to have a custom sort. When assigning the variable to a role of an object it sorts according to the custom sort which is correct. However, when I create a new Hierarchy with the custom sort variable described above as the first level the new Hierarchy variable does not sort according to the what was set with the custom sort.

arnouxvr · ‎02-07-2017

Thank you, Tom. The solution works. I just wonder why it would fail when using a date constant or numeric variable. Explanation on SAS inner workings with %sysevalf: Using the macro function the macro processor will first run and execute the macro code. The macro processor will convert the following code: if curr_date in (%sysevalf('01FEB2017'd) : %sysevalf('28FEB2017'd)) then do; to if curr_date in (20851 : 20878) then do; and then the compiler can run the code as if it was numeric.

arnouxvr · ‎02-07-2017

I am trying to use date constants in a numeric range. Example: data t; input date; format date ddmmyy10.; datalines; 0 1 2 3 4 5 6 7 ; run; proc print data=work.t; *where date in (3:6); where date in ('04JAN1960'd : '07JAN1960'd); run; The first where clause uses the numeric date and the programs execute without errors. The second where clause uses the date constant and will generate an error. The documentation specifies that the N and M should be numeric. My question is why would it fail with a date constant or even a variable that is numeric when using the range feature with the IN operator. http://support.sas.com/documentation/cdl/en/lrcon/69852/HTML/default/viewer.htm#p00iah2thp63bmn1lt20esag14lh.htm M, N, and all the integers

arnouxvr · ‎05-11-2015

Thanks KurtBremser, It looks like it is working when I create two data steps in order to "delay" execution I can see that the timestamp per millisecond is different. data time1; date1 = datetime(); run; data time2; date1 = datetime(); run; data time; set time1 time2; format date: datetime23.3; run; proc print; run;

arnouxvr · ‎05-11-2015

I just want to make sure about the following: data timestamp; date1 = date(); date2 = datetime(); run; date1 contains the number of days from 1 JAN 1960 and date2 contains the number of seconds from midnight 1 JAN 1960. How do I create a variable date3 that contains the number of milliseconds from 1 JAN 1960?

arnouxvr · ‎05-11-2015

Is it possible to store a timestamp on a SAS Dataset date column that will contain milliseconds as well?

arnouxvr · ‎03-26-2015

Thanks Jennifer hopefully in the new releases.

arnouxvr · ‎03-26-2015

How do I change the autocomplete background color in Enterprise Guide. When I type code and the autocomplete comes up it is hard to see what is selected. There is an option SAS Color Format under Tools -> SAS Programs -> Editor Options -> AutoComplete Thanks in Advance.

arnouxvr · ‎09-05-2014

In Enterprise Guide I can set the settings specific to Enterprise Guide when I go to TOOLS>OPTIONS. I would like to know the following: The values of the options is it stored in a specific folder or data set that I can locate. The reason for my request is that when I am working on my computer I have specific settings for myself like the font of the editor and opening a data set by default. When I go help another person I would like to load my configuration settings without having to go to TOOLS>OPTIONS and setting one by one. Thanks in advance.

arnouxvr · ‎08-07-2013

Explanation is as follows: The line of code call symput ("start_mon", &mth+1 + 88*(substr("&mth.",5,2) = "12")); is saying the following if (substr("&mth.",5,2) = "12") then call symput ("another_start_mon", &mth + 1 + 88); else call symput ("another_start_mon", &mth+1); how the shorten line of codes works as follows: SAS evaluates quantities inside parentheses before performing any operations. Let’s call the macro with the following value %cohort1(200512). SAS will first evaluate the parentheses (substr("&mth.",5,2) = "12")) in this case &mth is 12 so the value inside the parameter would be true or 1. So the expression is actually &mth+1 + 88*(1). &mth will the evaluate &mth plus 1 plus (88 * 1) Let’s call the macro with the following value %cohort1(200601) in this case &mth is not 12 so the value inside the parameter would be false or 0. So the expression is actually &mth+1 + 88*(0). &mth will the evaluate &mth plus 1 plus (88 * 0) Fruther reading: http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000780367.htm#a000781136 see Numeric Comparisons

arnouxvr · ‎08-02-2013

Try the following: proc sql noprint; create table chart as select *,monotonic() as id from ( select distinct var2,count(var2) as count from ( select distinct var1,var2 from report) group by var2) where id<5 order by count; quit; I moved the order by count right after the where statement. Just make sure the where selection will work with your ID column.

arnouxvr · ‎08-02-2013

I would just like to see the structure of your dataset. Please run one of the following sets of code: proc sql; describe table report; quit; or proc contents data=report; run; and share the structure of the dataset.

Online Status	Offline
Date Last Visited	‎03-15-2021 04:38 AM

DDE Calling Excel Macro with additional Parameters

Resolve Macro Variable which is argument of a Macro Function

Re: VA Hierarchy and Custom Sort Field

VA Hierarchy and Custom Sort Field

Re: Using a Date Constant with a IN Operator

Using a Date Constant with a IN Operator

Re: Store Date Milliseconds

Re: Store Date Milliseconds

Store Date Milliseconds

Re: Autocomplete Background Color

Re: Autocomplete Background Color

Re: How to align the Title as Left and right?

Re: Creating a ddccmmyy macro

Re: How to align the Title as Left and right?

Re: Explanation if statement in arithmetic calculation

DDE Calling Excel Macro with additional Parameters

Resolve Macro Variable which is argument of a Macro Function

Re: VA Hierarchy and Custom Sort Field

VA Hierarchy and Custom Sort Field

Re: Using a Date Constant with a IN Operator

Using a Date Constant with a IN Operator

Re: Store Date Milliseconds

Re: Store Date Milliseconds

Store Date Milliseconds

Re: Autocomplete Background Color

Autocomplete Background Color

Enterprise Guide Configuration Settings

Re: Explanation if statement in arithmetic calculation

Re: PROC SQL: Why wont this code work

Re: PROC SQL: Why wont this code work