Okay please enable XCMD option to use pipe command, your SAS Admin might help you on this. Refer this link, it will give you clear explanation why we have to enable XCMD option before using pipe command: http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#p0xtd57b40ehdfn1jyk8yxemfrtv.htm ... View more

Please run PROC OPTIONS to verify that XCMD is set.   ... View more

Please try this code %put %str(NOTE: Creating indexes in Parallel...); proc datasets lib = VL00 nolist; modify VL0004_005D_Employee_Sensitive (asyncindex=YES); index delete VL0004_004D_Employee_Sk ; index delete Employee_Id ; index delete Person_Id ; index create VL0004_004D_Employee_Sk ; index create Employee_Id ; index create Person_Id ; quit;   ... View more

It might be a long shot, but if the sas table currently exists (from a previous try) then it'll need deleting before running the code again. ... View more

Okay, than try this code   proc sql; connect to odbc as oracledb (datasrc="yourDSN" user=xxxx password=xxxx); create table work.test_dataset as select * from connection to oracledb ( execute schema.oracleStoredProcedure @Param1 = 'value1', @Param2 = 'value2', @Param3 = 333; ); quit; Please note that you need  SAS/Access to ODBC or SAS/Access to Oracle license to execute oracle stored process. ... View more

Okay, than try this code proc sql; connect to odbc as oracledb (datasrc="yourDSN" user=xxxx password=xxxx); create table work.test_dataset as select * from connection to oracledb ( execute schema.oracleStoredProcedure @Param1 = 'value1', @Param2 = 'value2', @Param3 = 333; ); quit; Please note that you need  SAS/Access to ODBC or SAS/Access to Oracle license to execute oracle stored process. ... View more

Hi @sram4790;   Are you sure your test environment has the same architecture ? or it is single machine arch only?   Because in middle tear you don't need to update the license, you can also ask to SAS Tech Support for more clarifications. they can help you on this.   ... View more

Hi @sram4790;   For Midtier you will not get the option of Renew SAS Software, because midtier doesn't need the license renewal. so that's why you can not see Renew SAS Software. ... View more

You can call oracle stored process from SAS, Here is the link for code: http://support.sas.com/kb/18/350.html ... View more

If this is the scenario then please check the SAS Logon Manager log, you can refer the link on my earlier post which I have shared, it will give you a detailed log of SAS Logon manager. ... View more

Your screen shot itself showing that "No Profile selected",  Thses few steps you can check for trubleshooting: First please select a correct profile with correct metadata server hostname, port and username, if you have not created it than create the connection profile After selecting set active on profile, if it is connected and still you can not see the SASApp server, than it maybe networking issue Check the connectivity to SAS Server with telnet command in windows cmd. ... View more

have you tried to login with another user (sasadm@saspw) ?   Is it working fine?   This is the link provided by SAS for troubleshooting SAS Logon Manager problems :http://support.sas.com/kb/42/349.html   ... View more