Hi Mahesh,    SAS WRS used for creating Reports (list or cross tab)  using from infomap source.but you can't create portal pages  in WRS the same way you are doing in IDP. Thanks & Regards ... View more

Hi Joc562, Follow the below url for exporting graph in doc or xls in SAS WRS 4.2 , refer the page number 264. http://support.sas.com/documentation/cdl/en/citug/61084/PDF/default/citug.pdf ... View more

Hi Sbb, Thanxs for the quick response, I am looking for the SAS tool which helps me to dock the drug database. ( like screening the drug database with my protein active binding site), to do this activity does SAS developed any tool.(SAS in Bioinformatics). As per my Knowledge SAS SDS and RDM are like a centralized repository for research data, If i am worng correct me. I read the below article, Where metnioned that, www2.sas.com/proceedings/sugi28/259-28.pdf BIOINFORMATICS While SAS’s core strengths remain in warehousing and advanced analytics, we are developing new tools in association with RDM and MAS for such areas as motif detection, pathway overlays, and enhanced annotation from public databases. I am looking for the SAS tools which will do the same jobs as proteomics, chemiinformatics, drug screening and docking... Thanks RAJESH KARNATI ... View more

Hi Leena, Kindly look at below Url which for user guide information on the SAS DI Tool. http://support.sas.com/documentation/onlinedoc/etls/index.html ... View more

Hi Kevin, The If statement take the STAFFID1 variable values is blank values and in the output it will creates the two variables are CNTL and STAFF , and the values of the STAFF is Blank and CNTL variable contains the concate vaules of ENTITY and STAFFID1.Here You will get the ENTITY values only. bye.. Thanks & Regards RAJESH.K ... View more

Hi vanitha, By using the title1; this statement will remove the titles in procedure, just go throught the title1; and footnote1; Statements. bye... Thanks & Regrads; RAJESH KARNATI ... View more

Hi venkatesh, If you are registered the specific target in SMC for Stored process, it should be matches when u r creating the SP in EG, if not it will give the same error. 2) other wise, the entier sas Main connection collapsed then also you can get the same probelm 3) Open EG and Look at the connection with server, for this click on the bottom side on repostiroy symbol, you will get sas main window, go for the test connection, if here you will get the probelm, then the problem is with the SASMAIN server in SMC. So check the things, and let me know...... bye... Thanks & Regards RAJESH.K ... View more

Hi SASMan, to prepare the building report menu there is a software SAS AF, this is basically for to bulid the application format. Go through the pdf mentioned below. http://www2.sas.com/proceedings/sugi30/020-30.pdf Basically there are AF and Web Af tool are there, to place the customized format on the web. I think this will be helpful to you ,but to do this format you required the basic knowledge on SCL language then only you can create your own report application form.... bye... Thanks & Reports. ... View more

Hi Srinig, As Cynthia@sas said the requiremnet for the SAS DI , it is core part (installation) and , Let me tell you first step is 1) I think you know how to create the library in DI. 2) By using the source designer Short cut icon,then u will get a window containing external file option . This will helpful for any external data extraction either it is excel, .txt or .csv. 3) place the source and target ....by using the table loader tansformation job 4) then schedule the job..as per u r requirement. I hope that this will slove your problem. Thanks & Regards RAJESH.KARNATI ... View more

Hi Michel, 1) For Cube creation both Tools SAS DI and SAS OLAP Cube Studio will do the same. but Major difference is to avoid the resticted license violation of the workspace servers, Rather than the unrestirct license with SAS DI and Integration tech server. 2) Splitter Transformation base on your condition data will split into different tables, Where as extract is nothing but Where condition. eg: Gender="male" then it will give the information only male and it ignore the female information. by splitter you will send the individual data information into different tables. 3) Aggregration is nothing but the Sumarization group of the Levels . basically it will improve the query performance. And any updated information let me know michel. Thanks & Regards RAJESH.KARNATI ... View more