About Ashwini_uci

Ashwini_uci · ‎03-09-2012

Sorry, i am not able to run the SQL query.. would you mind heloping me with the SQL syntax?

Ashwini_uci · ‎03-09-2012

Thanks for your reply, I got lot of warnings here. Now that i have never run a SQL query before, i am probably not doing it correctly, The nae of the variable is Gender and there are 2 levels. 1=female and 0= malem what do i plug in as "sex" one of the 2 levels? so here is how the SQl query looks like? proc sql; create table rates1000 as select gender, sex, 1000*sum(died)/count(died) from library.nismicathcabg4;group by gender, sex;

Ashwini_uci · ‎03-09-2012

I am attaching the tables below..they are the chi-square output . I have multiplied the the underlined and bold numbers (which are percentages) with 1000 to get a unadjusted rate per 1000. I intend to create a grapth for females and males using these unadjusted rates. Is it a right way to do it? I have never calculated the unadjusted rates before. Is there any other way or method or SAS code to obtain the unadjusted rate? Hope i am making sense, Thanks, Ashwini Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚6182.83 ‚ 724.06 ‚6906.89 ‚ 51.00 ‚ 5.97 ‚ 56.97 ‚ 89.52 ‚ 10.48 ‚ ‚ 56.98 ‚ 56.91 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚4667.86 ‚548.134 ‚ 5216 ‚ 38.50 ‚ 4.52 ‚ 43.03 ‚ 89.49 ‚ 10.51 ‚ ‚ 43.02 ‚ 43.09 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 10850.7 1272.19 12122.9 89.51 10.49 100.00 Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚70899.8 ‚2252.25 ‚73152.1 ‚ 69.33 ‚ 2.20 ‚ 71.53 ‚ 96.92 ‚ 3.08 ‚ ‚ 72.17 ‚ 55.93 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚27338.7 ‚ 1774.9 ‚29113.6 ‚ 26.73 ‚ 1.74 ‚ 28.47 ‚ 93.90 ‚ 6.10 ‚ ‚ 27.83 ‚ 44.07 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 98238.6 4027.15 102266 96.06 3.94 100.00 Frequency ‚ Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚8262.34 ‚430.063 ‚ 8692.4 ‚ 71.80 ‚ 3.74 ‚ 75.54 ‚ 95.05 ‚ 4.95 ‚ ‚ 75.72 ‚ 72.26 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚2650.08 ‚165.079 ‚2815.16 ‚ 23.03 ‚ 1.43 ‚ 24.46 ‚ 94.14 ‚ 5.86 ‚ ‚ 24.28 ‚ 27.74 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 10912.4 595.142 11507.6 94.83 5.17 100.00

Ashwini_uci · ‎03-09-2012

I am attaching the tables below..they are the chi-square output . I have multiplied the the underlined and bold numbers (which are percentages) with 1000 to get a unadjusted rate per 1000. I intend to create a grapth for females and males using these unadjusted rates. Is it a right way to do it? I have never calculated the unadjusted rates before. Is there any other way or method or SAS code to obtain the unadjusted rate? Hope i am making sense, Thanks, Ashwini Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚6182.83 ‚ 724.06 ‚6906.89 ‚ 51.00 ‚ 5.97 ‚ 56.97 ‚ 89.52 ‚ 10.48 ‚ ‚ 56.98 ‚ 56.91 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚4667.86 ‚548.134 ‚ 5216 ‚ 38.50 ‚ 4.52 ‚ 43.03 ‚ 89.49 ‚ 10.51 ‚ ‚ 43.02 ‚ 43.09 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 10850.7 1272.19 12122.9 89.51 10.49 100.00 Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚70899.8 ‚2252.25 ‚73152.1 ‚ 69.33 ‚ 2.20 ‚ 71.53 ‚ 96.92 ‚ 3.08 ‚ ‚ 72.17 ‚ 55.93 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚27338.7 ‚ 1774.9 ‚29113.6 ‚ 26.73 ‚ 1.74 ‚ 28.47 ‚ 93.90 ‚ 6.10 ‚ ‚ 27.83 ‚ 44.07 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 98238.6 4027.15 102266 96.06 3.94 100.00 Frequency ‚ Percent ‚ Row Pct ‚ Col Pct ‚ 0: Did ‚ 1: Died‚ Total ‚not die ‚ in hosp‚ ‚in hospi‚ital ‚ ‚tal ‚ ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0: Male ‚8262.34 ‚430.063 ‚ 8692.4 ‚ 71.80 ‚ 3.74 ‚ 75.54 ‚ 95.05 ‚ 4.95 ‚ ‚ 75.72 ‚ 72.26 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1: Female ‚2650.08 ‚165.079 ‚2815.16 ‚ 23.03 ‚ 1.43 ‚ 24.46 ‚ 94.14 ‚ 5.86 ‚ ‚ 24.28 ‚ 27.74 ‚ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 10912.4 595.142 11507.6 94.83 5.17 100.00

