Change the tablename in a sas program to upper case

[Shanthi123]

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?

[whymath · Accepted solution]

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

[Shanthi123]

Yes names of sas datasets in the coding .

[SASKiwi]

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.

[Shanthi123]

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.

[Ksharp]

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;

[Shanthi123]

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;

[Ksharp]

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;

[Tom]

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.