Help using Base SAS procedures

Values needed to be printed only in MB

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 78
Accepted Solution

Values needed to be printed only in MB

I have values in bytes which are being read and then using the MGBYTES. format or SIZEKMG. format printed now problem is there are some small values being calculated in Bytes/KB while others are large enough to make GB however requirement is irrespective of Bytes/KB  or GB have them printed only in the "MB" format...so for example below ...

1316M1
0:00No Limit296K0
0:30????????3200M27G31
0:45No Limit1129M1
0:45bbbbbbb  ffsfgsdfg300M30G

Anybody got idea how do i make sure these all only printed in MB so for example 0:00 value 296K should be printed as 0.28MB while 27GB should be printed as 27567MB ...

These all values are initially in bytes...


Accepted Solutions
Solution
‎11-11-2014 10:26 PM
Super User
Posts: 19,789

Re: Values needed to be printed only in MB

Create your own format, 1024 bytes in 1kb and 1024kb is 1MB

So your initial value divided by 1024*1024 then format either manually or via custom format.

want=cat(put(value/(1024**2), 8.2 -l), "MB");

View solution in original post


All Replies
Solution
‎11-11-2014 10:26 PM
Super User
Posts: 19,789

Re: Values needed to be printed only in MB

Create your own format, 1024 bytes in 1kb and 1024kb is 1MB

So your initial value divided by 1024*1024 then format either manually or via custom format.

want=cat(put(value/(1024**2), 8.2 -l), "MB");

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 164 views
  • 0 likes
  • 2 in conversation