Ashwini_uci · ‎03-08-2012

Hi there, I am wondering abouthow to calculate the unadjusted rate in SAS. I want it in form of ##/1000 (number over 1000) What i have done is , is used the percentages that i got from proc freq and just multiplied it by 1000. But i am not sure if that is really a right way to do it. I am told that there is way in SAS to calculate the unadjusted rate. Does anyone know how to do it? Any help will be highly appreciated.. Thanks, Ashwini

Ashwini_uci · ‎03-06-2012

I have attached a file with proc logistic output with the convergence warning.. please have a look at it.

Ashwini_uci · ‎03-05-2012

ANy ideas about how to create a forest plot in SAS? or in Excel? Here is the data that i have to plot the forest plot This is how my plot looks like..

Ashwini_uci · ‎03-05-2012

Hi, How should I deal with this warning which i got after running the proc logistic regression? is there any way to get rid of this? How do I know by how much to increase the MAXITER or what value to put for FCONVE GCONVE etc. I have never used these options before. "Convergence was not attained in 25 iterations. You may want to increase the maximum number of iterations (MAXITER= option) or change the convergence criteria (ABSFCONV=, FCONV=, GCONV=, XCONV= options) in the MODEL statement." the code looks like... proc logistic data =library.nismicathcabg4 descending ; class female (ref= first) dm dmcx htn_c aids alcohol ANEMDEF arth race1(ref=first) ZIPINC_QRTL(ref=first) hosp_location h_contrl(ref=first) hosp_teach bldloss chf chrnlung coag depress drug hypothy liver lymph lytes mets neuro obese para perivasc psych pulmcirc renlfail tumor ulcer valve wghtloss cararrhythmia/param=ref; model died= age female dm dmcx htn_c aids alcohol ANEMDEF arth race1 zipinc_qrtl hosp_location h_contrl hosp_teach TOTAL_DISC prday1 bldloss chf chrnlung coag depress drug hypothy liver lymph lytes mets neuro obese para perivasc psych pulmcirc renlfail tumor ulcer valve wghtloss cararrhythmia ; where thrombolytic1=1 and stemi=0; weight discwt; title 'Logi Reg in-hosp mortality vs gender in POST-thrombolytic MI patients using "where" option with RACE +income for nstemi ncluding PRDAY1'; run; quit; File is attached with the proc logistic outout with convergence warning

Ashwini_uci · ‎03-05-2012

you are right! Actually only if the variables ahd 3 levels, then 3*3 table was possible.. but all these 3 varibales have 2 levels..Somehow i assumed that there are 3 levels and thus was trying to get a 3*3 tables. I guess iwill use the one i got by using proc freq.. 2 seprate tables controlled for each level of one of the 3 variables..same as what you have shown above. Thanks much for you help!!

Ashwini_uci · ‎03-05-2012

