topic Re: Why is a user-defined format only being applied to the first class? in SAS Programming

Why is a user-defined format only being applied to the first class?

kz_ — Thu, 21 Oct 2021 21:07:28 GMT

I made this format. When I apply it to my data, only the first value is being changed (from "01-P" to "P"). What am I missing?

proc format library=caus; 
	value $tmp 
		"01-P" = "P"
		"02-B" = "B"
		"03-E" = "E"
		"04-P" = "P"
		"05-CU" = "CU"
                "07-C" = "C"
		;
run;

Re: Why is a user-defined format only being applied to the first class?

Reeza — Thu, 21 Oct 2021 21:11:58 GMT

Show how you tried to use it - did you ensure the new variable has the required length needed?

Re: Why is a user-defined format only being applied to the first class?

Reeza — Thu, 21 Oct 2021 21:12:37 GMT

Also looks like SCAN() may be useful as well since it's just taking the last portion?

new_var = scan(var, 2, "-");

Re: Why is a user-defined format only being applied to the first class?

kz_ — Thu, 21 Oct 2021 21:15:24 GMT

Nevermind! I refreshed SAS and it works. No idea what was going on, but I also don't know how to delete this post.

Re: Why is a user-defined format only being applied to the first class?

kz_ — Thu, 21 Oct 2021 21:15:58 GMT

Thank you. I got it to work by refreshing.

Re: Why is a user-defined format only being applied to the first class?

SASKiwi — Thu, 21 Oct 2021 22:33:04 GMT

You don't delete posts, you just update them as answered.

Re: Why is a user-defined format only being applied to the first class?

Reeza — Thu, 21 Oct 2021 22:40:09 GMT

Preferably with the answer!

Someone else may have the same issue, whatever it is 🙂