Hi All, Didn't work for a long time with SAS, so would like to ask for advice regarding a tricky case. So let's assume table A was migrated from SAS data set to some external DB, 1 to 1 migration. After the migration, we'll need to compare if both tables are still the same, in the end should be simple answer "Yes" or "No", no need in detail report, for now. Obviously, for such a case no sense in proc compare or like that, enough simple code like select count(*) from(    select * from saslib.tableX       except    select * from DBLib.tableX ) as a Plus reversal check like DBLib.tableX minus saslib.tableX.   Such way works fine for the majority of the tables, a few tables had issues with encoding - expected, but other and main issue - is decimals like "0,000000123". So obviously each DB works with decimals in its own way, but what I would like to do(if possible) - set some global option at the beginning of SAS session that will say like: Ignore very small decimals  - like if we have 0,0019 and 0,002 -  treat them as the same values, so except(minus) of such values will result in 0 rows. Of course, we can do rounding for needed columns, etc., but generally - such comparison needs to be done for hundreds of tables(each has its own set of columns etc.), some of them are huge, so would like to rid - of any data manipulation before except(minus of those 2 tables). Making HASH based on all columns looks like also is not an option for the case - anyway, those problematic decimals will make hash value different.   So long story short - would like to ask if there is some elegant way to force SAS to treat 0.0019 and 0,002 as the same values without any additional coding.   I Will be very thankful for any advice:)! ... View more

Hi all, Have general question regarding archiving SAS data sets. So shortly I'm working with daily backuping process, main functionality finished, now I need to archivate each of the backed up(off course compressed) sas data sets. I made small investigation and made 2 scripts on vbs, executet from sas by X comnmand. First vbs make ZIP archive from SAS data set. The vbs code is small for such variant(just a few lines), archivation time is quick,  but the minus is that big data sets(>100 mb) compreesed only by 50%, so target .zip archive become approximately only 2 times smaller. Second VBS use 7Z archivator, vbs code a little bit bigger then in first case, require 7z exe file exists on machine etc., but compress much better ~10%, so result archive ~10 times smaller then initial SAS data set. But archivation time obviosuly a few times bigger then in case of ZIP archivation. So question is - what is the best, maybe more efficient archivator for SAS data sets files(both data set and index files). From another word maybe someone had similar tasks before and made deep research that results in fact that archivator XXX is the best for compressing SAS data sets? Thanks! ... View more