topic Re: RENAME STATEMENT in New SAS User

RENAME STATEMENT

swayto — Sat, 15 Jun 2019 20:32:39 GMT

what is wrong with this dataset, and what is the best way to code it?

data work.comapany;

set work.dept1 (keep=jobecode)

work. dept2 (rename =(jcode=jobcode));

run;

Re: RENAME STATEMENT

VDD — Sat, 15 Jun 2019 20:07:46 GMT

you have (rename =(jcode=jobcode))

do you mean to have this (rename =(jobcode=jcode))

Re: RENAME STATEMENT

Kurt_Bremser — Sat, 15 Jun 2019 20:15:54 GMT

First of all, the code is written in a very ugly way, and only its small size makes it still easy to understand, more or less.

At least try to do some consistent visual formatting, it will help you in the future.

   data work.comapany;
        set work.dept1 (keep=jobecode); /* this semicolon must not be here, as it ends the set statement prematurely */
             work. dept2 (rename =(jcode=jobcode)); /* the blank between the dot and dept2 will cause an ERROR, and the order in the rename is wrong */
run;

Re: RENAME STATEMENT

Tom — Sun, 16 Jun 2019 12:30:21 GMT

Hard to tell if there are issues (other than obvious typos like extra semi-colon. two spellings for JOBCODE, inserted space etc) without knowing what the intent was.

I am not that big a fan of using KEEP=/DROP=/RENAME= dataset options instead of using the KEEP/DROP/RENAME statements, although there are some things they are best for.

Looks like you want to keep the variable JCODE and rename it to JOBCODE. But then why is the target dataset named COMPANY instead of JOB (or JOBS).

Perhaps you meant to do something like this to create one dataset with one variable that lists all of the JOBCODE/JCODE values?

data jobs;
  set dept1 (keep=jobcode)
      dept2 (keep=jcode rename =(jcode=jobcode))
  ;
run;