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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.