1. This option is DBMS-specific
2. This option interacts with other options such as INSERT_SQL and DBCOMMIT.
3. More doesn't always mean better.
From the documentation: The optimal value for this option varies with factors such as network type and available memory. You might need to experiment with different values to determine the best value for your site.
You should test to see what gives the best results for your data in your environment.
@shivagujjaru wrote:
What about bulkload ?
Same story - it depends.
For example with Oracle the intermediary text file created is rectangular with all SAS character columns fully expanded (=all the trailing blanks written to the intermediary text file). If you've got character variables with a big length which are mostly blank then using bulk load is likely not your best option.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.