topic Re: CPORT | Estimate size in Administration and Deployment

CPORT | Estimate size

MariaD — Thu, 25 Jun 2020 22:44:23 GMT

Hi folks,

We are currently working on a migration of our SAS servers. There is any way to estimate the total size needed to CPORT files? We did some test and in some case we have a compression of 70 or 80% of the original file.

Regards,

Re: CPORT | Estimate size

Kurt_Bremser — Wed, 01 Jul 2020 07:26:35 GMT

I just ran this code on University Edition:

data myfold.class1;
set sashelp.class;
length longstr $100;
longstr = name;
do i = 1 to 10000;
  output;
end;
run;

data myfold.class2 (compress=yes);
set sashelp.class;
length longstr $100;
longstr = name;
do i = 1 to 10000;
  output;
end;
run;


proc cport data=myfold.class2 file='/folders/myfolders/class.cpr';
run;

class1.sas7bdat is 26.3 MB, class2.sas7bdat is 10.8 MB, class.cpr is 13.2 MB.

So it seems that the CPORT procedure does a compress, but not as good as the compress of the dataset. My tests also gave proof that CPORTing a compressed or uncompressed dataset will yield the same result.

Don't forget to use the compress=yes option when importing your CPORT files.

Re: CPORT | Estimate size

rabindrakumar — Wed, 01 Jul 2020 07:37:11 GMT

Hi,

The mechanism of cport and compress is different, while using cport the file binaries are changed to be compatible according to cport zip functionality whereas compress is directly applied on dataset whitout changing the file binaries.

This is the reason cport has a bigger file size compared to compress.

Note:Beware of using cport, sometimes this procedure also corrupts the file.

Re: CPORT | Estimate size

Kurt_Bremser — Wed, 01 Jul 2020 08:26:14 GMT

@rabindrakumar wrote:

Note:Beware of using cport, sometimes this procedure also corrupts the file.

Can't second that, as I used CPORT/CIMPORT to move a whole data warehouse from mainframe to Reliant UNIX (SINIX) and later AIX without a hitch.

Re: CPORT | Estimate size

MariaD — Wed, 01 Jul 2020 12:39:54 GMT

Thanks folks!