BookmarkSubscribeRSS Feed
UrvishShah
Fluorite | Level 6

hi

i have two dataset like this

data test;

input age;

cards;

20

21

22

;

data test1;

input height;

cards;

5

6

7

;

nw i want to kw the correlation b/w age and height by using proc corr  without merging two datasets coz i have 15 lacks of observation

can anybody tell me the correct solution

2 REPLIES 2
art297
Opal | Level 21

It would help if you show an example of what you are trying to achieve.  Plus, when you post, the subject line is intended to let people know the topic .. not who the poster was.

Ksharp
Super User

Since you do not want merge these two datasets. then use view to make a dummy table which used in proc corr.

Such as:

data corr/view=corr;

merge test test1;

run;

proc corr data=corr ;

var age height;

run

But I strongly recommend you to use proc stdize to standardize the age and heigth to avoid scale issue.

Ksharp

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1006 views
  • 0 likes
  • 3 in conversation