Hello, I am getting this note: Note: 645 observations were deleted due to missing values for the response or explanatory variables. after ruuning a proc logistic, The code likes this: proc logistic data =library.nismicathcabg4 descending ; class female (ref= first) dm dmcx htn_c aids alcohol ANEMDEF arth race1(ref=first) ZIPINC_QRTL(ref=first) hosp_location h_contrl(ref=first) hosp_teach bldloss chf chrnlung coag depress drug hypothy liver lymph lytes mets neuro obese para perivasc psych pulmcirc renlfail tumor ulcer valve wghtloss cararrhythmia/param=ref; model died= age female dm dmcx htn_c aids alcohol ANEMDEF arth race1 zipinc_qrtl hosp_location h_contrl hosp_teach TOTAL_DISC bldloss chf chrnlung coag depress drug hypothy liver lymph lytes mets neuro obese para perivasc psych pulmcirc renlfail tumor ulcer valve wghtloss cararrhythmia; where pcionly=1 and stemi=0; weight discwt; title 'Logi Reg in-hosp mortality vs gender in POST-PCI MI patients using "where" option with RACE +income for nonstemi with pcionly'; run; quit; I have checked all the variables for missing values and deleted the records that had missing values for all above mentioned explanatory variables,so the data is supposed to be complete... But i am not sure why i keep getting this note.. Any idea? any suggestions? Thanks much. Ashwini

Ashwini_uci · ‎03-05-2012

yeah, i tried the missing list option, that looks helpful too. Actually if the variables ahd 3 levels, then 3*3 table was possible.. but all these 3 varibales have 2 levels..Somehow i assumed that there are 3 levels and thus was trying to get a 3*3 tables. I guess iwill use the one i got by using proc freq.. 2 seprate tables controlled for each level of one of the 3 variables.. Thanks much for you help!!

Ashwini_uci · ‎03-05-2012

your examples has only 2 variables,, i am considering 3 variables in 3*3 table.. this is what i tried: proc tabulate data =library.nismicathcabg4; class pci cabg; var diagcath; tables pci*cabg diagcath*n; run; i tried various version of this code,i tried the tables syntax in different ways... but it didnot work.. ALL THESE 3 VARIABLES ARE CATEGORICAL WITH 2 LEVELS OF CODES.. 1 :YES, 2: NO Any idea about how this would work?

Ashwini_uci · ‎03-05-2012

this is 2*2 table, using proc freq pci*cabg... i want 3*3 table same as this one..for pci*cabg*diagcath; with n, colum and row percentages...is there any way to get this in SAS? In SPSS, you can just select as many variables as you want to crosstabulate.... i am not sure how to get it in SAS. pci cabg Frequency‚ Percent ‚ Row Pct ‚ Col Pct ‚ 0‚ 1‚ Total ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 0 ‚ 34216 ‚ 7879 ‚ 42095 ‚ 41.64 ‚ 9.59 ‚ 51.23 ‚ 81.28 ‚ 18.72 ‚ ‚ 46.05 ‚ 100.00 ‚ ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ 1 ‚ 40078 ‚ 0 ‚ 40078 ‚ 48.77 ‚ 0.00 ‚ 48.77 ‚ 100.00 ‚ 0.00 ‚ ‚ 53.95 ‚ 0.00 ‚ ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ Total 74294 7879 82173 90.41 9.59 100.00

Ashwini_uci · ‎03-05-2012

this is what it looks like: proc tabulate data =library.nismicathcabg4; class pci cabg; var diagcath; tables pci*cabg diagcath*n; run; i tried various version of this code,i tried the tables syntax in different ways... but it didnot work.. ALL THESE VARIABLES ARE CATEGORICAL WITH 2 LEVELS OF CODES.. 1 :YES, 2: NO Any idea about how this would work?

Ashwini_uci · ‎03-05-2012

I tried with proc freq: but it did not give me the 3*3 tables, it gave 2 separate tables controlling for each category of one variable: The SAS code is as follows: I just want a single 3*3 cross table.. with n or percentages. proc freq data =library.nismicathcabg4; tables pci*cabg*diagcath; run;

Online Status	Offline
Date Last Visited	‎04-25-2018 11:32 PM

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Keeping leading 0 while converting from character to numeric

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Non parametric Cuzick test for trend in SAS

Re: DO Loop and ARRAY

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Keeping leading 0 while converting from character to numeric

Unadjusted rate

Unadjusted rate

Unadjusted rate

Unadjusted rate

Unadjusted rate

Convergence warning after running proc logisitc

Forest plot

Convergence warning after running proc logisitc

How to use proc tabulate in making 3*3 tables

Missing values note after running proc logistic

How to use proc tabulate in making 3*3 tables

How to use proc tabulate in making 3*3 tables

How to use proc tabulate in making 3*3 tables

How to use proc tabulate in making 3*3 tables

How to use proc tabulate in making 3*3 tables