Hello, Thank you in advance for your help. I am trying to a correlation between an ordinal variable and a grouped discrete variable using SAS studio. The first variable is (referred to as "Genome") is likert scale and has 3 levels (agree, undecided, and disagree). The second (referred to as "Events") has 5 levels (0-1, 2-3, 4-5, 6+). I have attached a spreadsheet with this data for reference. I want to know wether event attendance influences acceptance of certain technologies although am running into issues converting the ordinal variables to ranks. For example, I want the variables to be coded: (agree= 1, undecided= 2, disagree= 3) and ( 0-1=1, 2-3=2, 4-5=3 and 6+ =4). To my understanding converting the ordinal variables to ranks is the only way to correlate this data. Is it true?
... View more