topic Re: Multiple Dataset Options in SAS Programming

Multiple Dataset Options

buechler66 — Mon, 06 Apr 2020 17:30:02 GMT

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;

Re: Multiple Dataset Options

Reeza — Mon, 06 Apr 2020 17:32:31 GMT

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;

Re: Multiple Dataset Options

buechler66 — Mon, 06 Apr 2020 17:38:42 GMT

Thanks so much for the help!