Hi! Is there a way to determine the maximum record length of a dataset?
I ask because I am running into an issue where I am exporting a dataset to MS Access 2003 and, with some of the records, the last few variables are dropping. I think it is due to the total record length being more than ~2000 characters for those records. I then have to remove some variables and execute the PROC EXPORT again (which works well after removing the variables).
That number will be the max length of the number of characters needed for a single observation, but do remember that when the data are stored in a SAS dataset, there is some overhead to how the dataset is organized because of the "header" information that SAS stores. This Tech Support note illustrates the complexity involved when trying to calculate the number of "pages" needed to store the data set on disk. http://support.sas.com/kb/24/723.html