Hi , Please help in converting character variable (Start Date) to date format (mm/dd/yyyy). I have given an example below Start date $ 11/1/2009 0:00:00 4/2/2009 0:00:00 26/1/2009 0:00:00 26/11/2009 0:00:00 26/11/2009 12:00:00 AM 1/11/2009 0:00:00 1/11/2009 12:00:00 AM Thank you for your help
... View more
thank you Dale,
estimate for intercept is 0.2970 and it is not significant, so i thought i will drop it, as i have not made any hypo for intercept.
i rerun the model without intercept using "noint" option in model statement in proc logistic., all 10 variables are significant, However Concordance is .992 which good but very high ;-( ie area under ROC is 99.2%
and Hosmer and Lemeshow Goodness-of-Fit Test has Chi sq value of 4982.9039 with p <.0001
how to get is insignificant
... View more
i am running a logistic regression for agent data. i have 15 variables and 5000 obs.
after data treatment steps, in logistic regresion i am getting 10 variables as significant with p > 0.001, where as intercept has value p value 0.3150.
what would be d reason for intercept being non significant.
Hosmer and Lemeshow Goodness-of-Fit Test is showing significance, so overall model is not a good fit.
please advice me
... View more
Thank you :-), now i have created dummy variables for the class variables, i will use them in clustering without standardizing.
however i have some outliers in 2 variables (1 continuous variable and 1 discrete variable), so do i need to do the outlier treatment first or stadadrization first.
... View more
hi,
I have 2 questions in my mind, can anyone help me on it.
1. Is it necessary to create dummy variables in cluster analysis? if yes
2. Do we need to standardize dummy variables along with other continuous variables to get ride of different measuring units
Thanks
... View more
try these codes
data Week2_1 (drop = DATE ARRIVAL DEPART);
set Week2;
DATE_1 = input(DATE, ANYDTDTE10.);
format DATE_1 date9.;
ARRIVAL_1 = input(ARRIVAL, anydttme8.);
format ARRIVAL_1 time8.;
DEPART_1 = input(DEPART, anydttme8.);
format DEPART_1 time8.;
run;
data Week2_2;
set Week2_1;
rename
DATE_1 = DATE
ARRIVAL_1 = ARRIVAL
DEPART_1 = DEPART;
run;
Data new;
set Week1 Week2_2; /* u r trying to append 2 files not merge right?*/
run;
so now data set new should have all the observations
... View more
Hi,
Use Proc contents to get the list of variables, then use below sql code, which creates new SAS table called sample_t from exitsing sample table, with variables in the order u mentioned in select statement
proc sql ;
create table sample_t as
select a1, a2, a3, a4,........a10, a11
from sample;
quit;
... View more