Sorry about the "red cell" reference. I had highlighted those columns
in red cells in excel. Also I notices that the formating changed a bit
after the message was sent. Here is an example of what the data should
look like (using the first dat entry).
ID (21211), concurrent (N), schlname (WTYZ), startdate(11-Mar-2005),
exitcode(W5),include1 (1) include2 (0), include3(0), include4(0),
dropout1(0), dropout2(0), dropout3(0), dropout4(0), include final
status(?), dropoutfinal status(?).
As I said in the main email, include and dropout variables which
indicates which school should take ownership of the student and range
from 1-any number of times the student (id) moves from one school to
I will very much appreciate your help. I tried pasting th data in its
format to the email but it ends up being reformatted.
The code should be able to populate the "?' fields with each student
movement and based on exitcode.
Gerhard Hellriegel wrote:
> Perhaps a little help to understand it: what is meant by "red cells"? I
> can't see no colors here. Maybe formatted with another font? Or marked with
> some ***'s?
> On Mon, 16 Oct 2006 09:04:27 -0700, Forstero <Forstero@GMAIL.COM> wrote:
> >Please can yanyone help me with a SAS code that converts character date
> >variable such as 2004-08-04 into numeric variable?
> > A much tougher problem. I am in the process of calculating dropout
> >rates for different school in the state.The data is at student level
> >data but some of the students are concurrently enrolled in more than
> >one school within the same school year. They are assigned different
> >exitcodes each time they leave a school and this exitcodes determine
> >which school I have to include the student in my calculation.
> >For example: student 1 has 3entries in my record because he starts on
> >March 11th 2005 at school A, withdrew on July 12th 2005(exitcode W5
> >which is transferred out), and on July 29 2005 starts at school B and
> >same time is is also in school school C's record. His exitcodes in
> >school's B and C are W1 and P respectively, meaning he tranfered from
> >school B and passed from school C.
> >My problem is that I am supposed to write a program that keeps track of
> >this movement and assigns vales to the include and drop out categories
> >which is populated with each movement.(see attached spreadsheet). This
> >code should be able to overide previous determination assigned to
> >previuosly attended school depending on the later exit code. Final
> >include status is supposed to be the school with the last include code
> >of 1 and same is the case with final dropout status. Dropout rate in
> >the ratio of final dropout rstatus to final include status. Can you
> >please help me out with a workable code.
> >I will so much appreciate ANY form of assistance I can get from you in
> >this regard.
> >Forster OKoli
> > ID cconcurret schname startdate exitcode
> >include1 include2 include3 include4 dropout1 dropout2
> >dropout3 dropout4 include final status dropout final
> >21211 N WTYZ 11-Mar-2005 W5 1 0 0 0
> 0 0 0 0 ?
> > ?
> >21211 Y AZBD 29-Jul-2005 W1 0 0 0 0
> 0 1 0 0 ?
> > ?
> >21211 Y FESY 29-Jul-2005 P 0 1 1 0
> 0 1 0 0 ?
> >21222 N WSDE 4-May-2006 W2
> >21223 N WBTF 4-Apr-2006 SE
> >21233 N EDS 2-Feb-2006 W4
> >21234 N QWER 4-Mar-2006 S12
> >**** Please note The code should be able to populate the red cells or
> >fields with each student movement and based on exitcode.