Hi all, I tried to fill the blanks with the previous values, as show below:   this is the original data look like.   ID VISIT value1 value2 value3 A 1 5 7 9 A 2       A 3       A 4 10 5 3 A 5       B 1 11 2 6 B 2       B 3 16 7 9 B 4       B 5 18 20 5   this is what I want  ---  fill the blank with the previous data. so A2 is filling with A1 values as well as A3 and so on. ID VISIT value1 value2 value3 A 1 5 7 9 A 2 5 7 9 A 3 5 7 9 A 4 10 5 3 A 5 10 5 3 B 1 11 2 6 B 2 11 2 6 B 3 16 7 9 B 4 16 7 9 B 5 18 20 5   I wonder how to write the codes to get what I want. Any help will be very appreciate.   Thank you, ... View more

Hi there, I wonder if someone can help me to figure it out of how to write code for filling the consecutive values, as following: ID VISIT VALUE WANTS A 1 0 0 A 2 0 0 A 3 1 1 A 4 0 1 A 5 0 1 B 1 0 0 B 2 0 0 B 3 1 1 B 4 0 1 B 5 0 1   for example: ID A at visit 3, the value = 1, I want to fill the consecutive visits with the value as 1.   Please let me know if my question is not clear enough. Thanks you very much in advance. ... View more

Hi, How do I generate a Vbar3d for the 3 groups, as show below: Group Year TOTAL A 2012 9 A 2013 22 A 2014 32 A 2015 4 B 2012 1 B 2013 14 B 2014 8 B 2015 2 C 2012 3 C 2013 22 C 2014 10 C 2015 4 Any help will be very appreciate. Thanks, ... View more

Hi, I have a problem with output CSV data. I have a file consist of Month/Year in Text format, for example 11/2007, 01/2003 ....ect. when I use ODS csv to output the file, and then open in excel file,  the Month/Year values change from 11/2007 to 7-Nov, and 01/2003 changes to 3-Jan. I wonder, is there a way to hold the original date value as is when I do ODS csv and looks the same when open in excel file. Any idea would be appreciate. Thank you. ... View more