topic How to add today() date do data in SAS Programming

How to add today() date do data

Gieorgie — Fri, 29 Apr 2022 06:21:34 GMT

Hi !

I wanted to add that each item would be assigned date today () in the format date9. run_date name. In SQL, however, it works in 4gl no, how to change it? I get an undeclared array referenced

data WpisyKW;
set tmp_0;
if zab_KW_POZ1='' then zab_KW ='BRAK'; 
if zab_KW_POZ1 ne 'T' then zab_KW ='BRAK'; 
if zab_KW_POZ1 eq 'T' then zab_KW ='AKTYWNY';
today() as Run_Date format date9.;
run;

Re: How to add today() date do data

andreas_lds — Fri, 29 Apr 2022 06:31:23 GMT

Have a closer look at Step-by-Step Programming with Base SAS^® 9.4.

You need two statements: one assigns the value to the variable run_date, another to attach the format to the variable.

format run_date date9.;
run_date = today();

EDIT: Link inserted