Please see the following links https://www.lexjansen.com/nesug/nesug11/ph/ph08.pdf  https://support.sas.com/resources/papers/proceedings13/201-2013.pdf  https://www.lexjansen.com/pharmasug/2014/AD/PharmaSUG-2014-AD02.pdf  ... View more

Thanks @Ksharp for the simple and elegant example ... View more

Thanks @Tom for the simple and elegant example. ... View more

Hello @karan96  You can have a trailing space but with single quote. Thus for Jack it will be 'Jack ' but not "Jack ". The output will be like this. There is a trailing space at the end of each variable. The code is data test; input Name $40.; datalines; Jack Alfred Crooks Julia ; run; data test; set test; Name2="'"||strip(name)||" '"; run; proc print; run; ... View more

Trying to understand your requirement Statement 1 and 2 I have created SAS Stored Process with several input parameters and have deployed it as Web Service. I am interested how can I call my new SAS Web Service.? There are many approaches to call this web service. You can use java code, you can use curl, proc http, postman, ARC client , Apache Jmeter to name a few. All depends on what you want to achieve. You can pass parameter as XML/JSON and obtain  http POST OR GET response. It all depends on what is the purpose of the call and your stored process. Statement 3 But maybe someone has some examples how SAS STP Web Service should be called/triggered using Groovy code? Again what you want to achieve. ... View more

There are many approaches. I have listed two. Use as per your need. 1.Store them at a common location may be a shared drive as .sas files. 2.Convert them to macros and store in a macro library ... View more

I agree with @sbxkoenk . It is better to drop if_N_=1 and use set &data(keep=Make obs=1); This will only read only one observation and the program will execute faster ... View more

Hello @MariaD  Your PC file server is running a remote Linux server whereas you are trying to export to a remote share drive. Is the share drive a windows share? Perhaps that may be the cause. ... View more

Hello @raj231  In the SAS software depot, you will have a folder for standalone installs. There is  stand alone installer for SAS EG as a windows installer. This would be a simpler process and no need to run SAS Deployment Manager ... View more

Hello I have made changes to the code as follows:- %macro mac01(data=prac.mac01); data _NULL_; set &data(keep=Make); %local first_make; %IF _N_ = 1 %THEN %DO; %let first_make = Make call symput("First", &first_make); %END; run; %put &First; proc print data=&data(firstobs=1 obs=5 keep=Make) noobs; run; %mend mac01; Have a look at this article https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/243-29.pdf  and this https://support.sas.com/resources/papers/proceedings17/1516-2017.pdf  ... View more

Hello @laxmanpai  I see the following statements in your question/posting Help me understand your requirement. 1.I am getting my data from oracle table wherein i am formatting my timestamp columns as follows (You give your format statement) 2.Now what is happening here is , the template table being created out of the work.test table is having the column eff_datetime with datatype as FLOAT instead of timestamp in Snowflake. So what I understand is that You are getting a date value from oracle and want to convert to a format for snowflake. Please confirm if my understanding correct? Please provide sample of date values you are getting from oracle. ... View more

Hello @jdm_xom  You wanted to know the location of sample stored process.   You can find them here on a WIndows server. Replace 9.4 with 9.3 [SASHOME]\SASFoundation\9.4\inttech\sample.   The location can also be found from SAS EG /SMC as shown by  @r_behata  ... View more