We are on Viya 3.4. Suppose this scenario: A user access https://site/SASReportViewer He is redirected to /SASLogon for authentication He autenticates himself (with LDAP credentials) He is redirected to /SASReportViewer He opens the report Report1 The Report1 opens Inside the Report1, among sas graphs, there is a data driven content object (*) This DDC begins to execute some async calls to the CAS REST API to perform some operations (i.e. it begins to call "POST: /cas/sessions" to create a session id on CAS) The CAS REST API returns 403 Unauthenticated The problem is, of course, that since the APIs are stateless I need to provide the oauth token in the http request. If I request a token to /SASLogon/oauth/token (I have already registered a new clientid on consul), and the use this token to execute (*), it works. However, in order to request a token I need the user to input his credential again! And this is where the problem is.   I need a way to call the CAS API reusing somehow the authentication the user has already provided in the standard SASLogon form when he accessed https:/site/SASReportViewer for the first time.   How would I accomplish that? What am I missing?   Thanks a lot Regards     ... View more

Hi, I'm learning proc optmodel and I have a question. Suppose we have this problem:   proc fcmp outlib=work.funcs.f; function f1(Q, H); return ( -21.570992+ Q*1.972536+ H*0.719408+ Q**2*-0.03148+ Q*H*-0.057026+ H**2*-0.008104+ Q**3*0.00117+ Q**2*H*0.000098997+ Q*H**2*0.000642+ H**3*0.000030146+ Q**4*-0.000015012+ Q**3*H*-0.000001948+ Q**2*H**2*-0.000000285+ Q*H**3*-0.0000024+ H**4*0 ); endsub; function f2(Q, H); return ( -11.381931+ Q*-0.176563+ H*0.49236+ Q**2*0.006618+ Q*H*0.004691+ H**2*-0.007303+ Q**3*0.001559+ Q**2*H*-0.001057+ Q*H**2*0.00014+ H**3*0.000035108+ Q**4*-0.000015803+ Q**3*H*-0.000005786+ Q**2*H**2*0.000007708+ Q*H**3*-0.000001467+ H**4*0 ); endsub; run; options cmplib=work.funcs; options nonotes; proc optmodel; number P = 30.440000534; number H = 83.698883057; var Q1 >= 0; var Q2 >= 0; impvar P1 = Q1 * H * f1(Q1, H) * 9.81 / 1000; impvar P2 = Q2 * H * f2(Q2, H) * 9.81 / 1000; minimize Q = Q1 + Q2; constraint P = P1 + P2; solve with nlp / maxiter=10000000 nthreads=32; print Q Q1 Q2 (Q1/Q*100) (Q2/Q*100) P P1 P2 ; run; The input variables are P and H (given as constants in the example). The minimization objective function is Q. If I run this code, I get (in the result window) the minimum Q for that specific values of P and H.   I would like to run the optimization for each P in range (0,50) by step 0.1 and for each H in range (50,100) by step 0.1 and output the results in one dataset like: P | H | Q 0 50.0 <the optimal Q with these parameters> 0 50.1 <the optimal Q with these parameters>  ... 0.1 50.0 <the optimal Q with these parameters> 0.1 50.1 <the optimal Q with these parameters> ...     How would I do that? Should I prepare a dataset with all the combinations of P and H, and then tell somehow to proc optmodel to use this dataset as input?   Thanks a lot Regards ... View more

I have a sas code where I have a list of something, and I cycle some code in a macro. %macro Run_All; %do i=1 %to 100; %Run_Single(&i); %end; %mend; %Run_All;   Inside each Run_Single at some point an error may occour (for instance there are duplicate id for proc transpose, or a dataset in "set" statement does not exists, or a dataset used to set some macrovars is emply so the macrovars are undefined, etc.).   If such error occurs, that is ok INSIDE the single cycle. But when the next cycle begins it must be free of all previous errors, i.e. the cycles must be independent!   How can I achieve that? If in the i-th cycle happens something, in the i+1-th cycle I get "was not replaced because this step was stopped." so sas refuses to keep processing the code.   I tryed setting "%let syscc=0", "options obs=max replace;" at the beginning of each cycle but it still breaks from i+1-th on.   Thank you ... View more