Multiple Dataset Options

[buechler66]

Hi.  I can't seem to get the syntax right for include both these Dataset Options and keep getting errors.  For the out= ORIG_SITES dataset I want to drop Destination_Code and also rename Origin_Code.  Is this possible?

Any help would be appreciated.

PROC SORT NO_DUP_KEY DATA=FAC_TYPE_IND OUT=ORIG_SITES (DROP=DESTINATION_CODE) (RENAME ORIGIN_CODE=SITE_ID);
BY ORIGIN_CODE;
RUN;

[Reeza · Accepted solution]

PROC SORT NO_DUP_KEY DATA=FAC_TYPE_IND OUT=ORIG_SITES (DROP=DESTINATION_CODE RENAME = ( ORIGIN_CODE=SITE_ID));
BY ORIGIN_CODE;
RUN;

The secondary brackets are not needed around RENAME if you're only doing one variable, but if you're doing more it's necessary so I default to including it.

---

@buechler66 wrote:

Hi.  I can't seem to get the syntax right for include both these Dataset Options and keep getting errors.  For the out= ORIG_SITES dataset I want to drop Destination_Code and also rename Origin_Code.  Is this possible?

Any help would be appreciated.

PROC SORT NO_DUP_KEY DATA=FAC_TYPE_IND OUT=ORIG_SITES (DROP=DESTINATION_CODE) (RENAME ORIGIN_CODE=SITE_ID);
BY ORIGIN_CODE;
RUN;

---

[buechler66]

Thanks so much for the help!