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
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;
View solution in original post
Thank you very much!
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.