Hi I'm creating Excel output by running following code in SAS 9.4: options device=ACTXIMG nobyline; goptions device=png rotate=landscape ; ods graphics on; ods excel   options(sheet_interval='none' sheet_name='Graph Output' sheet_label=' ' suppress_bylines='yes'     orientation='landscape' embedded_titles='yes' center_horizontal='yes'     embedded_footnotes='yes')   style=minimal ; PATTERN1 COLOR=CX1F497D; Axis1 STYLE=1 WIDTH=1 MINOR=(NUMBER=1) LABEL=(f="calibri/Bold" "Group Counts" ) value=(h=8pt) ; Axis2 STYLE=1 WIDTH=1 LABEL=( f="calibri/Bold" "Enrollment Date CCYYMM" )value=(h=8pt); TITLE underlin=2 "#byval(region)"; FOOTNOTE; PROC GCHART DATA=REGIONGRPCNT ;     BY region;     VBAR ccyy /width=5 SUMVAR=grpcnt CLIPREF FRAME  DISCRETE TYPE=SUM space=3 SUM     COUTLINE=GRAY     RAXIS=AXIS1     MAXIS=AXIS2     LREF=1     CREF=GRAY     AUTOREF ; RUN; ods excel close; ... View more

Thanks and l!! Following code worked for me: ods escapechar="'"; options device=ACTXIMG; ods excel file="\\<<Output location>>\MEDICAL_CLAIM_DETAIL.xlsx"   options(sheet_interval='none' sheet_name='Sales Report' sheet_label=' ' suppress_bylines='yes'     orientation='landscape' fittopage='yes' embedded_titles='yes' autofit_height='yes' center_horizontal='yes'     embedded_footnotes='yes')   style=minimal ; title j=left font=Calibri h=3 "Month(#byval1)"; title2 j=left font=Calibri h=3 "Zone : #byval2"; proc report data=claim style(report)=[borderstyle=solid bordercolor=black BACKGROUND=TRANSPARENT] style(header)=[background=CX1F497D color=white fontfamily=calibri fontsize=3 textalign=c verticalalign=T borderstyle=solid bordercolor=black] style(column)=[fontfamily=calibri fontsize=2.8 textalign=c borderstyle=solid bordercolor=black ]; by date_month Zone; column EmpID,ProdA, ProdB,; define date_month / order noprint; define EmpID / display '' style=[bordercolor=white background=white]; define ProdA / analysis 'Product A Sale'; define ProdB / analysis 'Product B Sale'; rbreak after / page summarize; compute after ; emp='Total'; endcomp; run; ... View more

Hi , I'm using SAS 9.4. There is one option "Proc Print" but I don't want to modify the SAS code. Because there are a lot of them and also I'm not the developer for most of them. I can use -print option when I execute a SAS code from command line. But I have some EGP files as well and I don't think I can call them from command line. ... View more

Hi, I wrote following code to create a dataset from excel data which was supposed to be a prompt values. This dataset is then input to respective Stored Process. This way I'm able to automate this process. But problem is that it only works from my ID or other admin's id and not with other common SAS user's id. Function GetInput() As Boolean Dim sasObjectFactory As New SASObjectManager.ObjectFactory Dim obSAS As SAS.Workspace Dim ServerDef As New SASObjectManager.ServerDef Dim sasObj As SASExcelAddIn Dim SASCode As String SASCode = GetDataStep() If Trim(SASCode) <> "" Then     Set sasObj = Application.COMAddIns.Item("sas.ExcelAddIn").Object     ServerDef.MachineDNSName = sasObj.ActiveProfile.HostName     ServerDef.Port = sasObj.ActiveProfile.Port     Set sasObjectFactory = New SASObjectManager.ObjectFactory     Set obSAS = sasObjectFactory.CreateObjectByServer(sasObj.ActiveProfile.Name, True, ServerDef, "", "")     Set sasLanguageEvent = obSAS.LanguageService     sasLanguageEvent.Submit (SASCode)     GetInput = True Else     MsgBox "Please provide Mamber Ids for this report in Column A", vbInformation     ActiveSheet.Range("A3").Select     GetInput = False End If End Function Above code gives following error when tried to execute from other user's id: Any help or suggestion on this will be much appreciated!! ... View more

Hi , I've already done that but its less useful!! ... View more