cynthia,   The code i provided is running(but apologize "C1" is  defined as a Group) in my code as i was testing to remove blanks under a group variable  i changed it to "order". And  as I cannot share the actual data, I illustrated with C1, C2, C3,NAME columns.   Please see the attached document for a clearer example as somehow i cannot able to paste the snippets in my email.   Hope this helps.     ... View more

cynthia,   Here is my code.. as i said its  for every C1( value) there are mutliple names associated with it like 1 to many relationship.Hope the below code helps .   ods _all_ close; ods tagsets.excelxp file="MARKETVALUE_&run_date..xml" style=sasweb options(Sheet_name='Data' Orientation= "LANDSCAPE" autofit_height='yes' Embedded_Titles='OFF' frozen_headers ='1' Autofilter='All' whitespace='NORMAL'); options missing=' '; PROC REPORT DATA=test spanrows nowd MISSING style(column)=[BACKGROUNDCOLOR=white BORDERCOLOR=black BORDERWIDTH=1 FONT=(Verdana, 8pt, NORMAL) ] style(header)=[BACKGROUNDCOLOR=aliceblue BORDERCOLOR=black BORDERWIDTH=1 FONT=(Verdana, 8pt, bold)]; TITLE " REPORT"; COLUMN C1 C2 C3 opportunity_name ; DEFINE C1 /order center nozero width=3 style(column)={vjust=m textalign=c} ; DEFINE C2 /group width=4 style(column)={vjust=t just=c} ; DEFINE c3 /GROUP 'Account ID' center width=8 style(column)={vjust=t just=c}; DEFINE name /group 'opportunity Name' center width=8 style(column)={vjust=t just=c}; ods _all_ close;     ... View more

cynthia,   I have used c1 ,c2 and c3 as Group on define in Proc report.There are different "Names" associated with C1 variable(distinct values).   When i filter the Output (which is in excel or XmL) for each distinct "C1" data value the report needs to show multiple names when a user filters by "C1"  data value, but when i'm trying to Filter "C1" as shown in the Picture attached, i see blank values as well when i 'm trying to  filter "C1" column instead of "All Names" only "1 Name" is displaying.   Can i know how to suppress this blank Values when i  use Group in the Define statement in Proc report. ... View more

I tried this but im getting below warning: data _null_; X "cat /cis01/whlbio/WHL_BIO_PRODUCTION/WHL_BIO_PAIDOUT_OBLN_404_OPSRISK/logs/Paidout_obln_production_script.log |grep ^ERROR:* > /cis01/whlbio/WHL_BIO_PRODUCTION/WHL_BIO_PAIDOUT_OBLN_404_OPSRISK/logs/xx.dat"; X "count=cat /cis01/whlbio/WHL_BIO_PRODUCTION/WHL_BIO_PAIDOUT_OBLN_404_OPSRISK/logs/xx.dat|wc -l"; run; %let count1=%sysget(count); %put &count1.; WARNING: The argument to macro function %SYSGET is not defined as a system variable. ... View more

yes it written to & logdir.   I'm getting below  ERROR when i execute in batch mode.   ERROR: At least one file associated with fileref MYLOG is still in use.   is there a way i can read log dynamiccay while execution in batch mode.       ... View more

Reeza,   This is the error im getting  and below is the code i used , i have tried both xls and xlsx. ERROR: The SAS System stopped processing this step because of insufficient memory.   /*Starting ODS from here*/ ods _all_ close; ods excel file="/WBIO_Shared/RECORDS/ADM9900_Reports/Level2/340_Participations/participations_&run_date..xls" style=sasdocprinter options(Sheet_name='Data' Orientation= "LANDSCAPE" Embedded_Titles='OFF' frozen_headers ='1' Autofilter='YES' Absolute_Column_Width='9,12,32,16,43,16,24,13,21,10,20,16,14,13,13,16,14,13,35,13,6,10'); options missing=' '; PROC PRINT DATA=final_v2 noobs LABEL style(DATA)=[Foreground=Black background=WHITE fontsize=9 pt Font_Face=Arial] style(HEADER)=[Foreground=Black background=LIGHTGREY fontsize=11 pt Font_Face=Arial Font_weight=Bold JUST=LEFT] style(DATA)=data[width=1000% tagattr='wrap:yes']; Var caseid ACCOUNTID CASE_NUMBER ACCOUNT_NAME OBLIGOR_NAME OBLIGOR_NUMBER OBLIGATION_NUMBER case_reason OTHER_REASON PRIORITY REQUESTOR_ORGANIZATION REQUESTOR_NAME case_owner case_createdby STATUS REQUEST_DATE REQUEST_TIME effective_date_time effective_date EXPECTED_TURNAROUND DATE_TIME_OPENED date_time_closed min_opened_date min_closed_date max_closed_date RECORD_TYPE LASTMODIFIEDDATE REOPENED REALTIME_OPEN_CASESTATUS DAYS_SINCE_OPENED CREATED_MONTH COMPLETED_MONTH OPEN_OR_CLOSED INTITAL_COMPLETION_CYCLE_TIME MET_EFFECTIVE_DATE REOPEN_CYCLE_TIME ; Label caseid='Case-ID' ACCOUNTID='Account-Id' CASE_NUMBER='Case Number' ACCOUNT_NAME='Account Name' OBLIGOR_NAME='Obligor Name' OBLIGOR_NUMBER='Obligor Number' OBLIGATION_NUMBER='Obligation Number' case_reason='Case Reason' OTHER_REASON='Other Reason' PRIORITY='Priority' REQUESTOR_ORGANIZATION='Requestor Organisation' REQUESTOR_NAME='Requestor Name' case_owner='Case Owner' case_createdby='Case Createdby' STATUS='Status' REQUEST_DATE='Request Date' REQUEST_TIME='Request Time' effective_date_time='Effective DateTime' effective_date='Effective Date' EXPECTED_TURNAROUND='Expected TurnAround' DATE_TIME_OPENED='DateTime Opened' date_time_closed='DateTime Closed' min_opened_date='Minimum Opened Date' min_closed_date='Minimum Closed Date' max_closed_date='Maximum Closed Date' RECORD_TYPE='Record Type' LASTMODIFIEDDATE='LastModified Date' REOPENED='ReOpened' REALTIME_OPEN_CASESTATUS='Realtime Open CaseStatus' DAYS_SINCE_OPENED='Days Since Opened' CREATED_MONTH='Created Month' COMPLETED_MONTH='Completed Month' OPEN_OR_CLOSED='Open or Closed' INTITAL_COMPLETION_CYCLE_TIME='Initial Completion Cycle Time' MET_EFFECTIVE_DATE='Met Effective Date' REOPEN_CYCLE_TIME='Reopen CycleTime' ; Run; ODS excel Close;   ... View more

