topic Re: create a variable from a date in New SAS User

create a variable from a date

Annie_Fréchette — Mon, 13 Jul 2020 12:34:03 GMT

Hi!

I want to create a variable who goes frome 1 to 12 based on the date of a test (like first test of the year, second test of the year etc) Here is a little example of what I want it to look like:

Anyone can teach me?

Thanks a lot!

Annie

Re: create a variable from a date

Jagadishkatam — Mon, 13 Jul 2020 12:45:19 GMT

please try

data have;
input cow$ irtest:ddmmyy10. scc;
cards;
daisy 10/7/2017 200
maggy 10/7/2017 120
lily 10/7/2017 98
daisy 11/8/2017 89
maggy 11/8/2017 120
lily 11/8/2017 98
;

proc sort data=have;
format irtest date9.;
by cow irtest;
run;

data want;
set have;
by cow irtest;
retain no_test;
if first.cow then no_test=1;
else no_test+1;
run;

Re: create a variable from a date

andreas_lds — Mon, 13 Jul 2020 12:49:14 GMT

Can be solved by sorting data by Cow and JR_Test and a datastep with first and retain to create no_test.

data want;
  set have_sorted;
  by Cow;

  length no_test 8;
  retain no_test;

  if first.Cow then no_test = 0;
  no_test = no_test + 1;
run;

The code is untested, because you haven't provided data in usable form.

Re: create a variable from a date

Annie_Fréchette — Mon, 13 Jul 2020 13:02:40 GMT

Thank you very much!