BookmarkSubscribeRSS Feed
podarum
Quartz | Level 8

  Hi, so on to my explanation.  I'm trying to use proc corr (on any other correlation procedure) that I can correlated subcolumns within columns. This is a 2 PART question.

Part 1 :The data I have is as below and I'm trying to transpose it so it looks like WANT.. 

HAVE:

                                                                                                           

                                 Metric1    Metric2    Metric3   

COL1 SCol1 Group1

COL1 SCol2 Group1

COL1 SCol3 Group1 

COL1 SCol4 Group1 

COL2 SCol5 Group1 

COL2 SCol6 Group1 

COL2 SCol7 Group1 

COL2 SCol8 Group1

COL1 SCol1 Group2

COL1 SCol2 Group2

COL1 SCol3 Group2

COL1 SCol4 Group2 

COL2 SCol5 Group2 

COL2 SCol6 Group2 

COL2 SCol7 Group2 

COL2 SCol8 Group2 

WANT:                  

                                        COL1                                   COL2                                  

                          SCol1 SCol2 SCol3 Scol4     SCol5 SCol6 SCol7 SCol8    

Group1  Metric1

Group1  Metric2

Group1  Metric3

Group2  Metric1

Group2  Metric2

Group2  Metric3

Part 2 of this problem is that I would like to correlate the SCol's within each COL only. So for example only the SCol1-SCol4 would correlate, and same for SCol5-SCol8, as per their respective COL's.  thanks

3 REPLIES 3
art297
Opal | Level 21

I don't understand what you are trying to do.  Please some example data showing that the data initially looks like, how you want it to look, and what exactly has to be correlated with what.

podarum
Quartz | Level 8

Ok, I'll try to simplify it a little:

HAVE:

                             UN_rt      /      Price

TO    SC  Model1      6.7            34.56

TO    SC  Model2      6.4            56.77

TO    NY  Model1      6.4            56.77

TO    NY  Model2      6.4            51.47

TO    ET   Model1      6.2            12.54

TO    ET   Model2      6.8            10.54

OTT  KN   Model1      7.3            37.45

OTT  KN   Model2      7.3            39.14

OTT  VN   Model1      7.4            55.76

OTT  VN   Model2      7.6            58.76

OTT  PK   Model1      7.1            11.65

OTT  PK   Model2      7.2            15.67

WANT:

                                     TO                             OTT

                             SC     NY     ET          KN      VN       PK

Model1  UN_rt       6.7      6.4     6.2          7.3      7.4       7.1 

Model2  UN_rt       6.4      6.4     6.8          7.3      7.6       7.2

Model1  Price      34.56   56.77  12.54      37.45   55.76    11.65

Model2  Price      56.77   51.47  10.54      39.14   58.76    15.67

Part 2, I want to correlate the subgroups (SC, NY and ET) within TO if there are any corrlations.  And same within the OTT group.

As an example, something like :

Group1 (SC+NY)

Group2 (ET)

Group3 (KN+PK)

Group4 (VN)

Reeza
Super User

That looks like a transpose rather than correlation? Or is there something that needs to be calculated somwhere that I'm missing.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 609 views
  • 0 likes
  • 3 in conversation