topic PROC CONTENTS (make all vars uppercase) in SAS Procedures

PROC CONTENTS (make all vars uppercase)

GreggB — Thu, 18 Aug 2011 19:25:15 GMT

There is an option to use with PROC CONTENTS (I think) that will make all variables upper case. Can anyone help?

PROC CONTENTS (make all vars uppercase)

art297 — Thu, 18 Aug 2011 19:38:44 GMT

I don't know about a proc contents option, but you can always set the system option. e.g.,

options validvarname=upcase;

proc contents data=sashelp.class;

run;

PROC CONTENTS (make all vars uppercase)

GreggB — Thu, 18 Aug 2011 19:43:08 GMT

PERFECT!

PROC CONTENTS (make all vars uppercase)

FriedEgg — Thu, 18 Aug 2011 19:44:11 GMT

If you are looking to collect a variable list for a given table you can also use the sashelp.vcolumns table instead of proc contents and upcase the name as part of the extract.