topic Re: Change the tablename in a sas program to upper case in SAS Programming

Change the tablename in a sas program to upper case

Shanthi123 — Wed, 21 Aug 2024 18:04:48 GMT

I have multiple sas programs and i have to change the table names to uppercase . How to do that .
Can someone help me on this?

Re: Change the tablename in a sas program to upper case

whymath — Thu, 22 Aug 2024 02:26:55 GMT

What do you mean by "tablename"? All the names of SAS datasets?

Re: Change the tablename in a sas program to upper case

SASKiwi — Thu, 22 Aug 2024 03:11:49 GMT

Why? SAS only retains dataset/table case in SAS log source code. Pretty much everywhere else in SAS they are printed in uppercase. For example in SAS log notes, procedure output and in Enterprise Guide in the Servers List.

On disk, SAS dataset/table filenames are displayed in lowercase regardless of case in SAS programs.

Re: Change the tablename in a sas program to upper case

Shanthi123 — Thu, 22 Aug 2024 05:17:03 GMT

Yes names of sas datasets in the coding .

Re: Change the tablename in a sas program to upper case

Shanthi123 — Thu, 22 Aug 2024 05:18:40 GMT

Yes , but in sas coding when i use snowflake database if the dataset name is in lower case its not reading. If it is in upper case its able to read so i need to replace the dataset names to uppercase.

Re: Change the tablename in a sas program to upper case

Ksharp — Thu, 22 Aug 2024 07:46:29 GMT

libname x 'c:\temp\';
data x.have;
set sashelp.class;
run;

data _null_;
rc=rename('c:\temp\have.sas7bdat','c:\temp\HAVE.sas7bdat','file');
run;

Re: Change the tablename in a sas program to upper case

Shanthi123 — Sat, 24 Aug 2024 05:51:24 GMT

My requirement is to change in sas entire code need to search the tables used in joins or set statement with library.
Like
Example

Proc sql;
Create table test as
Select * from gdvh. Table1
Left join gvhb.table2
;
Quit;
So it should change to
Proc sql;
Create table test as
Select * from gdvh. TABLE1
Left join gvhb.TABLE2
;
Quit;

Re: Change the tablename in a sas program to upper case

Ksharp — Sun, 25 Aug 2024 00:19:38 GMT

That would lead you to render to a plain text process problem.

data _null_;
infile 'c:\temp\have.sas';
file 'c:\temp\want.sas';
input;
_infile_=prxchange('s/\b(\w+)\s*\.\s*(\w+)\b/\1.\U\2/',-1,_infile_);
put _infile_;
run;

Re: Change the tablename in a sas program to upper case

Tom — Sat, 24 Aug 2024 16:19:05 GMT

Please share some example code where the text of the name used in the code has any impact on the case of the name used in the SNOWFLAKE database.

The only way to get strange names for tables in Snowflake is to enclose the names in quotes.

create table schema.table as ...

Will make the name of table in the default case that snowflake uses.

But

create table schema."TaBle" as ...

will make the name in mixed case. And once the name is in mixed case you have to always use the quotes when referencing it.