About Jessica98

Jessica98 · ‎11-21-2014

Hi , the code works brilliantly, i am trying to learn what you have done. I notice there is one small error, let me know what you think about it. For the output that i have obtained below, for ID 68 and & 72 it is "0" for mon1 & mon6 (underlined below) where it should have been "1" . There is one instance like this for all ID's. Any idea why? ID year month months_continuous bef_3months aft_12_months mon_3 mon_2 mon_1 mon0 mon1 mon2 mon3 mon4 mon5 mon6 mon7 mon8 mon9 mon10 mon11 mon12 mon13 mon14 mon15 mon16 mon17 mon18 mon19 mon20 mon21 mon22 mon23 68 2009 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 8 8 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 9 9 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 10 10 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 11 11 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 1 13 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 2 14 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 3 15 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 4 16 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 5 17 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 6 18 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 7 19 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 8 20 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 9 21 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 10 22 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 68 2010 11 23 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 72 2009 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 3 3 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 4 4 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 5 5 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 6 6 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 7 7 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 8 8 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 9 9 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 10 10 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 11 11 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 1 13 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 2 14 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 3 15 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 4 16 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 5 17 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 72 2010 6 18 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0

Jessica98 · ‎11-19-2014

Hi , thanks a lot! So far i am getting three columns with dummy's indicating bef_3months like this, id year month months_continuous bef_3months aft_12months mon__3 mon__2 mon__1 68 2009 1 1 0 0 0 0 0 68 2009 2 2 0 0 0 0 0 68 2009 3 3 0 0 0 0 0 68 2009 4 4 0 0 0 0 0 68 2009 5 5 0 0 0 0 0 68 2009 6 6 0 0 0 0 0 68 2009 7 7 0 0 0 0 0 68 2009 8 8 1 0 1 0 0 68 2009 9 9 1 0 0 1 0 68 2009 10 10 1 0 0 0 1 68 2009 11 11 0 1 0 0 0 68 2010 1 13 0 1 0 0 0 68 2010 2 14 0 1 0 0 0 68 2010 3 15 0 1 0 0 0 68 2010 4 16 0 1 0 0 0 68 2010 5 17 0 1 0 0 0 68 2010 6 18 0 1 0 0 0 68 2010 7 19 0 1 0 0 0 68 2010 8 20 0 1 0 0 0 68 2010 9 21 0 1 0 0 0 68 2010 10 22 0 1 0 0 0 68 2010 11 23 0 1 0 0 0 72 2009 1 1 0 0 0 0 0 72 2009 2 2 0 0 0 0 0 72 2009 3 3 1 0 1 0 0 72 2009 4 4 1 0 0 1 0 72 2009 5 5 1 0 0 0 1 72 2009 6 6 0 1 0 0 0 72 2009 7 7 0 1 0 0 0 72 2009 8 8 0 1 0 0 0 72 2009 9 9 0 1 0 0 0 72 2009 10 10 0 1 0 0 0 72 2009 11 11 0 1 0 0 0 72 2010 1 13 0 1 0 0 0 72 2010 2 14 0 1 0 0 0 72 2010 3 15 0 1 0 0 0 72 2010 4 16 0 1 0 0 0 72 2010 5 17 0 1 0 0 0 72 2010 6 18 0 1 0 0 0 what i want is similar dummy's for aft_months as well (see below), here i need twelve variables similar to the three generated earlier. Like this, can i change the code to get that? id year month months_continuous bef_3months aft_12months mon__3 mon__2 mon__1 mon__2 mon__3 mon__4 mon__5 mon__6 mon__7 mon__8 mon__9 mon__10 mon__11 mon__12 mon__13 68 2009 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 8 8 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 9 9 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 10 10 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 11 11 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 68 2010 1 13 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 68 2010 2 14 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 68 2010 3 15 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 68 2010 4 16 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 68 2010 5 17 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 68 2010 6 18 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 68 2010 7 19 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 68 2010 8 20 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 68 2010 9 21 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 68 2010 10 22 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 68 2010 11 23 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 72 2009 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 3 3 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 4 4 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 5 5 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 72 2009 6 6 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 72 2009 7 7 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 72 2009 8 8 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 72 2009 9 9 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 72 2009 10 10 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 72 2009 11 11 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 72 2010 1 13 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 72 2010 2 14 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 72 2010 3 15 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 72 2010 4 16 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 72 2010 5 17 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 72 2010 6 18 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1

Jessica98 · ‎11-18-2014

Hi, here is my code, I just want to say that the name of my 'ID' is 'driver_id' , will that make any difference? coz i dont see any ref to that in the code. proc sort data=data; by year month_continuous; run; data temp; set data; retain flag 1 n -4; if before_3months = 1 or after_12months = 1 then do;n+1;output;end; run; proc transpose data=temp out=temp1(drop=_:) prefix=mon_; by continuous ; var flag; id n; run; data temp2; merge data temp1; by month_continuous; run; proc stdize data=temp2 missing=0 out=want reponly;run;

Jessica98 · ‎11-18-2014