i'M USING .XLSX   WHEN I'M USING ods EXCEL DIRECTLY(WITHOUT SPLITTING ORIGINAL DATASET) , IT SAYS SAS HAS INSUFFICIENT MEMORY. ... View more

I have tried this below code  with do loop , but need to find a  way on how to append the graph per page for each customer.   %MACRO GRAPH; %do i=1 %to &COUNT1. %by 1; %put &&CASE_OWNER&i; options symbolgen; %macro delcat(catname); %if %sysfunc(cexist(&catname)) %then %do; proc greplay nofs igout=&catname; delete _all_; run; quit; %end; %mend delcat; %delcat(work.gseg) %let outdir=%trim(%sysfunc(pathname(work))); options orientation=landscape nodate nonumber; goptions reset=all; title 5 'Graph for &&CASE_OWNER&i'; /* This step uses multiple PROC SGPLOT procedures */ /* to write multiple PNG files to disk. Note that */ /* this step uses the IMAGENAME= option on the ODS */ /* GRAPHICS ON statement to name each PNG file */ /* that is written to disk. */ ods _all_ close; ods listing gpath="&outdir" image_dpi=300; ods graphics on / reset=index imagename='sgplot1' width=5in height=3.8in; title1 'First SGPLOT Output'; proc sgplot data=final_v3; title 'Active Status by Month Created'; vbar CREATED_MONTH / group=REALTIME_OPEN_CASESTATUS groupdisplay=cluster dataskin=gloss; where case_owner=&&CASE_OWNER&i; xaxis display=(nolabel); yaxis grid; run; ods graphics on / reset=index imagename='sgplot2' width=5in height=3.8in; title1 'Second SGPLOT Output'; proc sgplot data=final_v3; title 'Case Status by Created Month'; vbar CREATED_MONTH / group=STATUS groupdisplay=cluster dataskin=gloss; where case_owner=&I; xaxis display=(nolabel); yaxis grid; run; ods graphics on / reset=index imagename='sgplot3' width=5in height=3.8in; title1 'Third SGPLOT Output'; proc sgplot data=final_v3; title 'Case Reason Distribution'; vbar CASE_REASON / group=REALTIME_OPEN_CASESTATUS groupdisplay=cluster dataskin=gloss; where case_owner=&I; xaxis display=(nolabel); yaxis grid; run;   /*ods graphics on / reset=index imagename='sgplot4' */ /* width=5in height=3.8in;*/ /**/ /*title1 'Fourth SGPLOT Output';*/ /*proc sgplot data=sashelp.class; */ /* vbar age / response=height stat=mean; */ /* where sex="M"; */ /*run; */ ods listing; /* This step uses PROC GSLIDE with the IBACK= and */ /* IMAGESTYLE= graphics options to read the PNG */ /* files created in step 1 back into SAS. */ goptions reset=all device=png300 nodisplay xmax=5in ymax=3.8in; goptions iback="&outdir./sgplot1.png" imagestyle=fit; proc gslide; run; quit; goptions iback="&outdir./sgplot2.png" imagestyle=fit; proc gslide; run; quit; goptions iback="&outdir./sgplot3.png" imagestyle=fit; proc gslide; run; quit; /*goptions iback="&outdir./sgplot4.png" imagestyle=fit; */ /*proc gslide; */ /*run;*/ /*quit;*/ /* This final step uses PROC GREPLAY to put four */ /* SGPLOT outputs on the same PDF page. */ goptions reset=all device=sasprtc; ods listing close; ods pdf file="&outdir./greplay_sgplot.pdf" notoc dpi=300; proc greplay igout=work.gseg nofs tc=sashelp.templt template= U2D1; treplay 1:1 2:3 3:2 ; run; quit; ods pdf close; ods listing; %END; %MEND GRAPH; %GRAPH; ... View more