Date:         Mon, 21 Jan 2008 15:16:40 -0800
Reply-To:     Tree Frog <tree.frog2@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tree Frog <tree.frog2@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Strange error : Server gets disconnected.
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hello there

Just a hunch, but possibly if you explicitly close all other ods
destinations before opening up the pdf one.

Put
ods _all_ close;

at the start of your code.

Might be worth a try.

TF

On Jan 22, 5:49 am, "shaunak.adgaon...@gmail.com"
<shaunak.adgaon...@gmail.com> wrote:
> Here is my code.
>
> %include "/sas913/StoredProcessFiles/RLINKS/IFINCC_RLINK.sas"  /
> nosource2;
> libname mylib '/sas_user/ReportingData/Fin_Analysis';
> %let FOIYEAR=2007;
>
> proc sql;
> CONNECT TO DB2(DATASRC=postg011  SCHEMA=FIN_MGT
>         USER=&uid  PASSWORD=&pwd);
> create table mylib.Federal1 as
> select * from connection to db2
> (SELECT
>   A.BEN_CTRC_NBR,
>   YEAR(A.PS_ACTG_DT) as year,
>   A.PS_CMP_CDE,
>   A.PS_ACCT_CDE,
>   A.DEPT_DESK_CDE,
>   A.PS_ACTG_DT,
>   A.FULL_DSCR,
>   A.BATC_NBR,
>   A.PS_ENT_AMT
> FROM
>   FIN_MGT.ACTG_TRNS_DTL_V A
> WHERE
>   (
>   A.PS_ACCT_CDE  IN  ('227015', '227016', '227027', '227031',
> '227050')
>   AND  YEAR(A.PS_ACTG_DT)  =  2007
>   AND  A.PS_CMP_CDE  IN  ('AALFB', 'VIPSK')
>   ));
>
> proc sql;
> create table mylib.Federal11 as
> select * from mylib.Federal1 where ps_cmp_cde in
> ('AALFB') and ps_acct_cde in ('227015');
> quit;
> proc sql;
> create table mylib.Federal12  as
> select * from mylib.Federal1 where ps_cmp_cde in
> ('AALFB') and ps_acct_cde in ('227016','227027','227050');
> quit;
> proc sql;
> create table mylib.Federal13 as
> select * from mylib.Federal1 where ps_cmp_cde in
> ('VIPSK') and ps_acct_cde in ('227015');
> quit;
> proc sql;
> create table mylib.Federal14  as
> select * from mylib.Federal1 where ps_cmp_cde in
> ('VIPSK')
> and ps_acct_cde in ('227016','227027');
> quit;
>
> proc sort data=mylib.Federal11;
> by ps_acct_cde;
> run;
> proc sort data=mylib.Federal12;
> by ps_acct_cde;
> run;
> proc sort data=mylib.Federal13;
> by ps_acct_cde;
> run;
> proc sort data=mylib.Federal14;
> by ps_acct_cde;
> run;
>
> options nobyline;
> title justify=center "Federal Withholding 2007";
> title2 justify=left "Company : #byval1";
> title3 justify=left "Account #byval2";
> ods pdf file='/sas913/jakarta-tomcat-4.1.18/webapps/Portal/Reports/
> Accounting/Federal_Withholding_2007.pdf';
> proc report nowd data=mylib.Federal11 headline headskip;
> by ps_cmp_cde ps_acct_cde;
> where year(ps_actg_dt)=&FOIYEAR;
> column
> BEN_CTRC_NBR
> FULL_DSCR
> PS_ACTG_DT
> DEPT_DESK_CDE
> PS_ENT_AMT
> ;
> define ben_ctrc_nbr/ order 'Contract' ;
> define full_dscr /display 'Description';
> define ps_actg_dt/display 'Date' format=mmddyy10.;
> define dept_desk_cde/'Dept Desk ';
> define ps_ent_amt/ analysis order=data sum format=comma16.2'Amount'
> style={cellwidth=150};
> /*define ps_acct_cde/order sum 'Account' order order=data ;*/
> /*compute ben_ctrc_nbr ;
>      if upcase(_break_) = '_RBREAK_' then
>         call define(_col_,'style','style={pretext="Overall
> Total"}') ;
>      else if upcase(_break_) eq: 'BEN_CTRC_NBR' then do ;
>        call define(_col_,'style','style={pretext="Total For "}') ;
>      end ;
>    endcomp ;
>
> break after ben_ctrc_nbr / summarize style={font_style=roman
> font_weight=bold}; */
>    rbreak after / summarize summarize style={font_size=11pt
>                   font_style=roman font_weight=bold};
> run;
>
> proc report nowd data=mylib.Federal12 headline headskip;
> by ps_cmp_cde ps_acct_cde;
> where year(ps_actg_dt)=&FOIYEAR;
> column
> BEN_CTRC_NBR
> FULL_DSCR
> PS_ACTG_DT
> DEPT_DESK_CDE
> PS_ENT_AMT
> ;
> DEFINE BEN_CTRC_NBR  /ORDER   'Contract';
> define full_dscr     /DISPLAY 'Description';
> define ps_actg_dt    /DISPLAY 'Date' format=mmddyy10.;
> define dept_desk_cde /DISPLAY 'Dept Desk ';
> define ps_ent_amt    /analysis order=data sum
> format=comma16.2'Amount' ;
> compute ben_ctrc_nbr ;
>      if upcase(_break_) = '_RBREAK_' then
>         call define(_col_,'style','style={pretext="Overall
> Total"}') ;
>      else if upcase(_break_) eq: 'BEN_CTRC_NBR' then do ;
>        call define(_col_,'style','style={pretext="Total For "}') ;
>      end ;
>    endcomp ;
>
> break after ben_ctrc_nbr / summarize style={font_style=roman
> font_weight=bold};
> break after ben_ctrc_nbr/summarize skip ol;
> rbreak after /summarize skip dol ;
> run;
>
> proc report nowd data=mylib.Federal13 headline headskip;
> by ps_cmp_cde ps_acct_cde;
> where year(ps_actg_dt)=&FOIYEAR;
> column
> BEN_CTRC_NBR
> FULL_DSCR
> PS_ACTG_DT
> DEPT_DESK_CDE
> PS_ENT_AMT
> ;
> define ben_ctrc_nbr/ order 'Contract' ;
> define full_dscr /display 'Description';
> define ps_actg_dt/display 'Date' format=mmddyy10.;
> define dept_desk_cde/'Dept Desk ';
> define ps_ent_amt/ analysis order=data sum format=comma16.2'Amount'
> style={cellwidth=150};
> /*define ps_acct_cde/order sum 'Account' order order=data ;*/
> /*compute ben_ctrc_nbr ;
>      if upcase(_break_) = '_RBREAK_' then
>         call define(_col_,'style','style={pretext="Overall
> Total"}') ;
>      else if upcase(_break_) eq: 'BEN_CTRC_NBR' then do ;
>        call define(_col_,'style','style={pretext="Total For "}') ;
>      end ;
>    endcomp ;
>
> break after ben_ctrc_nbr / summarize style={font_style=roman
> font_weight=bold}; */
>    rbreak after / summarize summarize style={font_size=11pt
>                   font_style=roman font_weight=bold};
> run;
> proc report nowd data=mylib.Federal14 headline headskip;
> by ps_cmp_cde ps_acct_cde;
> where year(ps_actg_dt)=&FOIYEAR;
> column
> BEN_CTRC_NBR
> FULL_DSCR
> PS_ACTG_DT
> DEPT_DESK_CDE
> PS_ENT_AMT
> ;
>
> DEFINE BEN_CTRC_NBR  /ORDER   'Contract';
> define full_dscr     /DISPLAY 'Description';
> define ps_actg_dt    /DISPLAY 'Date' format=mmddyy10.;
> define dept_desk_cde /DISPLAY 'Dept Desk ';
> define ps_ent_amt    /analysis order=data sum
> format=comma16.2'Amount' ;
> compute ben_ctrc_nbr ;
>      if upcase(_break_) = '_RBREAK_' then
>         call define(_col_,'style','style={pretext="Overall
> Total"}') ;
>      else if upcase(_break_) eq: 'BEN_CTRC_NBR' then do ;
>        call define(_col_,'style','style={pretext="Total For "}') ;
>      end ;
>    endcomp ;
>
> break after ben_ctrc_nbr / summarize style={font_style=roman
> font_weight=bold};
> break after ben_ctrc_nbr/summarize skip ol;
> rbreak after /summarize skip dol ;
> run;
>
> proc report nowd data=mylib.Federal1 headline headskip;
> where year(ps_actg_dt)=&FOIYEAR;
> column ps_cmp_cde
>  ps_acct_cde
>  ps_ent_amt;
> define ps_cmp_cde/group 'Company';
> define ps_acct_cde/group'Account';
> define ps_ent_amt/ format=comma16.2'Total' style={cellwidth=150};
> define ben_ctrc_nbr / order order=data 'Contract';
> rbreak after /summarize skip dol;
> quit;
> ods pdf close;
> libname mylib clear;
> libname fin_mgt clear;
>
> After the proc report nowd data=Mylib.Federal11 . It just pops me
> message that server got disconnected and closes. There is no error as
> such. Can u guys plz help me out with this. Thanks in advance