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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.