I want to Change the size of the datasets.
My main Problem is, that i want to create a macro witth the Parameter size and this macro create testfiles wich have this size, but i cant find a way to do this.
Size depends on the variables you create, the number of observations in the dataset and some other things like compression, page-size ... I should be possible to calculate the number of observations and variables to get a defined size. But i can't see a use-case requiring such files.
If it is about determining the size of the existing dataset in a library, we can know it by the below code.
The dataset sized will create a dataset where it will have name and dataset in library and size with other variables.
proc sql; create table sized as select * from dictionary.tables where libname='name'; quit;
Thank you for your reply.
I need the data to test Transfer between to different Systems.
Is there a formula to calculate the size?
First thing what are you using to measure "size"? Bytes, number of rows, number of characters, number of columns?
What type of file does this transfer need to use? Fixed column text files the size can be determined fairly easily but is dependent on how many characters per line.
Delimited text files such as CSV or Tab delimited would likely be not too difficult to create a fixed size but again content per line is important.
Binary files such as XLSX or structured files like XLM not so much. The XLSX can have a lot of overhead style information and the text format of XLM repeating variable names and types means that the actual names of variables affects total file size.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.