Help using Base SAS procedures

PROC CONTENTS (make all vars uppercase)

Accepted Solution Solved
Reply
Super Contributor
Posts: 279
Accepted Solution

PROC CONTENTS (make all vars uppercase)

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


Accepted Solutions
Solution
‎08-18-2011 03:38 PM
PROC Star
Posts: 7,492

PROC CONTENTS (make all vars uppercase)

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;

View solution in original post


All Replies
Solution
‎08-18-2011 03:38 PM
PROC Star
Posts: 7,492

PROC CONTENTS (make all vars uppercase)

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;

Super Contributor
Posts: 279

PROC CONTENTS (make all vars uppercase)

PERFECT!

Trusted Advisor
Posts: 1,301

PROC CONTENTS (make all vars uppercase)

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 337 views
  • 0 likes
  • 3 in conversation