Date: Fri, 25 Jan 2008 08:38:15 -0500
Reply-To: D Schmid <ncspring@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: D Schmid <ncspring@HOTMAIL.COM>
Subject: Remote SAS session-no log--PLEASE TAKE A LOOK!
Content-Type: text/plain; charset="iso-8859-1"
SAS users,
Here is an example of code I am using for my remote session:
options notes; rsubmit [server name];proc sql;resetINOBS=MAXOUTOBS=MAXLOOPS=MAXNOFLOWNOFEEDBACKNOPROMPTNONUMBER;connect to SYBASE(user=name password=xxxxx database=yyyyyserver=server name );create table FOBT asSelectID,syscare,fobtsc,fdos,diag1,cpt,icn,dtnum,mod,PAID,pcp,billprov from connection to SYBASE(selectA1.field3,A1.field4,(case when A1.FIELD5IN('1011','1010','1000','1001','0011','0010','0000','0001')then 'No' when A1.FIELD5IN('1111','1110','1100','1101','0111','0110','0100','0101')then 'Yes'end) as FOBTsc,A2.FROM_SERVICE_DATE,A2.PRIMARY_DIAGNOSIS_CODE,A2.PROCEDURE_REVENUE_CODE_PAID,A2.INTERNAL_CONTROL_NUM,A2.DETAIL_NUM,A2.PROC_CODE_MODIFIER_ADJUDICATED,A2.PAID_AMT,A2.PCP_NUM,A2.BILLING_PROVIDER_NUM from DBA.USERS_ASSOCIATION_TABLE A1, DBA.CLAIM_DETAIL A2whereA1.FIELD3 *= A2.CLIENT_IDANDA1.PROJECT_ID='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='C'order by A1.FIELD3, A2.PROCEDURE_REVENUE_CODE_PAID, A2.FROM_SERVICE_DATE) as t1(ID,syscare,fobtsc,fdos,diag1,cpt,icn,dtnum,mod,PAID,pcp,billprov);disconnect from SYBASE;quit;endrsubmit;
My log looks like this:
rsubmit [server name];NOTE: Remote submit to [server name] commencing.NOTE: Remote submit to [server name] complete.
--BUT I need a complete log (notes, errors, warnings, data sets created, program code)! I have tried SAS system options, and %sqlxmsg %sqlxrc, and I am having no success. WHAT WOULD YOU SUGGEST TO TRY?
Thanks!
Doro
_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan | 
