Hi. I have the following step that outputs my Proc Report to excel.  I'm wondering if there a way to Bold cells in the output that contain the word TOTAL and SUBTOTAL?  See attached pic of output.   I'd appreciate any help you can give.  Thanks.   ODS EXCEL FILE="C:\USERS\STEVEBUECHLER\BOX SYNC\IBM\USPS\HRC PAY DATA ANALYSIS\&SITE._HCR_PD_SUMMARY.XLSX"; PROC REPORT DATA=&SITE._HCR_SUMMARY; COLUMNS _ALL_; RUN; ODS EXCEL CLOSE; ... View more

Hi. I'm having trouble with my Rename statement.  It runs without error, but in the very next step where I use Proc Report with ODS only the _FREQ_ variable is renamed to FREQ in the output.  The other two variables don't appear to get renamed.   Any help would be greatly appreciated.   DATA &SITE._HCR_SUMMARY; SET &SITE._SUMS_; IF AREA = '' AND HCRID = '' AND PAY_DATA_MONTH = . AND ACTIVITY_DESCRIPTION = '' THEN ACTIVITY_DESCRIPTION = 'SITE TOTAL'; IF AREA NE '' AND HCRID NE '' AND PAY_DATA_MONTH = . AND ACTIVITY_DESCRIPTION = '' THEN ACTIVITY_DESCRIPTION = 'HCR CONTRACT TOTAL'; IF AREA NE '' AND HCRID NE '' AND PAY_DATA_MONTH NE . AND ACTIVITY_DESCRIPTION = '' THEN ACTIVITY_DESCRIPTION = 'MONTHLY CONTRACT TOTAL'; DROP _TYPE_; RENAME _FREQ_=FREQ PAY_DATA_MONTH=MONTH_PAY_DATA RATE=RATE_PER_UNIT; FORMAT PAY_AMOUNT DOLLAR15.2 RATE DOLLAR15.2 UNITS COMMA15.2; RUN; /* EXPORT THE FILE TO XLS USING ODS NOTE FOR OLDER VERSIONS OF SAS YOU COULD USE ODS TAGSETS.EXCELXP FILE="C:\TEST.XML"; TO GET THE SAME RESULT */ ODS EXCEL FILE="C:\USERS\STEVEBUECHLER\BOX SYNC\IBM\USPS\HRC PAY DATA ANALYSIS\&SITE._HCR_PD_SUMMARY.XLSX"; PROC REPORT DATA=&SITE._HCR_SUMMARY; COLUMNS _ALL_; RUN; ODS EXCEL CLOSE; ... View more

Hi.  I have the following Proc SQL that sums variables at the active_description level.  Is there a way to also get an overall activity_description total by pay_data_month in the same query?  I seem to remember SQL has some sort up roll up functionality.  File attachment shows the current output.  So the desired output would have an additional row after each grouping of pay_data_month with a sub total for all activities.   Any help here would be great.  Thanks so much.   PROC SQL; CREATE TABLE &SITE._HCR_PD_ACTVTY_SUM AS SELECT PAY_DATA_MONTH , AREA , HCRID , ACTIVITY_DESCRIPTION , SUM(PAY_AMOUNT) FORMAT DOLLAR15.2 AS MNTHLY_PAY_AMNT , SUM(RATE) AS MNTHLY_RATE , SUM(UNITS) FORMAT 15.2 AS MNTHLY_UNITS FROM &SITE._HCR_PD WHERE HCRID='65036' GROUP BY PAY_DATA_MONTH ,AREA ,HCRID ,ACTIVITY_DESCRIPTION ;QUIT; ... View more

Hi.  I have a Filename Statement that I need to use a wildcard in (e.g. *).  The first commented out Filename Statement works fine, but when I update the code to use the uncommented Filename Statement which includes the * wildcard the code errors out.   Any suggestions on how I can correct this issue?  I'd appreciate any help.  Thanks.   /*FILENAME Site "'C:\Users\SteveBuechler\Box Sync\IBM\USPS\In Scope Contracts For Site\Parsed Output_Erie 0330_1000.xlsx'";*/ FILENAME Site "'C:\Users\SteveBuechler\Box Sync\IBM\USPS\In Scope Contracts For Site\Parsed Output_Erie*.xlsx'"; PROC IMPORT OUT= Sites&site DATAFILE= Site DBMS=XLSX REPLACE; SHEET="Trips"; GETNAMES=YES; RUN; ERROR: Physical file does not exist, C:\\U. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds ... View more

Hi folks.  I'm looking for a method to create a variable of the string up until the last blank space in the string.   nm1 =  'SAN ANTONIO CA'; nm2 =  'NEW SAN ANTONIO CA'   So for nm1 I'd want to return only 'SAN ANTONIO' So for nm2 I'd want to return only 'NEW SAN ANTONIO'   Any thoughts on how to do this?  Basically the requirement is to return everything prior to the final blank space in the string? But the under of blank spaces may vary.   Any help would be appreciated. ... View more