Using %sysfunc on a label

PJorge — Fri, 21 Jun 2013 08:42:48 GMT

Hi,

I'm using proc sql to create a table where I want the label of column "ART_PRO" to be the current week number and changes every week when pull the report.

I'm using the following:

PROC SQL;

CREATE TABLE test_table AS

SELECT ART_PRO

FROM WORK.COM_VTA_SEM_ANT

RUN;

Is it possible?

Thanks

Re: Using %sysfunc on a label

ChrisHemedinger — Fri, 21 Jun 2013 12:48:02 GMT

Yes. Something like: