I use windows system, and run follows code, why filesize is different?
thanks a lot.


sql: 8192, and contents: 5120

data test;
   a=1;
run;

proc sql;
 select filesize from dictionary.tables
    where upcase(libname)='WORK'
       and upcase(memname)='TEST';
quit;

==================================

ods output "Library Members"=LibInfo;
proc contents data=test memtype=DATA ;
run;
ods output close;

My guess is that the drive in question is formatted with 4k blocksize
and the difference is allocated space minus used space.

Proc SQL is reporting the ALLOCATED space
Proc Contents is reporting the USED space
The difference is UNUSED or WASTED space for that file.

I get the same or equivalent differences for SAS files on drives
formatted with blocksizes of 1K, 4K, and 8K


.... Mark Miller

2010/1/12 =E7=BA=AA=E5=85=83 <jiyuan123@gmail.com>

> I use windows system, and run follows code, why filesize is different?
> thanks a lot.
>
>
> sql: 8192, and contents: 5120
>
> data test;
>   a=3D1;
> run;
>
> proc sql;
>  select filesize from dictionary.tables
>    where upcase(libname)=3D'WORK'
>       and upcase(memname)=3D'TEST';
> quit;
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> ods output "Library Members"=3DLibInfo;
> proc contents data=3Dtest memtype=3DDATA ;
> run;
> ods output close;
>