![]() ![]() * build a mini program for each value */ /* create a table with valid chars from data value */ select distinctĬat ( "DATA out_", compress ( &COLUMN., 'kad' ), * define which mber table, and by which column */ %let TABLE=sashelp.cars For example, if you need to break SASHELP.CARS into different tables based on the value of Origin, the SAS program would look like: ![]() Let's suppose that you need to break up a single data set into many based on the value of one of the data columns. I/O and disk access is often the most expensive part of your SAS processing, performance-wise.īut if the boss asks for broken-up data sets, you might as well spend the least possible effort on the task. ![]() Splitting a data set creates more files, which occupy more disk space and forces more I/O operations. Conventional wisdom says that this is also a pointless chore, since you can usually achieve what you want (that is, process a certain subset of data) by applying a WHERE= option or FIRSTOBS=/OBS= combination. SAS programmers are often asked to break large data sets into smaller ones. Here's a Johnny Cash/Tony Orlando collaboration that sets it to music.) Back in the day when the prison system forced inmates to perform "hard labor", folks would say (of someone in prison): "He's busy making little ones out of big ones." This evokes the cliché image of inmates who are chained together, forced to swing a chisel to break large rocks into smaller rocks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |