LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (January 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 25 Jan 2008 10:47:44 -0800
Reply-To:     spj1@CDC.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steve James <spj1@CDC.GOV>
Organization: http://groups.google.com
Subject:      Re: Remote SAS session-no log--PLEASE TAKE A LOOK!
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

The first thing I'd recommend is have the 'rsubmit' command BEFORE the 'options notes' command. That will cause it to run on the host machine rather than on your desktop. And the host is where the processing is occurring. If that doesn't work I'm not sure what the problem might be.

Steve

On Jan 25, 8:38 am, ncspr...@HOTMAIL.COM (D Schmid) wrote: > SAS users, > =20 > Here is an example of code I am using for my remote session: > options notes; rsubmit [server name];proc sql;resetINOBS=3DMAXOUTOBS=3DMAX= > LOOPS=3DMAXNOFLOWNOFEEDBACKNOPROMPTNONUMBER;connect to SYBASE(user=3Dname p= > assword=3Dxxxxx database=3Dyyyyyserver=3Dserver name );create table FOBT as= > SelectID,syscare,fobtsc,fdos,diag1,cpt,icn,dtnum,mod,PAID,pcp,billprov from= > connection to SYBASE(selectA1.field3,A1.field4,(case when A1.FIELD5IN('101= > 1','1010','1000','1001','0011','0010','0000','0001')then 'No' when A1.F= > IELD5IN('1111','1110','1100','1101','0111','0110','0100','0101')then 'Yes'e= > nd) as FOBTsc,A2.FROM_SERVICE_DATE,A2.PRIMARY_DIAGNOSIS_CODE,A2.PROCEDURE_R= > EVENUE_CODE_PAID,A2.INTERNAL_CONTROL_NUM,A2.DETAIL_NUM,A2.PROC_CODE_MODIFIE­= > R_ADJUDICATED,A2.PAID_AMT,A2.PCP_NUM,A2.BILLING_PROVIDER_NUM from DBA.USERS= > _ASSOCIATION_TABLE A1, DBA.CLAIM_DETAIL A2whereA1.FIELD3 *=3D A2.CLIENT_I= > DANDA1.PROJECT_ID=3D'DSzzzz'ANDA2.PROCEDURE_REVENUE_CODE_PAID IN ('82270','= > 82273','82274')ANDA2.FROM_SERVICE_DATEBetween'04/01/2004'and'03/31/2005'and­= > a2.void_ind=3D'C'order by A1.FIELD3, A2.PROCEDURE_REVENUE_CODE_PAID, A2.FR= > OM_SERVICE_DATE) as t1(ID,syscare,fobtsc,fdos,diag1,cpt,icn,dtnum,mod,PAID,= > pcp,billprov);disconnect from SYBASE;quit;endrsubmit; > =20 > =20 > My log looks like this: > =20 > rsubmit [server name];NOTE: Remote submit to [server name] commencing.NOTE:= > Remote submit to [server name] complete. > =20 > --BUT I need a complete log (notes, errors, warnings, data sets created, pr= > ogram code)! I have tried SAS system options, and %sqlxmsg %sqlxrc, and I a= > m having no success. WHAT WOULD YOU SUGGEST TO TRY? > =20 > Thanks! > =20 > Doro > _________________________________________________________________ > Climb to the top of the charts!=A0Play the word scramble challenge with sta= > r power.http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wlmailtextl... > n=


Back to: Top of message | Previous page | Main SAS-L page