DATA Step, Macro, Functions and more

Occasional Contributor
Posts: 18

Hi all,

I have a question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.
 Terminal Test #1 Test #2 1 2.5 3.8 2 4.0 3.9 3 5.2 4.7 4 4.9 6.0 5 5.2 5.7 6 6.0 5.7 7 5.2 5.0 8 6.6 6.2 9 6.7 7.3 10 6.6 6.5 11 7.3 8.2 12 7.2 6.6 13 5.9 6.8 14 7.5 6.6 15 7.1 7.5 16 7.2 7.5 17 6.1 7.3 18 6.3 7.1 19 6.5 7.2 20 6.5 6.7

• Verify by using a SAS.
• What is the approximate p-value of this test?

Thanks,

Joe

Super User
Posts: 19,822

Posted in reply to JaeGonKim

This is clearly homework.

1. What statistical test are you trying to run?

2. Which SAS Procedure carries out that procedure?

3. Look up that procedure in the SAS documentation and check the examples sections for many examples.

If you still need help, post back with what you've tried and details.

If it's not homework, and you're interested in learning SAS for statistical analysis, the first SAS e-course is free and will cover these types of topics. And the steps above still apply

JaeGonKim wrote:

Hi all,

I have a question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.
 Terminal Test #1 Test #2 1 2.5 3.8 2 4.0 3.9 3 5.2 4.7 4 4.9 6.0 5 5.2 5.7 6 6.0 5.7 7 5.2 5.0 8 6.6 6.2 9 6.7 7.3 10 6.6 6.5 11 7.3 8.2 12 7.2 6.6 13 5.9 6.8 14 7.5 6.6 15 7.1 7.5 16 7.2 7.5 17 6.1 7.3 18 6.3 7.1 19 6.5 7.2 20 6.5 6.7

• Verify by using a SAS.
• What is the approximate p-value of this test?

Thanks,

Joe

Super User
Posts: 19,822

Scratch that, this is identical to your previous question. Review the answer there.

Good Luck.

Occasional Contributor
Posts: 18

help the data import from Excel by using SAS

Posted in reply to JaeGonKim

Hi everyone,

The new question is quite complex data with 3 columns:

A company that manufactures motors receives reels of 10,000 terminals per reel. Before using a reel of terminals, 20 terminals are randomly selected to be tested. The test is the amount of pressure needed to pull the terminal apart from its mate. This amount of pressure should continue to increase from test to test as the terminal is “roughed up.” Let W equal the difference of the pressures: “test No. 1 pressure” minus “test No. 2 pressure.” Assume that the distribution of W is N(μw, σw2). We shall test the null hypothesis H0: μw = 0 against the alternative hypothesis HA: μw < 0 using 20 pairs of observations.

• Give the test statistic and a critical region that has a significance level of α = 0.05.
 Terminal Test #1 Test #2 1 2.5 3.8 2 4.0 3.9 3 5.2 4.7 4 4.9 6.0 5 5.2 5.7 6 6.0 5.7 7 5.2 5.0 8 6.6 6.2 9 6.7 7.3 10 6.6 6.5 11 7.3 8.2 12 7.2 6.6 13 5.9 6.8 14 7.5 6.6 15 7.1 7.5 16 7.2 7.5 17 6.1 7.3 18 6.3 7.1 19 6.5 7.2 20 6.5 6.7

• I want to import this table from Excel and than using SAS software to solve it.
• What is the approximate p-value of this test?
PROC Star
Posts: 1,760

Re: help the data import from Excel by using SAS

Posted in reply to JaeGonKim

Q1- Use proc import

Q2- Change the title so statisticians can chime in

Super User
Posts: 19,822

Re: help the data import from Excel by using SAS

Note that I've merged this thread into one, as it's a duplicate post.

Occasional Contributor
Posts: 18

Re: help the data import from Excel by using SAS

Thanks,

Joe

Frequent Contributor
Posts: 149

Re: help the data import from Excel by using SAS

Posted in reply to JaeGonKim

Please post the code you already have.

Super User
Posts: 19,822

Re: help the data import from Excel by using SAS

Posted in reply to JaeGonKim

JaeGonKim wrote:

Thanks,

Joe

@JaeGonKim please explain how this is different than your previous question, which I linked to and why the solution there doesn't work for this data. Include the code and errors, if applicable.

Super User
Posts: 11,343