topic Re: Analysis of uploaded data in New SAS User

Analysis of uploaded data

lshaw753 — Sat, 25 Sep 2021 08:58:59 GMT

Hello! Im very new at learning how to use the SAS program. Is there anyone that can guide me on how to do these analysis on uploaded data. Thanks so much!

1. Use proc corr to compute the correlation between the dietary supplements DSQTCALC (Calcium) and DSQTPHOS (Phosphorus), both in milligrams. Report the correlation coefficient r and if the association is significant or not (report the p value as well).

2. Run proc means on these two variables, reporting the mean, standard deviation, and number of valid participant observations for each.

3. Perform a t-test between males and females on DSQTCALC. Is there a significant difference between these two groups? If so, which group takes more calcium supplements (report the mean values for these two groups? Report the t statistic, p value, and if there is a significant difference between males and females based upon the p value. Be sure to use the WTMEC2YR for your t-test analysis.

Re: Analysis of uploaded data

sbxkoenk — Sat, 25 Sep 2021 09:55:37 GMT

Hello,

It's always wise to specify the SAS version you are using (and possibly the Operating System (OS)).

To find out about your SAS version, submit :

%PUT &=sysvlong4;

to find out about it!

I am going to assume you have SAS VIYA 3.5+.

I have :

%PUT &=sysvlong4;
SYSVLONG4=V.03.05M0P11112019

There are "tasks" for all the assignments you need to do. By filling out the task template the code is written for you.

See here :

Good luck,

Koen

Re: Analysis of uploaded data

lshaw753 — Sat, 25 Sep 2021 12:11:46 GMT

Thanks for the help. Im using the SAS OnDemand for Academics version. I put in the first information to find out my system. This is what I got

Re: Analysis of uploaded data

lshaw753 — Sat, 25 Sep 2021 12:12:57 GMT

Sample dataset Im using is not coming up when I do the correlation analysis

Re: Analysis of uploaded data

sbxkoenk — Sat, 25 Sep 2021 14:35:42 GMT

OK.

You are using SAS 9.4 Maintenance Level 6 from autumn 2018 and you use SAS Studio as a front-end.

You need to specify a Library Reference for your dataset to come up.

LIBNAME MY_LIB V9 '/sas/demodata/Rest_of_Directory_Path_to_Data' /* access=readonly */;

Change the directory path between the quotes to the directory path your data is in!

Your dataset has a two-level name, being MY_LIB.abcxyz (where abcxyz is the name of your data file).

Good luck,

Koen

Re: Analysis of uploaded data

lshaw753 — Sat, 25 Sep 2021 17:29:24 GMT

Im really getting somewhere with your directions. I think you so much! I working on the following. I dont know if Im inputting the information in the right areas. Use proc corr to compute the correlation between the dietary supplements DSQTCALC (Calcium) and DSQTPHOS (Phosphorus), both in milligrams. Report the correlation coefficient r and if the association is significant or not (report the p value as well).

Re: Analysis of uploaded data

sbxkoenk — Sat, 25 Sep 2021 21:32:54 GMT

Hello,

It's as simple as this (see program below).

I use the dataset sashelp.fish , which is a sample dataset everybody has.

Hence, you can run below code as well.

Look at the output. It will be clear to you!

proc corr data=sashelp.fish PEARSON PLOTS=SCATTER;
 var Weight Height;
run;

Regards,

Koen