So it should work in the following way: Name: <select name_of_report from my_table where accounting_period="&parameter"> User: <select user_name from my_table where accounting_period="&parameter"> Date: <select date from my_table where accounting_period="&parameter"> ... View more

Hi @Stu_SAS! Thanks for the info 🙂 In general I don't want to calculate data dynamicaly (like date of report), but instead of that I would like to use data from a database table. The flow is that I am running job that recalculates data that should be visible in headline, then I am loading it into Viya and I would like to present the values in the headline of report. Any further help will be appreciated 🙂 Thanks! Filip ... View more

 Hi, I am using version 8.5.1 (SAS Viya V.03.05).    Cheers,  Filip ... View more

Hi @MarkusWeick, Cool, thanks for the info - I will post third and fourth questions in a separate topics 🙂 Best, Filip ... View more

Hi again @MarkusWeick, That's really nice option! But unfortunately I don't have such (I have version 8.5.1), but maybe it is somewhere else - I will take a look 🙂 ... View more

Hi @MarkusWeick, Thanks! Maybe that would be sufficient for my customer 😉 Best, Filip ... View more

Hi Markus, Thanks a lot - it works great! 🙂 ... View more

 Hi guys,   The real example is that I have ca. 15 columns with numerical value. Then, I need to find the minimal one, I am doing it using arrays: lowest_value = min(of columns[*]); index_lowest_value = whichn(lowest_value, of columns[*]); column_lowest_value = vname(columns[index_lowest_value]);   Then I need to implement some logic for columns other that column_lowest_value (using some loops and so on), so I try run the macro with column_lowest_value as a parameter - something like that:   call symput('lowest', column_lowest_value, 'g'); %do_sth(&lowest.); /* or: */ call execute('%do_sth('||lowest||');'); The problem is that I need to do that dynamically, during processing. I am thinking about some workaround, but no idea so far 😞 ... View more

Hmm, that's a bad news 😞 The code that I placed is just an example - I mean in "real" life I have much more complicated code, but the idea is exactly as in my example.   So my question is: is it possible in SAS to dynamically (I mean observation by observation) run macro with a column value as a parameter and based on that manipulate other column(s)? From my current knowledge it looks that no matter what you use (call symput, call execute), it runs after the datastep is completed, so there is no solution to my problem...    Thanks in advance!   ... View more

 Hi Paige and Quentin,   Many thanks for your reply!   In general, I am trying trying to do quite "easy" thing: during processing the dataset take the value from one particular column -> run macro with value of that column as a parameter -> macro should modify other column (based on some conditions).   But step by step: This is a sample code that you can run: options mprint; /* create input dataset */ data a; infile datalines; input name $ value1 value2 value3; datalines; test1 10 1 0 test2 20 22 0 test3 30 3 0 run; /* re-calculate value3 - set to missing or multiply value2 (passed by parameter in below datastep) by 2 */ %macro do_sth(var); if value1 < var then do; value3 = .; end; else do; value3 = var * 2; end; %mend; /* create new dataset with new value3 column */ data b; set a; call execute('%do_sth('!!value2!!');'); run; This is a piece of log after invoking data b: 28 data b; 29 set a; 30 call execute('%do_sth('!!value2!!');'); 31 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 30:27 MPRINT(DO_STH): if value1 < var then do; MPRINT(DO_STH): value3 = .; MPRINT(DO_STH): end; MPRINT(DO_STH): else do; MPRINT(DO_STH): value3 = var * 2; MPRINT(DO_STH): end; MPRINT(DO_STH): if value1 < var then do; MPRINT(DO_STH): value3 = .; MPRINT(DO_STH): end; MPRINT(DO_STH): else do; MPRINT(DO_STH): value3 = var * 2; 2 The SAS System 15:43 Tuesday, July 19, 2022 MPRINT(DO_STH): end; MPRINT(DO_STH): if value1 < var then do; MPRINT(DO_STH): value3 = .; MPRINT(DO_STH): end; MPRINT(DO_STH): else do; MPRINT(DO_STH): value3 = var * 2; MPRINT(DO_STH): end; NOTE: There were 3 observations read from the data set WORK.A. NOTE: The data set WORK.B has 3 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 671.25k OS Memory 27496.00k Timestamp 07/19/2022 11:36:05 PM Step Count 37558 Switch Count 2 NOTE: CALL EXECUTE generated line. NOTE: Line generated by the CALL EXECUTE routine. 1 + if value1 < var then do; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the CALL EXECUTE routine. 1 + value3 = .; ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the CALL EXECUTE routine. 1 + end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the CALL EXECUTE routine. 1 + else do; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the CALL EXECUTE routine. 1 + value3 = var * 2; ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the CALL EXECUTE routine. 1 + end; ___ 3 The SAS System 15:43 Tuesday, July 19, 2022 180  and so on...   If you need any further clarification, just let me know.    Thanks!!!  Filip       ... View more

 Hi again,   I just realized that I should use call execute routine in the following way: data test; set some_data_set; call execute('%some_macro('||VALUE||');'); run; But here comes another problem. Let's assume that macro %some_macro does some modifications, comparisons and so on (based on columns from some_data_set), so it looks something like this: %macro some_macro(); if column_1 > column_2 then do; column_3 = 'test'; end; /* and so on */ %mend; Unfortunately there is an error message in the log: ERROR 180-322: Statement is not valid or it is used out of proper order.. It looks that I can not use for example comparisons. I totally don't have a clue how can I implement such logic. Any help would be appreciated 🙂    Best,  Filip ... View more