Exactly! The calculation is correct! Thanks a lot! However, can I add tis pctn column in my dataset as the 3rd column? I also have anoter column called number_of_items and I want to calculate the pctn2 as the 4th colummn in my current dataset ... View more

Hi, I thank you. I provided a sample dataset on the under the other comment. I don't know how to provide an example desired output. ... View more

Hi, thanks for the reply. A similar dataset looks like this: data example; do bin = 1 to 3; number_of_items = round(rand('uniform')*100); output; end;   I want a 3rd column to calculate the percentages. run; ... View more

Hi, sure! This should create a similar structure data I have. I edited my question so that the column names in the question and in the code are consistent. data dataset; do i = 1 to 10; reference_month = int(12*ranuni(123)); Jul21 = int(100*ranuni(123)); Aug21 = int(100*ranuni(123)); Sep21 = int(100*ranuni(123)); Oct21 = int(100*ranuni(123)); Nov21 = int(100*ranuni(123)); Dec21 = int(100*ranuni(123)); Jan22 = int(100*ranuni(123)); Feb22 = int(100*ranuni(123)); Mar22 = int(100*ranuni(123)); May22 = int(100*ranuni(123)); Apr22 = int(100*ranuni(123)); Jun22 = int(100*ranuni(123)); Jul22 = int(100*ranuni(123)); Aug22 = int(100*ranuni(123)); Sep22 = int(100*ranuni(123)); Oct22 = int(100*ranuni(123)); Nov22 = int(100*ranuni(123)); Dec22 = int(100*ranuni(123)); output; end; run; ... View more

Hi, they are the actual column names. For example, column "01-22" referring to the first month of 2022... ... View more