Can anybody help me that how I can calculate the correlation between two variables within each group in Proc Sql? Is there any such function just as sum or mean? I want to do something like proc sql; select groupvar, corr(var1, var2) from table group by groupvar; quit;   I need the correlation variable to be one column in the final aggregated dataset.    Thanks a lot!    ... View more

  Hi everyone, I am very new to SAS and have a question that I have struggled for a while. I have dataset from a survey of people's visits to parks. What I am trying to do is transforming the first data format into the second data format. The basic idea is that if a person visits parka twice, parkc once, then the visits will contribute to the dataset by 3 (1+2) times (4 choiceoccasions). Here I want to treat each visit as a choice he is making so that I would code varialbe choice for the park he visited as 1 otherwise 0. Similarly, the second person id2's visits will be augmented by (1+2+1) four times and the choice variable is coded similarly as for id 1. For each person there will be a fixed number of 5 choiceoccasions and if their total visits is less than 5, then the remaining choice variable will be 1 for no visit, 0 for the parks.   Can anyone help me out? Really really appreciate it!      id parkname #visits 1 parka 2 1 parkb 0 1 parkc 1 2 parka 1 2 parkb 2 2 parkc 1   Desired format: id park choice choiceoccasion 1 parka 1 1 1 parkb 0 1 1 parkc 0 1 1 no visit 0 1 1 parka 1 2 1 parkb 0 2 1 parkc 0 2 1 no visit 0 2 1 parka 0 3 1 parkb 0 3 1 parkc 1 3 1 no visit 0 3 1 parka 0 5 1 parkb 0 5 1 parkc 0 5 1 no visit 1 5 1 parka 0 5 1 parkb 0 5 1 parkc 0 5 1 no visit 1 5 2 parka 1 1 2 parkb 0 1 2 parkc 0 1 2 no visit 0 1 2 parka 0 2 2 parkb 1 2 2 parkc 0 2 2 no visit 0 2 2 parka 0 3 2 parkb 1 3 2 parkc 0 3 2 no visit 0 3 2 parka 0 4 2 parkb 0 4 2 parkc 1 4 2 no visit 0 4 2 parka 0 5 2 parkb 0 5 2 parkc 0 5 2 no visit 1 5   ... View more