Hello   I have this code which output a tabulate table to excel for me. It works fine when it run in SAS EG but when run through SAS management console I get insufficient access error. I believe I need to add noprint function as I had the same error when I used proc sql with count functions but proc tabulate doesn't seem to to have one. I have tried ods select none but this stop the tabulate table to export to excel.   ods excel file="//file location/name.xslx" options(sheet_name="data");   PROC TABULATE DATA=WORK.test FORMAT=COMMA10. OUT=WORK.STABSummaryTables2(LABEL="Test Table");   VAR var1 var2; CLASS var3 / ORDER=UNFORMATTED MISSING; CLASS var4 / ORDER=UNFORMATTED MISSING; TABLE  /* ROW Statement */ var4 all = 'Total'  , /* COLUMN Statement */ var3  *(Var1 * Sum=' ' var2 * Sum=' ' ) / BOX="Tablename"; RUN;   In case it was something with the export file. I have delete the output before i run the code in SMC but still this doesn't work. Any help would be appriecated! Thanks in advance.     ... View more

Hello.   I have create this code:   proc tabulate data=sashelp.cars; class Origin DriveTrain; table Origin * (DriveTrain all="Sub Total") all="Grand Total", all*n; keylabel n='Number of each Drive Train'; run;   Which gives me this: But how do I sort the all, front and rear in descending order for each drivetrain like it does in excel pivot table below: Thanks in advance. ... View more

I'm trying to schedule a job with 2 flows which are dependent on whether the first one compete successfully. This is done using Schedule Manager.   This is set up as a job dependency for compete successfully and there are no warning when the 1st job complete. But for some reason the 2nd job does not even start. I'm not sure what I am missing? Please advise. Thanks in advance!   ... View more