I have a piece of code that has infile, informat then input steps after which allocations happens on the file that has been imported. However, one of the fields is read in as informat C_C $21. and input C_C $ In the output file, the field is cut off and doesn't have enough characters, I am not sure how to change the format for the output to not cut off. i have tried adding format straight after informat but before input, however, this doens't make any difference. data CHARGE_DETAIL_&billing_month;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile "&path\MCB_Raw\charge_detail_&billing_month..csv"
delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat c_c $21.;
informat cust_name $35.
input
c_c $
cust_name $
;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
run;
data CHARGE_DETAIL_&billing_month(drop= billing_monthx billing_year);
format cust_name $35. billing_month ddmmyy10.;
set CHARGE_DETAIL_&billing_month(rename=(billing_month=billing_monthx));
billing_month = input('01'||billing_monthx||compress(billing_year), date9.);
proc sort data= CHARGE_DETAIL_&billing_month;
by billing_month;
run;
... View more