Thank you for your response. I have another question, with 5 dates: date1 date2 date3 date4 date5, and 5 corresponding 5 DO: DO1, DO2, DO3, DO4, and DO5, how to do it? Thank you in advance.
... View more
Hi all, I have the following data structure from a big dataset with: DO1= date1- parity_date, DO2= date2- parity_date, data parity; input animal parity_date date1 DO1 date2 DO2; cards; AM11024 16APR2012 15OCT2012 182 28APR2015 1107 AM11024 14MAR2013 15OCT2012 -150 28APR2015 775 AM11024 04FEB2014 15OCT2012 -477 28APR2015 448 AM11024 20JAN2015 15OCT2012 -827 28APR2015 98 run; I would like to get this result: animal parity_date date DO AM11024 16APR2012 15OCT2012 182 AM11024 20JAN2015 28APR2015 98 Grouping date1 and date2 into one variable (date) and DO1 and DO2 into DO with the following condition: with the mínimum value of DO1 and DO2. Any help will be thankful. Best regards.
... View more
Thank you for your response. The data I'am going to transpose is an output from another fortran program. Newg represents 2 variables. The data is: data transpose; input iteration; cards; round1 newr value1 newg value2 newg value3 round2 newr value4 newg value5 newg value6 round3 newr value7 newg value8 newg value9 ; run;
... View more
Dear all, I want to transpose this column structure from round 1 to n: round1 newr value1 newg value2 newg value3 . . n to the following one: Round newer newg newg 1 value1 value2 value3 . . n Thank you for any help!
... View more