PROC EXPORT OUTFILE="\\corp\dfs\Mortgage_Shared\VA019\F01B\Everyone\Shared\Disaster\FEMA Disaster Servicing Loan Details_&mToday._&mTodayTS..xlsb"   DATA= purge.main_mostrecent_dr DBMS= EXCELCS REPLACE; SHEET='Loan Details'; SERVER='saspcff';   The above code is a 277K dataset which I am attempting to export as an xlsb file to a share drive.  I believe due to the enormous size I keep getting the following error   ERROR: CLI disconnect failed: Server communication failure. ERROR: Error in the LIBNAME statement.   I have a similar proc export with a much smaller size that writes to the same folder with no issues. Is it just an issue of timing out and is there a workaround coding wise ... View more

data sales; input @1 region $char8. @10 repid 4. @15 amount 10. ; format amount dollar12.; datalines;   NORTH 1001 1000000 NORTH 1002 1100000 NORTH 1003 1550000 NORTH 1008 1250000 NORTH 1005 900000 SOUTH 1007 2105000 SOUTH 1010 875000 SOUTH 1012 1655000 EAST 1051 2508000 EAST 1055 1805000 ; run;     proc sort data=sales; by region; run;   proc means noprint data= sales;/*This provides a grand total only*/ output out= sales_tot sum= ; run;   data sales_tot_1; set sales sales_tot; /*I am including the details and sum at bottom by combining both datasets*/ run;   This gives me the following REGION REPID    AMOUNT     _TYPE_  _FREQ_ EAST   1051     $2,508,000   EAST   1055     $1,805,000   NORTH  1055     $1,000,000   NORTH  1002    $1,100,000   NORTH  1003    $1,550,000   NORTH  1008    $1,250,000   NORTH  1005    $900,000   SOUTH  1007    $2,105,000   SOUTH  1010    $875,000   SOUTH  1012    $1,655,000          10154   $14,748,000   0       10   How can I format this so I can 1. Display the text 'Grand Total' under the column REGION 2. Assign a blank under REPID 3. Remove _TYPE_ and _FREQ_       ... View more

  PROC REPORT DATA= harvey_tx headskip split='*' wrap nowd   style(report)=[background=black cellspacing=10 just=center font_size=9pt font_face="Calibri" bordercolor=black borderwidth=1] style(column)=[background=white font_size=10pt bordercolor=black borderwidth=1]   ; columns Disaster State Indiv_Numb Indiv_Doll Publ_Numb Publ_Doll; define Indiv_Numb/ Display style(column)={cellwidth=60pt just=center} "Indiv #s" ; define Indiv_Doll/ Display style(column)={cellwidth=90pt just=center} "Indiv $" ; define Publ_Numb/ Display style(column)={cellwidth=60pt just=center} "Public #s" ; define Publ_Doll/ Display style(column)={cellwidth=90pt just=center} "Public $" ; define Indiv_Numb /sum f=comma6.; define Indiv_Doll /sum f=dollar16.2; define Publ_Numb /sum f=comma6.; define Publ_Doll /sum f=dollar16.2; compute before;   sum=Indiv_Numb.sum; sum=Indiv_Doll.sum; sum=Publ_Numb.sum; sum=Publ_Doll.sum; endcomp; compute after; Disaster='State'; endcomp; rbreak after /summarize ; run;  　   PROC REPORT DATA= irma_fl headskip split='*' wrap nowd style(report)=[background=black cellspacing=10 just=center font_size=9pt font_face="Calibri" bordercolor=black borderwidth=1] style(column)=[background=white font_size=10pt bordercolor=black borderwidth=1]   ; columns Disaster State Indiv_Numb Indiv_Doll Publ_Numb Publ_Doll; define Indiv_Numb/ Display style(column)={cellwidth=60pt just=center} "Indiv #s" ; define Indiv_Doll/ Display style(column)={cellwidth=90pt just=center} "Indiv $" ; define Publ_Numb/ Display style(column)={cellwidth=60pt just=center} "Public #s" ; define Publ_Doll/ Display style(column)={cellwidth=90pt just=center} "Public $" ; define Indiv_Numb /sum f=comma6.; define Indiv_Doll /sum f=dollar16.2; define Publ_Numb /sum f=comma6.; define Publ_Doll /sum f=dollar16.2; compute before;   sum=Indiv_Numb.sum; sum=Indiv_Doll.sum; sum=Publ_Numb.sum; sum=Publ_Doll.sum; endcomp; compute after; Disaster='State' ; endcomp; rbreak after /summarize; run;  I am getting a next page after the first proc report (in this case Harvey_tx)  I have several additional proc reports to enter and I want as many as possible on the same page.  For proc report in ods 1. How can I place multiple proc reports and list them on the same page 2. How can I control when I want a new page ?? ... View more

