Using %sysfunc on a label

[PJorge]

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

[ChrisHemedinger · Accepted solution]

Yes.  Something like:

PROC SQL;

CREATE TABLE test_table AS

SELECT ART_PRO label="%sysfunc(week(%sysfunc(today())))"

FROM WORK.COM_VTA_SEM_ANT

RUN;