The sort order is correct. Your sort column look snumeric but is in fact character so it gets sorted alphabetically. The proper order in that case is 1 18 3 ...   What you want can be achieved by   data xx; input NUMBER ITEMS $; datalines; 0 222223 1 222228 3 141111 4 999999 19 15151515 18 8888888 run; So remove the dollar sign behind NUMBER. probably ITEMS deserves the same treatment. And add a space before the dollar sign for clarity.   - Jan. ... View more

Frankly speaking you no longer make sense. Do yo want to sort or add columns according to a specific rule (that may involve sorting)? Very different tasks indeed. Please rephrase and elaborate.   - Jan. ... View more

Hotfixes can range from a simple version bump of a single file to a whole set of files plus updates to metadata, configuration and rebuild/redeployment ofd midtier components. I doubt there would be a viable one-size-fits-all apporach to reverting any hotfix other than going back in time  by restoring a backup. And then that backup would involve a concise set of all of the above: binaries, metadata, configuration, content in the content server, framework database. Possibly destroying user data in the process. Also there is the deployment registry that needs to be updated to the new situation. In all, an intricate network of relationships that is easily disturbed. We now have the Backup&Restore Tool that takes care of this.   Simple hotfixes leave a log of files replaced and you may find it easy to undo. Also we have seen new hotfixes that aim at reverting existing ones due to adverse effects.   In this respect we may conclude that the SAS9 deployment has become convoluted over the years. No surprise SAS Vaiya is at the horizon, promising to take care of a lot of these and reated deployment headaches that are now synonymous to SAS (and probably bringing a few new ones).   Oke, enough. Off the soap box.   Regards, - Jan ... View more

Octothorpe. I like that! First time I hear of it. ... View more

Hi @Rajaram   The doc states that when using VARARGS "the last argument in the function must be an array".   So this works:   data _null_; array args{5} _temporary_ (1 2 3 4 5); sum=summation(args); put sum=; run; As I dsaid before some limitatioons apply. An array knows only elemnts of all the same type. So depending on your use case this may or may not be valuable.    I must admit, why it does work from fcmp itself is beyond me.   Hope this helps, - Jan. ... View more