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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.