Hello Mushy, perhaps this Blog Entry can help you: https://blogs.sas.com/content/sgf/2017/07/28/controlling-stored-process-execution-through-request-initialization-code-injection/   It describes how to request a code injection during the STP initialisation.   Regards, Robert ... View more

INSERTBUFF is the option to consider here. BULKLOAD and DBCOMMIT won't affect read operations. Pass-through will probably have the same performance as library access. But, you could use pass-through to shorten wide columns before transfer to SAS (which would also probably work using implicit pass-through using PROC SQL and LIBNAME). ... View more

@Madelyn_SAS  Thanks for the response. By Mistake I accepeted my post as a solution instead of yours . Do you know how to to change it so that I could accept your post as solution?   Thanks, Mushy ... View more

Thanks All for helping me out! ... View more

By default trustedcerts includes a number of built-in well-known CA certificates, so you'll see many that are not related to your internal certificates. ... View more

Hello @Mushy ,   while you got a perfect answer from @gwootton. I would like to add something that might be interesting:   For web applications in 9.4 there is a SAS code you can run that can query the metadata configuration, quite relevant: https://gist.github.com/frayos/5213a8e129747db67cc7a478fe266a37   For SAS Viya, you will need to query your Ingress configurations (with kubectl get endpoints) and/or your NGNIX config ( cat /etc/nginx/nginx.conf - which would be the similar one as indicated by @gwootton  in 9.4) I hope it helps you or anyone who finds this! ... View more

You would use DAVTree to navigate the SAS Content Server in SAS 9.4 (<SASConfig>/Lev1/Web/Utilities/DAVTree.sh) Use the DAVTree Utility to Manage WebDAV Content https://go.documentation.sas.com/doc/en/bicdc/9.4/bimtag/p1pxveukfyuahgn19he3ib4i0o9s.htm ... View more

I'm not sure what your may be thinking about asking with correlation but if I build a data set with your formula for some data and run a regression: data examine; do x1= 1 to 25; do x2 = -5 to 5; result = x1 + 2*x2; output; end; end; run; proc reg data=examine; model result=x1 x2; run; The coefficient for X2 is that "weight" Parameter Estimates Variable DF Parameter Estimate Standard Error t Value Pr > |t| Intercept 1 0 0 . . x1 1 1.00000 0 Infty <.0001 x2 1 2.00000 0 Infty <.0001       ... View more

@SASJedi  Thanks for the comparision and helping out with the efficient way to update. Indeed modify satatement is the better option. Thanks Mushy ... View more

@s_lassen That can't be the solution. And update in place can't change the table structure and though either IF 0 THEN SET DIM; is not required or more likely this code is not going to do what's intended. ... View more

You could import xlsm file by proc import + dbms=xlsx or excel But You are unable to export xlsm file I guess. ... View more

@SASKiwi  Thanks for the guidance! ... View more