Hi,
I am writting the content of SAS dataset to Oracle using Bulkload.
After loaing the data to Oracle table I observed that the character columns are having the trailing blanks.
Is there any bulkload option I can use to remove the trailing blanks?
Refer the below code that I was using for Bulkload.
proc append base=olaptable(BULKLOAD=YES
BL_LOG="/sas/bl_lltemp.log"
BL_CONTROL="/sas/bl_fcst_results_stg0_0.ctl"
BL_DATAFILE="/sas//bl_datafile.dat"
BL_BADFILE="/sas//bl_data.bad"
BL_OPTIONS='ERRORS=50'
BL_DISCARDFILE="/sas//bl_datadsc.dsc"
BL_PRESERVE_BLANKS=YES
bl_return_warnings_as_errors=yes
)
data=sasorac.sasds1;
run;
Quick Help is highly appreciated.
Thanks,
Kiran.
"CAUTION:
"CAUTION:
Thanks for the feedback.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.