Hi, You can also try reading some thing about Promotion/Replication (which may be helpful depending about your requirements). Thanks, Shiva ... View more

Hi Syn, What library you want to register? Assuming it as a SAS library..Login to SASMC ->Data LibraryManager->Library->New Library->SAS Base library(Assign SASApp or SASMain server to that library) Once library is created then right click on library that you have created and then register tables Same way you can do it for RDBMS tables also but you need to create RDBMS server->RDBMS library. Thanks, Shiva ... View more

Hi, I guess the probable reasons may be . 1)Browser compatability 2)Proxy settings 3)Adobe Flash player 10 ActiveX 4)host entries Thanks, Shiva ... View more

Hi, Check this sample note. http://support.sas.com/kb/42/296.html Thanks, Shiva ... View more

Hi, Comm table would be you RDBMS table and SASComm would be SAS Dataset.You need to change the load techique tab in table loader as below to update/Insert(if new record comes it will insert and old record changes it will update..try this).Hope this helps. Thanks, Shiva ... View more

Hi Suresh, Try this code....Hope it helps. Create this stored process and then open SAS SPWA and execute and see. *ProcessBody; %STPBEGIN; OPTIONS VALIDVARNAME=ANY; *  End EG generated code (do not edit this line); %global category; ODS LISTING CLOSE; ods html body=_webout (no_bottom_matter) style=seaside; ods html close; proc sql;   create table test as select distinct name from sashelp.class; quit; data _null_;   file _webout;   if _n_ = 1 then do;      thissrv = symget('_url');      thispgm = symget('_program');   put '<FORM ACTION="'  thissrv +(-1) '" method=get>';      put '<input type="hidden" name="_program" value="'      thispgm +(-1) '">'; end;   put 'Please Select name:  <select class="button" onchange="submit()" onload="submit()" name="category" style="width=200px" size="1" >'; run; data _null_;   file _webout;   set work.test;   put "<option value='" name +(-1) "'";   if ("&category" eq name) THEN put " selected";   put " >" name +(-1) "</option>"; run; data _null_;   file _webout;   put '</select>';   put '</form>'; run; ods html body=_webout (no_top_matter) path=&_tmpcat (url=&_replay) style=seaside; PROC print DATA=sashelp.class(where=(name="&category"));run; ods html close; *  Begin EG generated code (do not edit this line); ;*';*";*/;quit; %STPEND; Thanks, Shiva ... View more

Hi SYN, Check this link..it might be helpfull https://communities.sas.com/message/129750#129750 This will help you in making a parameter file and you can resolve that in you DI,One more thing you need to do is to get the latest file. Thanks, Shiva ... View more

Hi Suresh, You can do this easily by using SAS EG or SAS MC.If you dont have these clients installed then you can do this using Base SAS(but you need to register that code in metedata) *Processbody; %stpbegin; macros statements...' %stpend; Thanks, Shiva. ... View more

Hi Nithin, You can delete the folders from metadata where reports are saved.If you want to use the utility for deleting the reports which are published from metadata or in a webdav repository, I think you can use Package Cleanup Utility(more information you can get from SAS 9.2 Intelligence Platform). Thanks, Shiva ... View more