Hi, I need to execute two stored process.Scenario is as follows. I pass parameters while executing the first stp, the result of which is a web page in EG with links. On clicking the links another program has to be executed based on the values of the link I click. Any pointers to this issue would be appreciated. ... View more

Hi i`m getting the following error while assigning oracle tables in unix 2? libname REP Oracle SCHEMA=CREP path=CUP_PRODEXT user=SAS1READ password='sasad#123'; ERROR: Could not load /apps/sas/SASFoundation/9.2/sasexe/sasora (32 images loaded) ERROR: ld.so.1: sas: fatal: libclntsh.so.10.1: open failed: No such file or directory ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable. ERROR: Error in the LIBNAME statement. Could somebody help me out ... View more

Hi , While reading a table from Oracle which has a column containing an Oracle Integer value of 17 digits from sas and converting to a dataset , is displayed in SAS as Exponentinal no. ex REGNO(ORACLE) 12345678912345445 VAR(SAS) 1.26E16 However if I convert it again into numeric using Input function while reading , the value would be rounded 12345678912345450 . Please could someone suggest an alternative to display the full digits . Message was edited by: tommy81 Message was edited by: tommy81 Message was edited by: tommy81 ... View more

Hi Anyone who has used or has gone thru some training on SAS AML (Anti Money Laundering) package, please could you lend me some useful docs on the same. Have a requirement in the pipeline. Thanks ... View more

Hi , While comparing exection times on both EG and BASE SAS , iits been noticed that EG performs pathetically.. execution real time is many times that of BAS SAS. Please could someone help me tweak or suggest methods to improve performance ... View more

Hi , Wanted to know from somebody if SAS has an HR analytics(HCM) training program. Would be of great service if someone could provide some quick pointers . Thanks ... View more

Hi , Please could somebody thow light on the following situation. Have 2 tables say T1 and T2 . I need to populate another table T3 of the same dimension as the above. For example I need the values of (1,1) in T3 to be the ratio of values in T1 (1,1) / T2(1,1) i.e T3(1,1)=T1 (1,1) / T2(1,1) T3(1,2)=T1 (1,2) / T2(1,2) etc... Help would be greatly appreciated . ... View more

Hi I have tried connecting to a remote unix server. Prompt comes in but waits for long ang gives the following error %let server=DC3C89.QC.DELL.TX 8562; options comamid=TCP remote=server; filename rlink "C:\Program Files\SAS\SASFoundation\9.2\connect\saslink\tcpunix.scr"; run; signon user=_prompt_ password=XXXXXXXX; WARNING: USERID/PASSWORD option(s) not supported with script file. Any previous RLINK fileref specification will be ignored. NOTE: Remote signon to SERVER commencing (SAS Release 9.02.02M2P090109). ERROR: A communication subsystem partner link setup request failure has occurred. ERROR: TCP link establishment failed. ERROR: Remote signon to SERVER canceled. 65 run; 66 rsubmit; ERROR: A link must be established by executing the SIGNON command before you can communicate with SERVER. ERROR: Remote submit to SERVER canceled. ... View more

Hi I`m trying to install the SAS EBI suite to my desktop Win XP 3 The sas Deployment Wizzard pops up and the progress bar is shown progressing back and forth again and again,looksmlike almost stuck. I`m actually accessin the exe from a network drive . Please someone advice on what might have gone wrong ? Help would be greatly appreciated ... View more

Hi All, Ive included an image to my pdf output ( pdf text ) .However when i increase the size the image gets distorted. Has anyone encountered this difficulty before , any solution to include a very high resolution image , keep it compressed yet only display the required size in the report. Please advice ... View more

Hi , Could anyone please share with any document which has the features of the new SAS Mobile Technology. All other vendors like SAS, IBM etc have a detailed document on the same. Help would be deeply appreciated . ... View more

Hi, Does anyone know any function like intnx to increment or decrement quarteryear if sysdate is 19oct2010 -- quarter year would be Q4 2010 I need Q4 2010 Q3 2010 Q2 2010 Q1 2010 Q4 2009 Thankx ... View more