cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Paul_NYS
‎10-05-2016
  • 216 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: Merging two data sets and dups

by Obsidian | Level 7 in SAS Programming
‎12-10-2014 12:06 PM
‎12-10-2014 12:06 PM
Dups in the original perm_ev data set are fine, so de-duping the original data set would not help. I just want to add the two new columns based on the entity_id 'by' variable. Paul ... View more

Re: Merging two data sets and dups

by Obsidian | Level 7 in SAS Programming
‎12-10-2014 12:04 PM
‎12-10-2014 12:04 PM
No, not necessarily. There are duplicates in the original perm_ev set, which is fine. The problem is that the perm_ev data set has 216,526 records and the merged data set permev1 has 216,720 records. Records like the one I already included were created in the merge. I just want to add the above two columns (DispOutcome1 DispoDate) from nyccust to the records in the perm_ev data set and that's it. Paul ... View more

Merging two data sets and dups

by Obsidian | Level 7 in SAS Programming
‎12-10-2014 11:16 AM
‎12-10-2014 11:16 AM
Hi Everyone I am merging two data sets using the below data step. I am seeing some instances of duplicate records being created and I don't understand why it is happening. Is there something I forgot in this or is there a reason why this is happening? I am also including an example of the dup records. One other item, is there a way to create a de-duped dataset? Using proc sort with nodupkey and dupout would require using all the variables in the dataset, I assume. Paul Code: data permev1; merge perm_ev (in=a) nyccust (keep=entity_id DispOutcome1 DispoDate); if a; by entity_id; run; Dup records: 21560655    222238    22    1    14JUL2011    12SEP2011    .    .    12SEP2011    .    .    .    .    .    14JUL2011    .    25APR2012    25APR2012    XRF    Permanency Tracking Completed   XUK   PERM ONLY    XUK    30JAN2014    Order of Custody Continued 21560655    222238    22    1    14JUL2011    12SEP2011    .    .    12SEP2011    .    .    .    .    .    14JUL2011    .    25APR2012    25APR2012    XRF    Permanency Tracking Completed   XUK   PERM ONLY    XUK    30JAN2014    Order of Custody Continued ... View more

Data set merge

by Obsidian | Level 7 in SAS Programming
‎11-14-2014 07:15 AM
‎11-14-2014 07:15 AM
Hi I am  trying to merge two data sets (something I have done 500 times). The field I am trying to add to the first from the second is not copying correctly in that the values are not matching correctly based on the 'by' variable. I have tried it several different ways and nothing seems to work. Anyone see anything? Its the AppearCount variable that I want to add and the values for it are not matching. Also the second data set (appearances2bt1) is actually a subset of the first. Paul proc sort data=appearances2b; by docket_id; run; proc sort data=appearances2bt1; by docket_id; run; data AppearanceAttendDen; length EventType $ 50; merge appearances2b (in=a) appearances2bt1 (keep=docket_id AppearCount); if a; by docket_id; if event in ("AAD","AHR","ACT","AIQ","ANE","ANH","ACD","AHY","ASJ") then EventType="Adjudication"; if event in ("DDD","DRR","DPP","DTP","DAJ","DSP","DDS","DOR", "DWD") then EventType="Disposition"; if event in ("XCA","XRF","XRL","XGA","XAP","XRM","XOT") then EventType="Exit"; if event in ("PHR","PHC") then EventType="PermanencyHearing"; drop AGEOUT IY NYC FCOUNT OCOUNT SCOUNT TCOUNT PCOUNT HCOUNT DURCAT_ADJUD_DISPO1 DURCAT_ADJUD1 DUR_PL1 DURCAT_PL1 PLACE_CAT1 TADJUD_FLAG CENSOR_TADJUD1 CENSOR_TADJUD1 DURCAT_TADJUD_TDISPO1 DURCAT_TADJUD_TDISPO1 durmod durmod_cat state link ageout count fcount_notpr place_end1 help durmoa durmoa_cat exit_pl1 stop_pl1 place1y; run; ... View more

Re: Proc Means for determining number of observations within segments ...

by Obsidian | Level 7 in SAS Procedures
‎10-06-2014 08:47 PM
‎10-06-2014 08:47 PM
I don't have SAS with me now, but I think Proc Univariate could work. I am trying to segment a data set (population) into smaller sub-populations based on the time (in days) it takes to achieve adjudication. The population divisions would be percentages of the population who achieved adjudication the fastest: 10%, 25%, 50%, 75%, 90%. I need to know which time represents each of these points and then subdivide the population observations into each segment: 0-10, 11-25, etc. So Proc Univariate appears to be a way to at least identify the observations that represent each percentile. Then I would assume I could segment the population using these values. Paul ... View more

Proc Means for determining number of observations within segments of a...

by Obsidian | Level 7 in SAS Procedures
‎10-06-2014 06:15 PM
‎10-06-2014 06:15 PM
Hi Everyone I would like to determine the number of observations that fall within 10, 25, 50, 75, 90% of a population. I thought that a Proc Means statement would do this since I use it to calculate quartiles. However I was wondering if this was the case? Variations of the below Proc Means do not seem to work. Paul proc means data=test1 noprint missing; var TprFilingToIssueJoined; by County TprFileYear; output out=tprpercents n= nmiss= p10 p25 p50 p75 p90 p95 /autoname; run; ... View more

