topic Re: Data set with more than 32 characters in SAS Programming

Data set with more than 32 characters

MariaD — Thu, 11 Jun 2020 23:03:35 GMT

Hil folks,

I know that SAS can't handle datasets with more than 32 characters. But is there any way to identify it (are SAS datasets not DBMS tables) and change the name to any one below 32 characters using SAS programming?

Thanks,

Re: Data set with more than 32 characters

ChrisNZ — Thu, 11 Jun 2020 23:43:09 GMT

Sorry this question is unclear to me. What data sets do you have and what outcome do you want?

Re: Data set with more than 32 characters

MariaD — Fri, 12 Jun 2020 00:01:49 GMT

Hi @ChrisNZ ,

Please, apologise me if my question was not clear. In our SAS environment, we find some SAS tables with names with more than 32 characters. For example: "table_name_user_big_name_table_table_table.sas7bdat". My question is, is there any way using SAS programming to change the name of this datasets to any one with less than 32 characters? For example the new name will be "table_name_user_big_name.sas7bdat".

Regards,

Re: Data set with more than 32 characters

Tom — Fri, 12 Jun 2020 00:11:51 GMT

SAS will not make a SAS7BDAT file with a name like that. Someone must have made the file outside of SAS or renamed the file outside of SAS.

Just use operating system command to rename the file. If it has not been disabled in your installation just call the operating system RENAME command (mv on Unix) to rename the file. Then you can reference the file as a dataset.

data _null_;
  infile "mv table_name_user_big_name_table_table_table.sas7bdat table_name_user_big_name.sas7bdat" pipe;
  input;
  put _infile_;
run;
data want;
  set "table_name_user_big_name.sas7bdat";
run;

If Operating System command access is disbled SAS does have the FCOPY() function that will let you copy the file to a new file with a shorter name. I don't think it has a file rename function, but perhaps there is one hiding in the grab bag of functions.

Re: Data set with more than 32 characters

SASKiwi — Fri, 12 Jun 2020 00:18:25 GMT

When you try to create a SAS table with a name more than 32 characters long SAS will fail and not create it. Where do you see these long name SAS tables? By viewing folder contents with an OS command or some other way? It is very unlikely these are genuine SAS tables. You can always try renaming them to < 32 character long names using an OS command. Then try reading them in SAS.

Re: Data set with more than 32 characters

ChrisNZ — Fri, 12 Jun 2020 00:21:15 GMT

This becomes a question about system files then: how to list and rename files.

@Tom 's reply addresses the rename part, and there are many answers on this forum about ways to list files.

Very curious how you ended up with such long (and invalid) data set names?

Re: Data set with more than 32 characters

MariaD — Fri, 12 Jun 2020 00:23:08 GMT

Thanks @Tom , yes the users made outside SAS.

Re: Data set with more than 32 characters

MariaD — Fri, 12 Jun 2020 00:25:35 GMT

Unfortunately, some users change SAS datasets name through SAS EG (accessing "File folder").

Regards,