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=