I am fairly new to SAS and have inherited someone else's code. I noticed the below state in the code is where you see a change in the character length of the provider name. Prior to this step the character length for provider name = 50, after this step the provider name = 14 characters. Is anyone able to tell me why this is happening? Does the character length need to be set since applying an if statement and name change?   data HRC_4b; set HRC_4; format homecare_BEGIN_DATE datetime20.; format homecare_BEGIN_DATE2 DISCHARGE_DATE2 date9.; HOMECARE_BEGIN_DATE = SERVICE_BEGIN_DATE; HOMECARE_BEGIN_DATE2 = datepart(SERVICE_BEGIN_DATE); DISCHARGE_DATE2 = datepart(DISCHARGE_DATE); HOMECARE_PROVIDER_ID = PROVIDER_ID; if provider_id="1111111" then HOMECARE_PROVIDER_NAME="ABC of Tenango"; else if provider_id="222222" then HOMECARE_PROVIDER_NAME="ABC of Indiana County"; else HOMECARE_PROVIDER_NAME = PROVIDER_NAME; ... View more

I am running the below code to send data to Excel but have noticed that is truncates the Name(Hospital) variable. Is there a way to keep from cutting off the name when sending to Excel? Below is the code I'm using.   %MACRO READMIT_RPT_30(HOSPITAL, HOSPITAL_ID, RPTMONTH, PAID,flag);   %PUT COPY TEMPLATE TO DIRECTORY;   %let xls_orig_30 = E:\XDrive\Payor Provider\PayorProvider(DeptUsers)\SACA\Readmission Analysis\New Process\Template\test.xls;   %let xls_dest_30 = E:\XDrive\Payor Provider\PayorProvider(DeptUsers)\SACA\Readmission Analysis\New Process\&year_folder.\&RPTMONTH_30.\&HOSPITAL._READMIT_RPT_&PAID..xls; %put &xls_dest_30.;   options noxwait; X copy "&xls_orig_30." "&xls_dest_30.";   %PUT DEFINE NEW TEMPLATE LOCATION; %LET TEMPLATE = &xls_dest_30.; %PUT &TEMPLATE.;   * DEFINE TEMPLATE FILE FOR DATA INPUT; %PUT DEFINE TEMPLATE FILE FOR DATA INPUT; LIBNAME READMIT EXCEL "&TEMPLATE."; *RUN;   %PUT DELETE EXISTING DATA; PROC DATASETS LIB = READMIT noprint;       DELETE DATA2-DATA17; RUN;   %PUT DEFINE NEW DATA; DATA READMIT.DATA2; SET WORK.DATA2b; WHERE SERVICE_provider_id = substr(substr(&HOSPITAL_ID,1,16),1,16) and system_flag=&flag; drop system_flag; RUN; DATA READMIT.DATA3; SET WORK.DATA3b_30; WHERE SERVICE_provider_id = substr(&HOSPITAL_ID,1,16) and system_flag=&flag; drop system_flag; RUN; DATA READMIT.DATA4; SET WORK.DATA4b_30; WHERE SERVICE_provider_id = substr(&HOSPITAL_ID,1,16) and system_flag=&flag; drop system_flag; RUN; DATA READMIT.DATA5; SET WORK.DATA5b_30; WHERE SERVICE_provider_id = substr(&HOSPITAL_ID,1,16) and system_flag=&flag; drop system_flag; RUN; DATA READMIT.DATA6; SET WORK.DATA6b_30; WHERE SERVICE_provider_id = substr(&HOSPITAL_ID,1,16) and system_flag=&flag; drop system_flag; RUN; DATA READMIT.DATA7; SET WORK.DATA7b_30; WHERE SERVICE_provider_id = substr(&HOSPITAL_ID,1,16) and system_flag=&flag; drop system_flag; RUN;   LIBNAME READMIT CLEAR; RUN;   %MEND READMIT_RPT_30; ... View more