topic Re: Proc Format in Statistical Procedures

Proc Format

ValSki — Tue, 27 Jun 2023 18:50:01 GMT

Hello,

I am trying to modify the formatting for variables in SAS 9.4 using 'proc format'. An example is the variable "sCYSleep" which ranges from 0-16. I am trying to create groups (as in the picture) with these values. When running frequency tables right after assigning formatting, I get the respective groups. However, whenever I run subsequent analysis, my sCYSleep variable takes on it's original 0-16.

Is there a way it can retain the formatted groupings? I'd like to have those in the dataset. I tried to manually change the values and SAS scrambles the order. Is there a way to also preserve the natural ordering of the variable names?

Re: Proc Format

awesome_opossum — Tue, 27 Jun 2023 19:07:03 GMT

I think it would work if you apply the format in a data step instead of inside proc freq. The format inside proc freq, I think, would only be held within that running of the procedure. Doing it in a data step will apply the format "permanently" (i.e. in subsequent analytic steps, like proc freq).

data work.val; set work.val; 
format sleepvar fmt.; 
run;

Re: Proc Format

sbxkoenk — Tue, 27 Jun 2023 19:10:26 GMT

Hej,

Permanent Informats and Formats

If you want to use a format or informat that is created in one SAS job or session in a subsequent job or session, then you must permanently store the format or informat in a SAS catalog.

You permanently store informats and formats by using the LIBRARY= option in the PROC FORMAT statement.

See the discussion of the LIBRARY= option in the PROC FORMAT Statement.

Also in doc :

Accessing Permanent Informats and Formats

Concepts: FORMAT Procedure

https://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p0owakbeh7u19cn0zrqftqldevpq.htm

Koen

Re: Proc Format

Reeza — Tue, 27 Jun 2023 19:34:20 GMT

That should work for you.

Re: Proc Format

ValSki — Tue, 27 Jun 2023 19:59:58 GMT

Reeza,

Thank you for this solution!

Do you know how to tell SAS to keep the categories in order (i.e., none, low, etc.). When I run frequency tables pr any subsequent stats, the categories are all jumbled up. It appears to be listed in alphabetical order (i.e., high, low, etc.).

Re: Proc Format

Tom — Tue, 27 Jun 2023 20:01:26 GMT

"Natural ordering of the variable names"?

What does that mean?

If you make a new variable it will naturally be added after all of the existing variables.

If you convert a number to a character string it will naturally sort differently. If you want the text values to sort in the same order as the original numeric values then you will need to be more creative in the strings you using. Perhaps add a prefix to the strings?

Re: Proc Format

Reeza — Tue, 27 Jun 2023 20:03:58 GMT

If you use the original variable with the format applied it will sort correctly. If you use the converted variable, a character variable, it sorts alphabetically.

Re: Proc Format

ValSki — Tue, 27 Jun 2023 20:26:32 GMT

Awesome, thank you!

Re: Proc Format

ValSki — Tue, 27 Jun 2023 20:29:09 GMT

Hi Tom,

I meant to preserve the hierarchical nature of the original variable names (i.e., none; low; moderate, etc.).

I can preserve the ordering if I use the original variable name with the formatting applied. That seemed to have solve the problem of alphabetical ordering.

Re: Proc Format

Tom — Tue, 27 Jun 2023 21:59:14 GMT

@ValSki wrote:
Hi Tom,

I meant to preserve the hierarchical nature of the original variable names (i.e., none; low; moderate, etc.).

I can preserve the ordering if I use the original variable name with the formatting applied. That seemed to have solve the problem of alphabetical ordering.

So your did not mean variable names. Your variable name is SCYSLEEP.

You are talking about VALUES not NAMES. In particular the displayed values. So either the formatted values of your existing numeric variable or the values stored into your new character variable.

Re: Proc Format

awesome_opossum — Mon, 03 Jul 2023 13:17:08 GMT

Reeze are you studying sleep probs again? You're going to make a helpful accident, which you do every time!