topic Re: Problem with label renaming in SAS Procedures

Problem with label renaming

tmcrouse — Fri, 06 Apr 2012 14:45:40 GMT

I have a table that is as follows:

mem admit readmit sevcd sevdesc

1111 1 0 1 minor

2222 1 1 1 minor

3333 1 0 2 moderate

4444 1 1 2 moderate

I want to rename mem to who as well as replace all those numbers with the word National. I want to keep all the other columns as they are. I tried this but it does not work right

data ntl (keep = admit readmit sevcd sevdesc);

set counts;

who = vname(national);

label = mem(who);

output;

end;

drop mem;

run;

Re: Problem with label renaming

ballardw — Fri, 06 Apr 2012 14:57:09 GMT

Syntax for renaming a variable is:

Rename oldvariablename = newvariablename

So it looks like you want RENAME MEM=WHO;

Your KEEP = variable list won't keep the new variable WHO though.

If you want all values of WHO to be "National" though it would be simpler to use:

WHO="National";

and add WHO to the keep list.

Re: Problem with label renaming

tmcrouse — Fri, 06 Apr 2012 15:05:32 GMT

The problem is it comes back and says I need a do statement and not sure what that means

Re: Problem with label renaming

tmcrouse — Fri, 06 Apr 2012 15:14:22 GMT

and the output needs to now look like this

who admit readmit sevcd sevdesc

national 1 0 1 minor

national 1 1 1 minor

national 1 0 2 moderate

national 1 1 2 moderate

Re: Problem with label renaming

ballardw — Fri, 06 Apr 2012 15:25:04 GMT

What do you mean the "Output" needs to look like this?

If you are worried about the order of columns in a dataset then:

data ntl (keep=who admit readmit sevcd sevdesc);

who='National';

set count;

run;

Personally, I don't worry about the column order in the data and work with what ever report procedure I'm using to control output order.

Re: Problem with label renaming

Jay_TxOAG — Fri, 06 Apr 2012 16:04:13 GMT

The original code contained an END; statement...that is why it is asking for a DO statement

You can use a LENGTH statement prior to the SET statement, to order your columns. Of course, PROC SQL works for this also, since you SELECT the variables and the order you want them to appear.

However, your REPORT/PRINT procedures will allow you to display the variables in any order.