Hi,    I have a simple code as an example. The program has 1 prompt that opens before running. It is compare which is assigned 0 or 1 so the code executes or not.   LIBNAME valid BASE "path" ; %Let compare_test = &compare; data valid.test; if &compare_test = 1 then do x = 1 to 10; y = x*x; output; end; run;   Is there such a way I could insert something in the VBS file to assign the value for &compare ? Right now my vbs is running, but only with default parameters. Ultimately, I want to transpose this kind of treatement on a much bigger scale for another program with about a dozen prompts to define before running. Any help would be very appreciated !   Cheers,   Edit :   Ty for advice. I've progressed quite a bit, but not there still. I can now assign value to my prompts manually via the object parameters. I'm now trying via an excel sheet, and everytime i try it does fail. Here's a part of my VBS. Compare and Date are my two prompts that opens when running the SAS program. If i enter the values manually, it does work. Otherwise if I try to read the excel value it fails. Any insight on that ? SAS program is already opened at this point. Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("path") Set ws = objWorkbook.Sheets("Invites") rowcount = ws.usedrange.rows.count Set oparameters = prjobject.Parameters ' Définition des paramètres pour l'exécution du programme SAS For Each oparameter In oparameters ' Assigner une valeur aux paramètres pertinents vb_date = ws.cells(y,4) vb_compare= ws.cells(y,5) If oparameter.Name = "Compare" Then oparameter.Value = vb_compare ' 1 If oparameter.Name = "Date" Then oparameter.Value = vb_date ' "01/01/2020" Next ... View more

Hi,    I recently got an issue and trying to figure out the best way for a work around.   Here's sample of my code   Data cash_flow; set cash_flow (rename= (FLOW_T_1-FLOW_T_&nb_s=FLOW_POS_1-FLOW_POS_&nb_s )); array FLOW_POS_ {&nb_s} $ FLOW_POS_1-FLOW_POS_&nb_s; array FLOW_PERFO_ {&nb_s} $ FLOW_PERFO_1-FLOW_PERFO_&nb_s; do i = 1 to &nb_s; FLOW_PERFO_[i] = FLOW_POS_[i]; end; run;   FLOW_POS_[i] will return these vales in numeric format -123456789 -123456789 -123456789 -123456789 -123456789   FLOW_PERFO_[i] will return these values in character format -1234E8 -1234E8 -1234E8 -1234E8 -1234E8   I need both in numeric. Any insight would be appreciated, thanks ! ... View more

Hi, I'm actually having a problem with a macro variable in a Proc SQL statement. Here's my code for the creation of the variable and the SQL statement. I'll use fictive data, but the essential is there. The problem is when I try to recall the variable in the where clause on the second SQL statement.   I get a whole lot of    NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.   edit 1: But it puts an red x like an error, and my people won't allow to run a program which generates an "error" though it isn't counted as one   Proc SQL noprint; Connect to oracle (); Select distinct data into: macro_var separated by " ',' " from connection to oracle (select data from table1 where ( maturitydate > today ) ); quit; %put %nrbquote(')&macro_var%nrbquote(');   So here my var outputs 'asdgsd','asdsgsg','affdg'   proc sql; Connect to oracle(); Create table Ind as Select * From connection to oracle ( Select * From table2 Where (data in (%nrbquote(')&macro_var%nrbquote('))) ); Quit;   Thank you ! ... View more