Hi, I'm trying to determine an id's status based on if they have had any activity in the past 3 months. My data is a log of all activity and looks like: id LogIn 1 01Jan11 1 03Jan11 1 04Mar11 2 27Jan11 2 22Feb11 ... I want to be able to structure my data so it looks like the following: id LogIn Status 1 01Jan11 Active 1 03Jan11 Active 1 04Mar11 Active 2 25Dec10 Inactive 2 27Jan11 Inactive ... I think i need a function that checks whether or not the id has a Login date in the past 3 months, if yes, then status for id is set to Active. I'm pretty sure it has to be a separate dataset to do the calculations then do a Merge to the main file. Thanks in advance for your help! ... View more

Hi, I have a file with id's and activity: id activity 1 2 1 5 2 1 3 2 4 1 4 4 What i want to do is create a dataset with the sum of the activity by ids (just want unique ids) so it'd look like the following: id activity 1 7 2 1 3 2 4 5 Thanks all for your help! ... View more

Hi, This is a slightly complex merge i'm having trouble with. File1: contains Postalcode and City - main file i'd like to attach a Segment to. File2: contains PostalCode, City, Segment File3: contains PostalCode, Segment 1. I need to merge Segment to File1 with File2 by PostalCode AND (sounds like) City 2. For everyone that DID NOT match up with File2 I would need to match up with File3 by PostCode only. 3. My final file should be the base of File1 containing PostalCodes, City and Segment Thanks for your help! ... View more

Hi, I'm using proc format as: VALUE $ProvFmt 'P1' ='ON' 'P2' ='BC' 'P3' ='AB' 'P4' ='MB' 'P5' ='SK' 'P6' ='QC' 'P7' ='NS' 'P8' ='NB' 'P9' ='NL' 'P10'='PE' 'P11'='NT' 'P12'='YK' 'P13'='NU' when I run frequencies on my data, the output goes in the order of ON BC AB MB SK QC NS NB NL PE NT YK NU How do I change my statement so the ouput goes in the following order: BC AB SK MB ON QC NB NS NL PE NT YK NU Thanks for your help! ... View more

Hi, I have a question about data step logic. I have a file of user activity by month/year. id month activity 0001 01Jan09 4 0001 01Mar09 3 0001 01Jul09 1 0002 01Feb09 2 0002 01Apr09 2 0003 01Dec10 3 ... Notes: 1. file only shows activity by month by id, so if id was inactive then activity = 0 for that month (i.e for 0001 activity =0 for Feb, Apr, May etc..) 2. Data goes back to 2007 to current month What I want to achieve is a data set that will fill in the inactive holes for all ids. id month activity 0001 01Jan09 4 0001 01Feb09 0 0001 01Mar09 3 0001 01Apr09 0 .... current month 0002 01Jan09 0 0002 01Feb09 2 .... so on.. I thought about creating a data set with just dates and using a left merge, not sure if that will work.. If anyone has a solution to how I should tackle this that would be great! Thanks for the help! ... View more