hi , i ran the code.i think by looking at the code you got my logic. However i got this error " Data set WORK.TEMP is not sorted in ascending sequence. The current BY group has months_continuous = 23 and the next BY group has months_continuous= 3." i tried sorting the temp data set by months_continuous, it did not help. any suggestions? -jessica wolfman

Jessica98 · ‎11-18-2014

i AM NEW TO SAS, I DONT HAVE A GOOD UNDERSTANDING OF ARRAYS. keshan, did you get my logic?

Jessica98 · ‎11-17-2014

My logic is simple. I want a dummy for each month before three months(t-3) and after 12 months (0-11) of an individual s bday. I have the dummy indicating that. But I would need one dummy variable for each month. Basically for each individual has his bday month for example individual ID 68 has his bday in the 11th month 2009. , I want to create three dummy variable for three months before that (t-3,t-2,t-1) and 12 dummy variables(t0...t+11) representing each month after bday month.

Jessica98 · ‎11-16-2014

Hi guys, I need some help creating dummy variables for a dataset, can someone help with a simple SAS code? the data sample looks like this, i have given what i have and what i want as my output. I need monthly dummy's. please note that this is just a sample, i have data with many ID's, here i have given only one. have want ID year month months_continuous bef_3months aft_12_months ID year month months_continuous bef_3months aft_12_months month_-3 month_-2 month_-1 month_+0 month_+1 month_+2 month_+3 month_+4 month_+5 month_+6 month_+7 month_+8 month_+9 month_+10 month_+11 68 2009 1 1 0 0 68 2009 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 2 2 0 0 68 2009 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 3 3 0 0 68 2009 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 4 4 0 0 68 2009 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 5 5 0 0 68 2009 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 6 6 0 0 68 2009 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 7 7 0 0 68 2009 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 8 8 1 0 68 2009 8 8 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 9 9 1 0 68 2009 9 9 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 10 10 1 0 68 2009 10 10 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 68 2009 11 11 0 1 68 2009 11 11 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 68 2010 1 13 0 1 68 2010 1 13 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 68 2010 2 14 0 1 68 2010 2 14 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 68 2010 3 15 0 1 68 2010 3 15 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 68 2010 4 16 0 1 68 2010 4 16 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 68 2010 5 17 0 1 68 2010 5 17 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 68 2010 6 18 0 1 68 2010 6 18 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 68 2010 7 19 0 1 68 2010 7 19 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 68 2010 8 20 0 1 68 2010 8 20 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 68 2010 9 21 0 1 68 2010 9 21 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 68 2010 10 22 0 1 68 2010 10 22 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 68 2010 11 23 0 1 68 2010 11 23 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 -jessica wolfman

Jessica98 · ‎06-12-2014

sorry about that, i have marked it.

Jessica98 · ‎06-12-2014

I got it guys! thanks a lot.

Jessica98 · ‎06-12-2014

i have done the sorting, it says "Variable FIRST.id is uninitialized" . I have a very simple code, DATA data_1 ; SET data; IF first.id then delete; run;

Jessica98 · ‎06-12-2014

Hi i did try this, if first.id then delete; but it does not work, am i doing anything wrong? jessica

Jessica98 · ‎06-12-2014

Hi guys, I need some help with a code to delete the first row using unique ID, this is my data ID month day income 1 1 1 20 1 1 2 40 1 3 1 21 1 3 2 56 1 3 3 54 1 4 4 23 4 1 1 5 4 1 2 3 4 2 3 4 4 2 4 5 4 3 5 65 6 2 1 86 6 2 2 34 6 3 3 23 9 7 1 65 9 7 2 54 9 8 3 99 9 8 4 12 9 8 5 33 9 9 6 65 9 9 7 23 13 1 1 12 13 2 2 65 13 2 3 32 I want to delete the rows marked in red, that is the first row of each unique ID, any ideas? Jessica

Jessica98 · ‎05-30-2014

Hi Scott, This i could use if i want to remove ID's that have only one row, but i need to have a condition which says , if one particular ID has less than 3 rows (i.e repeated thrice in the ID column) then i want the ID and its associated rows out of the sample. jessica

Jessica98 · ‎05-30-2014

Hi guys, I have a very big dataset, i know hoe to delete rows based on certain values, but i want to know how to delete specific rows. For example take the following table below, ID time income 1 1 .. 1 2 .. 1 3 .. 2 1 .. 2 2 .. 2 3 .. 3 1 .. 4 1 .. 4 2 .. 4 3 .. 5 1 .. 6 1 .. 6 2 .. 6 3 .. I want to be able to delete rows where ID has only one time value, i.e if driver_id occurs only once in the data, i want to delet that row! please advice! jessica

Jessica98 · ‎05-22-2014

thanks a lot! that works perfectly!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Creating dummy variables

Re: Deleting first row using ID

Re: Deleting first row using ID

Re: Deleting first row using ID

Re: Deleting first row using ID

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Re: Creating dummy variables

Creating dummy variables

Re: Deleting first row using ID

Re: Deleting first row using ID

Re: Deleting first row using ID

Re: Deleting first row using ID

Deleting first row using ID

Re: Deleting single ID rows

Deleting single ID rows

Re: How to find the cumulative mean with classification for groups