Re: simple use of 'if' and 'missing' in data step

by Obsidian | Level 7 in SAS Programming
‎10-03-2014 09:07 AM
‎10-03-2014 09:07 AM
Thank you Kurt!! I am so stupid. Thanks again! Paul ... View more

simple use of 'if' and 'missing' in data step

by Obsidian | Level 7 in SAS Programming
‎10-03-2014 08:55 AM
‎10-03-2014 08:55 AM
Hi Everyone I have a very simple issue that I don't understand what the problem is. I have a data step that uses two 'if' statements and 'missing' to detect if another variable is present or not and populate another variable with a 'y' or 'n' flag based on this. When I run this, the 'conferenced' variable always comes out 'n' when this is clearly not the case: there are many instances of 'ConfDate' having a date populated. Is there something really simple I am missing? Paul data tendayconf4 (rename=(cnty_name=County docno1=Docket start=PlaceStart stop=PlaceStop durat=TimeInCare filing1=FilingDate adjud1=AdjudDate dur_adjud1=FilingToAdjud dispo1=DispoDate dur_dispo1=FilingToDispo issuejoindate=IJDate appearance_date=ConfDate IjDateConfDate=IJDateToConfDate Col3=Part)); length cnty_name $ 50 docno1 $ 20 CohortYear 4 start 8 stop 8 Status $ 50 durat 8 filing1 8 adjud1 8 dur_adjud1 8 dispo1 8 dur_dispo1 8 issuejoindate 8 appearance_date 8 IjDateConfDate 8 Col3 $ 50; set tendayconf3; if missing(ConfDate) then Conferenced="N"; if not missing(ConfDate) then Conferenced="Y"; run; ... View more

Re: Merging two data sets and non-matched records

by Obsidian | Level 7 in SAS Programming
‎08-29-2014 12:30 PM
‎08-29-2014 12:30 PM
That will get me only those records in both record sets, I am presuming? The below will get me the records that match on Id overlaying each other and will append those that don't? data combine; merge first second; by Id; run; Paul ... View more

Merging two data sets and non-matched records

by Obsidian | Level 7 in SAS Programming
‎08-29-2014 11:51 AM
‎08-29-2014 11:51 AM
Hi When combining two data sets with the same variables using Data/Merge and a By statement, the records that don't match on the variables in the By statement are just appended to the data set? Paul ... View more

Re: Comparing dates in SAS

by Obsidian | Level 7 in SAS Programming
‎06-13-2014 02:02 PM
‎06-13-2014 02:02 PM
Yes, that's fine. I didn't know dates were just a display. Thanks a lot (again)! Paul ... View more

Re: Comparing dates in SAS

by Obsidian | Level 7 in SAS Programming
‎06-13-2014 10:21 AM
‎06-13-2014 10:21 AM
Thank you both--that worked. However, my format statements preceding the comparison statement both reference a date format of mm/dd/yyyy (format filing1 mmddyy10.;). This apparently is not an issue? Paul ... View more

Comparing dates in SAS

by Obsidian | Level 7 in SAS Programming
‎06-13-2014 09:39 AM
‎06-13-2014 09:39 AM
Hi I am trying to determine if the dates in a variable are GE a specific date value and LE another date value (in bold). I have tried variations of the below and keep getting errors. Any syntax ideas? data s1suffolkpre; set s1; if cnty_name="Suffolk"; format start mmddyy10.; format stop mmddyy10.; format filing1 mmddyy10.; if filing1 ge '01/01/2008'd and filing1 le '12/31/2009'd; end; Paul ... View more

Re: Syntax for 'in' and 'keep' statements

by Obsidian | Level 7 in SAS Programming
‎04-17-2014 12:44 PM
‎04-17-2014 12:44 PM
Thanks Ballard. Thats it. Paul ... View more

Syntax for 'in' and 'keep' statements

by Obsidian | Level 7 in SAS Programming
‎04-17-2014 12:28 PM
‎04-17-2014 12:28 PM
Hi I have tried every variation that I can think of for a combined 'keep' and 'in' statements (below in bold) for one data set in a merge function and can't seem to get it to run. Anyone done this prior? Paul data courtevents1ee (rename=judge_entity_id=agecat4); length judge_entity_id 8; merge s1 (keep=start stop exit entity_id durat gender spellage docket1 (in=a)) courtevents (keep=entity_id edate judge_entity_id judge_type ucms_table); by entity_id; if a; format start mmddyy10.; format edate mmddyy10.; format stop mmddyy10.; if edate ge start; if edate le stop; if ucms_table="APPEARANCE"; /*if exit ne "ZTC" then do; if edate le stop; end; */ if not missing(judge_entity_id); count=1; drop agecat4 ucms_table; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-05-2016 02:57 PM
Likes from
Quick links