Dataset names in uppercase - urgent

[madhu]

Can any one please help me how to generate the final sas dataset name in uppercase.

[sbb]

Though you did not specify the OS platform type where SAS is running, as I understand it, the desired outcome is not attainable. See this SAS support website tech note:

http://support.sas.com/kb/15/989.html

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

unix sas member name uppercase site:sas.com

[madhu]

I am working on windows platform

[sbb]

SAS converts to lowercase per the SAS system architecture. From what I read, VALIDVARNAME only applies to SAS variable names, not SAS dataset/member names.

Question to the OP: Why do you feel a need for uppercase file-names, given that it doesn't matter anyway on Windows?

Scott Barry
SBBWorks, Inc.

[madhu]

Because the final datasets should be delivered with their names in upper case.

[sbb]

I expect it will need to be done outside of the SAS operational (that is, DATA, PROC step) environment. You may have interest with looking at CALL SYSTEM, and using FILENAME with the PIPE engine to ingest and process Windows directory/file information, possibly.

Suggest you review the SAS companion for Windows, and also search the SAS support http://support.sas.com/ website for ideas and technical / conference reference material on the topic.

Scott Barry
SBBWorks, Inc.

[garybald]

options validvarname=upcase;

[madhu]

options validvarname doesnt work for dataset names ...any other way??

[gkeeler]

*** This renames the same file to CamelCase: ***;

options noxsync noxwait;

%sysexec rename "%sysfunc(pathname(work))\badname.sas7bdat" "BadName.sas7bdat";