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: 
Ecolife
‎07-01-2018
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Consulation for Models comparison

by Fluorite | Level 6 in Statistical Procedures
‎06-09-2018 02:40 AM
‎06-09-2018 02:40 AM
Thanks for your kindly reply! However, not sure how to apply the risk equation:  risk_score = 0.0634*age + 0.0897 *m_b_hbA1C + 0.5314*log10( m_U_ACR) 5_year_probability = 1-0.9707**(Risk_Score-4.5674) into my dataset to look into the c-statistics and ROC curve for this equation? Looking forward your kindly reply ... View more

Consultation for Models comparison

by Fluorite | Level 6 in Statistical Procedures
‎06-08-2018 02:16 AM
‎06-08-2018 02:16 AM
Hi everyone! This is Kelly and I need someone's help>"< Currently, I am working on developing a risk equation for diabetes and stroke. After I got my equation through cox-regression(proc phreg) and also there were roc curve and c -statistics. However, I would like to compare my equation to other equations which have been published to see whether my equation is more precise. That is, I would like to ask if there any procedure to use my cohort to test the existed model to calculate c-statisitcs?   Attachment is the study method I found may be similar to mine. The author mentioned using SAS, however, not sure what procedure did they use................   Kindly give advise to me...........Thanks a lot!   Sincerely, Kelly   ... View more

Re: Cannot import excel to SAS

by Fluorite | Level 6 in SAS Programming
‎05-02-2018 10:07 AM
‎05-02-2018 10:07 AM
It's also a great solution. Thanks a lot! ... View more

Re: Cannot import excel to SAS

by Fluorite | Level 6 in SAS Programming
‎05-02-2018 10:07 AM
‎05-02-2018 10:07 AM
It still doesn't work with the import wizard. My SAS version is 9.4, and my excel version is 64-bit 2016 office365(provided from my school...) ... View more

Re: Cannot import excel to SAS

by Fluorite | Level 6 in SAS Programming
‎05-02-2018 09:23 AM
‎05-02-2018 09:23 AM
Thanks for your great help! It works since I changed DBMS=excel to xlsx... However, I still can't use import wizard to import my excel data...It seems that I should import them manually QQ ... View more

Re: Cannot import excel to SAS

by Fluorite | Level 6 in SAS Programming
‎05-02-2018 08:59 AM
1 Like
‎05-02-2018 08:59 AM
1 Like
PROC IMPORT DATAFILE="d:\icd9.xlsx" DBMS=EXCELCS OUT=WORK.test REPLACE; RUN; I have tried EXCELCS and EXCEL but there are in the same result. ... View more

Cannot import excel to SAS

by Fluorite | Level 6 in SAS Programming
‎05-02-2018 08:12 AM
‎05-02-2018 08:12 AM
Hi, This is Kelly and is my first time to post my question here... The problem is that I couldn't import my excel to SAS...and I have checked the version of excel and it is excel 2016 64bit(office 365) and my PC is also X64 processor. The error still shows:" Connect: Class not registered. Error in the LIBNAME statement." after I tried most solutions...including installing PC server and SAS re-installation.  I have done the flowchart for troubleshooting: http://support.sas.com/kb/60/356.html#mdd-connect, and it says I should consult the technical support. Is there any further instruction for solving this problem? Or where should I ask for help?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-01-2018 04:49 AM
Likes given to
View All
Likes from
View All
Quick links