cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
smunigala
‎06-09-2017
  • 59 Posts
  • 14 Likes Given
  • 0 Solutions
  • 0 Likes Received

how to compare significance (p-value) for diagnostic accuracy (from 2x...

by Obsidian | Level 7 in SAS Procedures
‎09-16-2016 12:53 PM
‎09-16-2016 12:53 PM
Hi all, I am having issues with finding a right test for comparing accuracy trends over time. Is Cochran-Armitage Trend test is a right choice? I have a 2x2 table comparing test results with gold standard at different time points. I plotted the accuracy trends over time on a graph, but I need to know if there is a significant trend. My data is not on a excel sheet or on SAS. I had to manually calculate accuracy for each time point and then enter them on a excel sheet to generate graphs. In the 2x2 table, If I have empty cells, I added 0.5 to each cell and then calculated accuracy. Any advise is appreciated for calculating and comparing accuracy significance across time. I am attaching the  trend grap on here.     My questions are: 1. How to enter data in SAS from a manual 2x2 table, especially when I have 2x2 table data at 4 different time points and I have to do accuracy calculations for 6 different conditions? 2. How to calcualte accuracy using SAS (and how to adjust missing cells)? 3. How to compare accuracy trends (significance, p-value) across 4 different time points? 4. My sample size is low as it is a piolt study involving 18 students.     Thank you for the help, Sat ... View more

Re: X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-15-2016 12:22 PM
‎09-15-2016 12:22 PM
Thanks, this works!   Satish ... View more

Re: X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-15-2016 12:05 PM
‎09-15-2016 12:05 PM
Independent_study 1 = Study 1 Independent_study 5 = Study 15 Independent_study 10 = Study 30 Independent_study 15 = Study 45 Independent_study 20 = Study 30   ... View more

Re: X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-15-2016 12:03 PM
‎09-15-2016 12:03 PM
Yes, the figure is correct. That is how I want. For x-axis, the value of independent_studies 5 is the same as studies 15. So the data is exactly same but I need two different x-axis exactly how I have in the PDF. will it be possible? I hope I clarified the point.   5 independent studies = 15 studies.     ... View more

Re: X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-15-2016 10:43 AM
‎09-15-2016 10:43 AM
Thank you for the reply. No that is not I was looking for. Can you see my PDf attacment? The example I have on PDF is what exactly I am looking for. Is this possible? ... View more

Re: X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-15-2016 10:10 AM
‎09-15-2016 10:10 AM
Thank you Oligolas. I ran your code. I did not get any errors, but it just gives me only one x-axis labeling (independent studies) and not for both. Can you help? I have SAS 9.4.   Thanks a lot again! Satish ... View more

Re: X-axis labeling with two lables in same graph

by Obsidian | Level 7 in ODS and Base Reporting
‎09-13-2016 12:12 PM
‎09-13-2016 12:12 PM
Hope this PDF attachment helps in communicating what I am looking for (2 X-axis lables in one graph).   Thanks, Satish ... View more

Re: X-axis labeling with two lables in same graph

by Obsidian | Level 7 in ODS and Base Reporting
‎09-13-2016 12:01 PM
‎09-13-2016 12:01 PM
Hi, Thanks for the quick reply. Yes, I am looking for two different axis labels for one graph. I attached the graphs as image (it was attached to the body of the text). If u see in the Figure 1, I have X- axis as Studies. I also want Independent Studies (in excel sheet) as X-axis label. Can you please help me with the X2AXIS sas code?   Thanks, Satish ... View more

X-axis labeling with two lables in same graph

by Obsidian | Level 7 in ODS and Base Reporting
‎09-13-2016 11:27 AM
‎09-13-2016 11:27 AM
Hi all, I am looking for help in creating graphs with two sets of labeling for X-axis. I am attaching my excel sheet, SAS code and the graphs I had generated. Basicially I want two X-axis labeling (Independent Studies and Studies) in the same graph. If you look at my SAS code, for two different graphs, X axis is Studies and Independent Studies. My data is the same and graphs generated are the same. However, I want tow X-axis labels in the same graph (Studies and Independent Studies).   Thanks for all the help, Satish ods listing close; ods graphics / reset width=600px height=400px imagename='Fig 1' imagefmt=jpeg; ods html file='Surg.html' path='E:\HRM\Revised\Revised18_New' style=journal; /*ods html file='ap.html' path='C:\' style=journal; */ proc sgplot data=graphs; scatter X=Studies Y=MP / markerattrs=(color=blue symbol=CircleFilled size=8) name="scat" legendlabel="Motor Pattern"; series X=Studies Y=MP / lineattrs=(color=blue pattern=1) ; scatter X=Studies Y=BP / markerattrs=(color=red symbol=SquareFilled size=8) name="scat1" legendlabel="Body Pattern"; series X=Studies Y=BP / lineattrs=(color=red pattern=1) ; scatter X=Studies Y=OutOb / markerattrs=(color=green symbol=TriangleFilled size=8) name="scat2" legendlabel="Achalasia/ Outflow obstruction"; series X=Studies Y=OutOb / lineattrs=(color=green pattern=1) ; XAXIS TYPE = DISCRETE ; YAXIS LABEL = '% Accuracy' VALUES = (0 TO 100 BY 10); keylegend "scat" "scat1" "scat2" "scat4" / position=bottomleft across=1 location=inside ; run; ods html close; ods listing; ods listing close; ods graphics / reset width=600px height=400px imagename='Fig 1_New' imagefmt=jpeg; ods html file='Surg.html' path='E:\HRM\Revised\Revised18_New' style=journal; /*ods html file='ap.html' path='C:\' style=journal; */ proc sgplot data=graphs; scatter X=Independent_Studies Y=MP / markerattrs=(color=blue symbol=CircleFilled size=8) name="scat" legendlabel="Motor Pattern"; series X=Independent_Studies Y=MP / lineattrs=(color=blue pattern=1) ; scatter X=Independent_Studies Y=BP / markerattrs=(color=red symbol=SquareFilled size=8) name="scat1" legendlabel="Body Pattern"; series X=Independent_Studies Y=BP / lineattrs=(color=red pattern=1) ; scatter X=Independent_Studies Y=OutOb / markerattrs=(color=green symbol=TriangleFilled size=8) name="scat2" legendlabel="Achalasia/ Outflow obstruction"; series X=Independent_Studies Y=OutOb / lineattrs=(color=green pattern=1) ; XAXIS TYPE = DISCRETE ; YAXIS LABEL = '% Accuracy' VALUES = (0 TO 100 BY 10); keylegend "scat" "scat1" "scat2" "scat4" / position=bottomleft across=1 location=inside ; run; ods html close; ods listing; ... View more

X axis labeling with two labels in same graph

by Obsidian | Level 7 in SAS Visual Analytics
‎09-13-2016 11:24 AM
‎09-13-2016 11:24 AM
Hi all, I am looking for help in creating graphs with two sets of labeling for X-axis. I am attaching my excel sheet, SAS code and the graphs  I had generated. Basicially I want two X-axis labeling (Independent Studies and Studies) in the same graph.    Thanks for all the help, Satish ods listing close; ods graphics / reset width=600px height=400px imagename='Fig 1' imagefmt=jpeg; ods html file='Surg.html' path='E:\HRM\Revised\Revised18_New' style=journal; /*ods html file='ap.html' path='C:\' style=journal; */ proc sgplot data=graphs; scatter X=Studies Y=MP / markerattrs=(color=blue symbol=CircleFilled size=8) name="scat" legendlabel="Motor Pattern"; series X=Studies Y=MP / lineattrs=(color=blue pattern=1) ; scatter X=Studies Y=BP / markerattrs=(color=red symbol=SquareFilled size=8) name="scat1" legendlabel="Body Pattern"; series X=Studies Y=BP / lineattrs=(color=red pattern=1) ; scatter X=Studies Y=OutOb / markerattrs=(color=green symbol=TriangleFilled size=8) name="scat2" legendlabel="Achalasia/ Outflow obstruction"; series X=Studies Y=OutOb / lineattrs=(color=green pattern=1) ; XAXIS TYPE = DISCRETE ; YAXIS LABEL = '% Accuracy' VALUES = (0 TO 100 BY 10); keylegend "scat" "scat1" "scat2" "scat4" / position=bottomleft across=1 location=inside ; run; ods html close; ods listing; ods listing close; ods graphics / reset width=600px height=400px imagename='Fig 1_New' imagefmt=jpeg; ods html file='Surg.html' path='E:\HRM\Revised\Revised18_New' style=journal; /*ods html file='ap.html' path='C:\' style=journal; */ proc sgplot data=graphs; scatter X=Independent_Studies Y=MP / markerattrs=(color=blue symbol=CircleFilled size=8) name="scat" legendlabel="Motor Pattern"; series X=Independent_Studies Y=MP / lineattrs=(color=blue pattern=1) ; scatter X=Independent_Studies Y=BP / markerattrs=(color=red symbol=SquareFilled size=8) name="scat1" legendlabel="Body Pattern"; series X=Independent_Studies Y=BP / lineattrs=(color=red pattern=1) ; scatter X=Independent_Studies Y=OutOb / markerattrs=(color=green symbol=TriangleFilled size=8) name="scat2" legendlabel="Achalasia/ Outflow obstruction"; series X=Independent_Studies Y=OutOb / lineattrs=(color=green pattern=1) ; XAXIS TYPE = DISCRETE ; YAXIS LABEL = '% Accuracy' VALUES = (0 TO 100 BY 10); keylegend "scat" "scat1" "scat2" "scat4" / position=bottomleft across=1 location=inside ; run; ods html close; ods listing; ... View more

Re: PROC GLM or PROC REG to get 95%CIs for independent variables

by Obsidian | Level 7 in Statistical Procedures
‎05-09-2016 02:54 PM
‎05-09-2016 02:54 PM
Thank you so much! ... View more

Re: PROC GLM or PROC REG to get 95%CIs for independent variables

by Obsidian | Level 7 in Statistical Procedures
‎05-09-2016 02:19 PM
‎05-09-2016 02:19 PM
Hi Rick, Thanks for the reply. I am getting the 95% CIs for the parameters, but when I assign the ref=option, I think it is not working. Ref=option should be highlighted in blue right? It is not in my code. Do I have any error? I use SAS 9.4.   Thanks, Sat proc glm data = ulcer; class ulcernew agecat1 Racecat(ref="Black") INCCAT1 INSURE MARRIED1 (ref="1") smoke1 backpain4 diabetes; model pcs36v2 = agecat1 Racecat INCCAT1 INSURE MARRIED1 smoke1 backpain4 diabetes ulcernew / solution ss3 CLPARM; run; quit;     ... View more

PROC GLM or PROC REG to get 95%CIs for independent variables

by Obsidian | Level 7 in Statistical Procedures
‎05-09-2016 01:06 PM
‎05-09-2016 01:06 PM
Hi all, I am working on a national database looking at continuous outcome and many independent predictors like age, race group, income category, insurance status, etc. So my predictors are a mix of  continuous and categorical variables. I need to check which of these variables are significant precitors and also get the 95% CIs for these predictors.   I used Proc GLM to test the association but I am finding difficulty in getting the 95% CIs for the independent predictors. I would appreciate if anyone can help me with this.   Also is there a way I can control the which category within a variables (eg. Race ) will be a reference category just like proc logistic? ods rtf; proc sort data = ulcer; by descending ulcernew descending agecat1 descending Racecat descending INCCAT1 descending INSURE descending MARRIED1 descending smoke1 descending backpain4 descending diabetes; run; * Multiple linear regression; proc glm data = ulcer order=data; class ulcernew agecat1 Racecat INCCAT1 INSURE MARRIED1 smoke1 backpain4 diabetes; model pcs36v2 mcs36v2 pf36 mh36 re36 rp36 sf36a vt36 = agecat1 Racecat INCCAT1 INSURE MARRIED1 smoke1 backpain4 diabetes ulcernew / solution ss3; run; quit; ods rtf close;   Thanks, Sat ... View more

Proc ARIMA for monthly trends

by Obsidian | Level 7 in SAS Procedures
‎03-16-2016 11:51 AM
‎03-16-2016 11:51 AM
Hi group, I have a monthly trend data (from Jan 2009 to Dec 2013, 5 years data reported as rates per 1000 each month) and I need to check for significance using PROC ARIMA. I DO NOT WANT FUTURE TRENDS OR FORECAST but I just need to check if there is a significant trend in the rates using PROC ARIMA. What sas codes/ command do I need to run? Any help with this is appreciated. I am attaching the excel data.   Thanks for your help, Satish ... View more

creating new categorical variable using Date variables

by Obsidian | Level 7 in SAS Procedures
‎02-15-2016 03:32 PM
‎02-15-2016 03:32 PM
Hi group, I have a data with Emergency Room visits with Room start date (datetime) and Room end dates. I also have labs for the patients captured as collection_date (datetime). I have to identify labs which were taken at ER using Room_Start_Date (datetime) and Room_End_Date (datetime). If labs were taken between Room_Start_Date and Room_End_Date, then they are considered labs_at_ER, which need to create a new categorical variable (yes/no). Can anyone please help me with the SAS codes to create this new variable? Note: all my date variables are in datetime format.   Thanks a lot, Satish ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-09-2017 09:35 AM
Likes given to
Quick links