topic Re: How To add a year column in SAS Programming

How To add a year column

Midi — Thu, 01 Aug 2019 15:10:01 GMT

Hello Everyone , i'm trying to add a year column with the value 2016 for each observation , this is what i tried but it didn't work.

Any Suggestion Would be Much Appreciated , thank you.

data DB_16; 
   set DB_16;
   format Year Year4.;
   Year = '2016'd;
run;

Re: How To add a year column

novinosrin — Thu, 01 Aug 2019 15:15:11 GMT

Try

data DB_16; 
   set DB_16;
retain Year 2016;
  
run;

Re: How To add a year column

Midi — Thu, 01 Aug 2019 15:17:57 GMT

Thank you , but that didn't work !!!

Re: How To add a year column

PaigeMiller — Thu, 01 Aug 2019 15:21:31 GMT

data a;
    set a;
    year=2016;
run;

The reason your original code didn't work is that "2016"d is not valid, when you enclose a text string in quotes and append a D after the last quote, this indicates to SAS that the value enclosed in the quotes is a text date in the format of 01JAN16. and then SAS will convert it to a valid SAS date. But your code had "2016"d which is not a date in the proper format.

Re: How To add a year column

Onizuka — Thu, 01 Aug 2019 15:21:34 GMT

Why don't you try to just create a var with 2016 ?

data DB_16 ;
set DB_16 ;
year = 2016 ;
run ;

It will put 2016 on each observation

Re: How To add a year column

novinosrin — Thu, 01 Aug 2019 15:21:12 GMT

Please post the log