topic Re: SAS programming question in SAS Studio

SAS programming question

michelle05 — Sun, 15 Sep 2019 14:31:01 GMT

Question reads:

Two methods of determining carotid stenosis (narrowing of the carotid artery which supplies blood to the brain) are being compared. Method one is an invasive method that is believe to be very accurate. Method two is a noninvasive (MRI) method. One hundred patient were evaluated by these two methods with these results:

Method One Method Two Count

Occuled Occuled 15

Occuled Non-occuled 8

Non-occuled Occuled 10

Non-occuled Non-occuled 67

Re: SAS programming question

Jagadishkatam — Sun, 15 Sep 2019 14:38:30 GMT

Could you please let us know what you want output with this data.

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 14:46:34 GMT

Sorry I don't understand your question.

Re: SAS programming question

Jagadishkatam — Sun, 15 Sep 2019 15:04:18 GMT

You have posted the sample data but did not post what you are expecting the output as, the two methods data along with the count is there with this data want you want to do is not clear to me

Re: SAS programming question

Kurt_Bremser — Sun, 15 Sep 2019 15:05:16 GMT

@michelle05 wrote:

Question reads:

Two methods of determining carotid stenosis (narrowing of the carotid artery which supplies blood to the brain) are being compared. Method one is an invasive method that is believe to be very accurate. Method two is a noninvasive (MRI) method. One hundred patient were evaluated by these two methods with these results:

Method One Method Two Count

Occuled Occuled 15

Occuled Non-occuled 8

Non-occuled Occuled 10

Non-occuled Non-occuled 67

And what is the question here?

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 15:17:08 GMT

I'm sorry it says Compute Coefficient Kappa.

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 15:31:54 GMT

I apologize it says compute coefficient Kappa.

Re: SAS programming question

KachiM — Sun, 15 Sep 2019 16:38:17 GMT

It is a 2 by 2 table . Use Proc Freq to get the estimate of Kappa Coefficient.

                           
data have;
input carotid1 :$11. carotid2 :$11. count;
datalines;
Occuled      Occuled      15
Occuled      Non_Occuled   8
Non_Occuled  Occuled      10
Non_Occuled  Non_Occuled  67
;
run;

proc freq data=have;
  table Carotid1*carotid2;
  exact mcnem;
  weight count;
run;

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 17:03:27 GMT

I did something similar like this earlier and I kept getting 8 errors. When I entered this code in, I got 7 errors. I am stuck.

Re: SAS programming question

KachiM — Sun, 15 Sep 2019 17:11:21 GMT

Show your Log.

I am getting the output as:

The FREQ Procedure
Frequency
Percent
Row Pct
Col Pct
	
Table of carotid1 by carotid2
carotid1 	carotid2
Non_Occuled 	Occuled 	Total
Non_Occuled 	
67
67.00
87.01
89.33
	
10
10.00
12.99
40.00
	
77
77.00
 
 
Occuled 	
8
8.00
34.78
10.67
	
15
15.00
65.22
60.00
	
23
23.00
 
 
Total 	
75
75.00
	
25
25.00
	
100
100.00

Statistics for Table of carotid1 by carotid2
McNemar's Test
Chi-Square 	DF 	Pr > ChiSq 	Exact
Pr >= ChiSq
0.2222 	1 	0.6374 	0.8145
Simple Kappa Coefficient
Estimate 	Standard
Error 	95% Confidence Limits
0.5068 	0.1008 	0.3092 	0.7045

Sample Size = 100

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 17:21:43 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

71 ***PROGRAM TO CALCULATE KAPPA FROM RAW DATA

72 DATA HAVE;

73 INPUT METHOD1 $ METHOD2 $ COUNT;

_____

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

74 DATALINES;

_________

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

75 OCCULED OCCULED 15

_______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

76 OCCULED NON_OCCULED 8

77 NON_OCCULED OCCULED 10

78 NON_OCCULED NON_OCCULED 67

79 ;

80 RUN;

81 PROC FREQ DATA = HAVE;

ERROR: File WORK.HAVE.DATA does not exist.

82 TABLE METHOD1*METHOD2;

ERROR: No data set open to look up variables.

83 WEIGHT COUNT;

ERROR: No data set open to look up variables.

84 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 296.37k

OS Memory 32164.00k

Timestamp 09/15/2019 05:04:47 PM

Step Count 438 Switch Count 0

Page Faults 0

Page Reclaims 16

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: SAS programming question

michelle05 — Sun, 15 Sep 2019 17:23:56 GMT

Thank you! It was me! I have the output this time. Sorry! Again, thank you for your time and your help.