data test(keep=Disaster); set test1; run;   Sample Output Disaster Hurricane Harvey Hurricane Beula Hurricane Agnes  Wildfires   If the variable begins with Hurricane  I want to delete it and just show the word after the blank space.  I looked at compress, trim, strip functions however no examples.  How can I accomplish this ??      ... View more

data have; infile datalines truncover; input @1 deptid 1. deptdescription $ & 3-20; datalines;   1 Maths 2 Astronomy 1 Maths 3 Physics 4 Public Health 3 Physics ; run;   /* Sort by Deptid so first./last. logic can be used in the next step */ proc sort data=have; by deptid; run;   /* CALL SYMPUTX creates macro variables &Subj1, &Subj2, etc from the values of Deptdescription.*/ /* The total unique values of Deptdescription are stored in &Total */ data _null_; set have; by deptid; if first.deptid then do; i+1; call symputx('subj'|| left(put(i,2.)),deptdescription); end; if last.deptid then call symputx('total',i); run;   /* Within a macro %DO loop the data sets are created and those observations with the same */ /* Deptdescription values are read with a WHERE clause */ %macro test; %do i=1 %to &total;   data &&subj&i; set have; where deptdescription="&&subj&i";   run; %end; %mend test;   /* invoke the macro */ %test  The above process creates separate datasets based on the deptid and deptdescription.  The issue is Public Health is created twice (Public then Health) in separate datasets.  I tried using length deptdescription $50; in the macro test area however I still get separate datasets whenever there is a space in the variable name.  How can I address this? ... View more

proc sql; create table disaster1 as select Disaster,           State,           Investor,          sum(nu) as Number,          sum(dol) as Doll from disaster group by Disaster,State,Investor ;quit; OUTPUT Disaster State Investor Numb Doll HURRICANE Buela TX FNMA 2 $206,650 HURRICANE Orange AL FNMA 0 $0 HURRICANE Orange FL FNMA 332 $61,817,366 HURRICANE Orange GA FNMA 6 $1,550,996 HURRICANE Orange SC FNMA 0 $0 WILDFIRES CA FNMA 10 $2,638,711 I need to create separate datasets based on disaster and state. I could do a datastep and define each state(hardcode) however if additional states are added later I would miss them.  How could I dynamically set up individual datasets based on desired criteria that will handle any states or disaster types not listed here. I will eventually use the datasets in proc tabulate with totals based on disaster and state ... View more

Disaster                    State                 Investor           Dollars         Number Hurricane One            TX                    XXX                1000               50 Hurrican One              TX                    XYZ                 1000              50 Hurricane Two              AL                    XYZ                    50               50   If I have a proc print such as proc print data = disaster noobs grandtotal_label = 'Total'; title 'My Title'; by Disaster  State; sum Dollars Number; run;   I get this in a results area Disaster = Hurricane One = TX Investor   Dollars   Number XXX         1000         50 XYZ         1000         50 State        2000      100 Disaster = Hurricane Two = Al Investor        Dollars        Number XYZ                50                 50 State              50                 50 Grand Tot   2050             150   Is there a way to get this into separate datasets to mirror the above proc print.   I need to show these separately in a proc report in ODS.  Proc print separates them as shown and I need to display them in a proc report separately by disaster and state            ... View more

title  'Title1'; title2  'Title2; PROC REPORT DATA= test headskip split='*' wrap nowd style(report)=[background=black cellspacing=10 just=center font_size=9pt font_face="Calibri" bordercolor=black borderwidth=1] style(column)=[background=white font_size=10pt bordercolor=black borderwidth=1]    ; COLUMNS _ALL_;     DEFINE Disas_Type / Display style(column)={cellwidth=80pt just=center} "Disaster Type"; DEFINE TITLE / Display style(column)={cellwidth=80pt just=center} "Title"; DEFINE STATE / Display style(column)={cellwidth=80pt just=center} "State"; DEFINE Counties / Display style(column)={cellwidth=80pt just=center} "Counties";       run; ods listing close;   Lets say I want to add a page break after Counties and start a new page to insert another proc report and I want to place a page number at the top of each page (Page 1 of 10)  how could I do that ... View more

data pop1; set pop; run; OUTPUT STATE      LOANS   AMT AL                  1         100 AZ                  2          10 CA                3            50   Now lets say that no data was found for AZ.  The results would be STATE      LOANS   AMT AL                  1         100 CA                3            50 Is there a Macro I can insert that says that if there were 0 loans for a particular state you show the state and a 0 for both loans and amt STATE      LOANS   AMT AL                  1         100 AZ                  0          0 CA                3            50 ... View more