Displaying 2 results from an estimated 2 matches for "appt_typ_cd_ll".
2013 Apr 26
1
Stratified Random Sampling Proportional to Size
...100.
Below is my r code showing what I did and the error I'm getting with sampling::strata
# FIRST I summarized count of records by the two variables I want to use as strata
Library(RODBC)
library(sqldf)
library(sampling)
#After establishing connection I query the data and sort it by strata APPT_TYP_CD_LL and EMPL_TYPE and store it in a dataframe
CURRPOP<-sqlQuery(ch,"SELECT APPT_TYP_CD_LL, EMPL_TYPE,ASOFDATE,EMPLID,NAME,DEPTID,JOBCODE,JOBTITLE,SAL_ADMIN_PLAN,RET_TYP_CD_LL FROM PS_EMPLOYEES_LL WHERE EMPL_STATUS NOT IN('R','T') ORDER BY APPT_TYP_CD_LL, EMPL_TYPE")
#ROWID...
2012 Oct 16
2
List of Levels for all Factor variables
...: int 431108 32709 19730 10850 48786 2004 237628 558 3423 743175 ...
$ NAME : Factor w/ 6402 levels "Aaron Cathy E",..: 2777 242 161 104 336 4254 1595 1244 3669 4760 ...
$ TRAIN : int 1 1 1 1 1 1 1 1 1 1 ...
$ TARGET : int 0 0 0 0 0 0 0 0 0 0 ...
$ APPT_TYP_CD_LL : Factor w/ 3 levels "FX","IN","IP": 2 2 2 2 2 2 2 2 2 2 ...
$ ORG_NAM_LL : Factor w/ 18 levels "Business","Chief Financial Officer",..: 11 7 7 9 4 4 18 18 8 4 ...
$ NEW_DISCIPLINE : Factor w/ 15 levels "100s","300s",..: 1...