We need to convert the program into proc sql programming. Could someone assist us on this?   The data will contain country holidays. From the data source file given, fulfill the following requirements:   Create database, tables (staging tables and audit tables) Define indexes, constraints, triggers, functions, procedures and other as needed. (I’m not sure if this is applicable to SAS?) Only load the current year holidays. Aside from the holidays from the file, all the weekends (Saturdays and Sundays) will be entered in the result table as a weekend holiday, which can be identified differently from the holiday picked up from the file. Design the tables thinking that there will be several country files.     The proc sql script for the database design and the data itself should be able to address the following questions:   How many holidays are there for each country? How many weekend holidays are there, at the same time falling as a declared holiday? When was a certain record added, updated or deleted? If all dates are loaded, what are repeating holidays? ... View more

We zipped a dataset using:   - call system("gzip path/data.sas7bdat")   However, when we unzipped it using:   - call system("gzip -d path/data.sas7bdat")   We noticed that its size was different from before it was zipped. Does this mean that something changed in the data set? We compared it from its back up data set using proc compare though but there is no discrepancy. However, their file sizes are different. May we know the reason behind this?   ... View more

I tried PROC CPORT on my data set expecting that the file size will become smaller but it turned out to be the opposite. The size of the file, in .xpt format, become bigger. May I know the reason behind this, is this issue common? ... View more

We have a huge amount of datasets and we only have a limited amount of space. Since we couldn't delete our datasets and to save space, we would just like to compress and decompress it whenever needed using PROC CPORT & PROC CIMPORT.   We would like to know if this approcah is safe? Is there a possibility that our datasets will be corrupted if we keep on compressing/decompressing it using this approach? Also, during compression/decompression, is there a possibility that we will encounter issues that might lead to corruption of data?   We will also be migrating from SAS 9.2 to 9.3, are decompression of compressed 9.2 datasets in 9.3 ok? ... View more