topic Re: Issues with proc content. in SAS Programming

Issues with proc content.

PrinceAde — Mon, 14 Aug 2023 09:36:13 GMT

Hi everyone.

Please I need help with proc contents;

I'm trying to view the content of a data set.

proc contents data=want;

run;

In the output, the heading says Alphabetic List of Variables and Attributes, however, the variables were not arranged alphabetically.

Thank you.

Re: Issues with proc content.

PaigeMiller — Mon, 14 Aug 2023 09:44:05 GMT

Please show us a screen capture. Use the "Insert Photos" icon to include your screen capture in your reply. Do NOT attach files.

Re: Issues with proc content.

PrinceAde — Mon, 14 Aug 2023 10:21:36 GMT

Okay, thank you

Re: Issues with proc content.

Kurt_Bremser — Mon, 14 Aug 2023 10:14:28 GMT

In the collating sequence of the ASCII code, capital letters appear before lowercase letters. That's why it's not a good idea to mix cases in variable names, unless you use it for specific reasons (i.e. I used it to separate variables coming in from the production DB (uppercase) vs. those created in the data warehouse during the ETL process (lowercase))

Re: Issues with proc content.

andreas_lds — Mon, 14 Aug 2023 10:35:40 GMT

You can use the option "order":

proc contents data=want order=ignorecase;

run;

Re: Issues with proc content.

PrinceAde — Mon, 14 Aug 2023 11:04:08 GMT

This worked too; thank you sir.