Thanks to everyone that replied with suggestions.  I was able to get my code to work using the %if %then %do logic. ... View more

Indeed. And looks like you already got a couple of replies on the AU board! Thanks for being active in here. 🙂 ... View more

Hi @Phil_NZ,   We have no limits to where we'll ship swag! Although we didn't ship anything for SASGF 2020...I don't know what we'll do for 2021. Keep your eyes peeled here for any updates on conference swag.    Best, Shelley ... View more

Congrats @supp  @mbuchecker and @mtgkooks on your SAS Bowl result. An amazing achievement!   Ooohhhh a SAS Bowl Community badge! Looking forward to seeing that too.   It's a shame the session wasn't recorded as I was hoping to listen to the commentary again... loved the way Chris said "PROC androll"! Very game show like! ... View more

Change all these variables into CHARACTER variable. INFILE file DLM="|" DSD LRECL=3200 TRUNCOVER ; input ( Recipient_ID Recipient_ID_Inactive Valuation_Period_YYYYMM Aid_Group Alien_Type_Code Amt_Annual_Income Amt_FPL_Annual_Income Amt_FPL_Monthly_Income Amt_Monthly_Income Case_Numb Case_Seq_Numb Continuous_Month_Enrolled Date_Birth_Recipient Date_Valuation Dual_Elig_Aid_Catgy EDW_Member_Sub_Program_Code Family_Size FPL_Range_Code Frail_Confirm_Code Fund_Code_MARS Immigration_Status I_Budget I_BuyinA I_BuyinB I_Casualty_Case I_Continuous_Enrollment I_Credible_TPL I_DOC I_Dual_Aid I_Emergency_Services_Only I_FPL_ICES I_Frail I_Initial_Enrollment I_Low_Income_Caretaker I_Managed_Care I_Medicare I_Medicare_PartA I_Medicare_PartB I_Medicare_PartD I_Native_American I_Newly_Elig I_Plan_ID_Changed I_PMP_Change I_Pre_12Month_Elig I_Refugee I_Re_Enrollment I_Spenddown I_TMA I_TPL_Coverage Level_of_Care Level_of_Care_Type Percent_FPL_Annual Percent_FPL_Monthly PGM_1915i_Code Percent_Pre_12Month_Elig Plan_Provider_ID Primary_Care_Physician PCP_Location_ID MMIS_Public_Health_PGM_Code MMIS_Public_Health_PGM_Code2 EDW_Public_Health_PGM_Code Recipient_Addr_County Recipient_Age_In_Months Recipient_Age_In_Years Recipient_Aid_Catgy Recipient_Aid_Catgy2 TANF_Cash_Code ) ( : $200.) ; ... View more

Before and after sessions some of my tentative plans include: Checking out Craft Beer Cellar (I like bring back local beer that I can't get in MN) Dinner at Emmy Squared ( They have a burger that looks off the charts)https://ny.eater.com/2016/7/11/12123102/emmy-squared-burger-review Brunch at DBGB Jefferson Memorial and Cherry Blossoms if they are in season Dinner at Churchkey Dinner at Red Light Bar (Detroit style pizza) National Portrait Gallery if time permits ... View more

@Ksharp 谢谢 🙂 ... View more

Here is how to do in hash.   data have1; input names $ birthdates:date9. tests $; format birthdates date9.; cards; AA 09Jan2010 X BB 10Jan2010 Y CC 11Jan2010 X DD 12Jan2010 X ; run; data have2; input names $ birthdates:date9. tests $; format birthdates date9.; cards; AA 09Jan2010 X BB 10Jan2010 Y ; run; data want; set have1; if _n_=1 then do; declare hash rc (dataset: 'work.have2'); rc.DefineKey ( 'names','birthdates','tests' ) ; rc.DefineDone () ; end; if rc.find() =0 then delete; run; ... View more

First Job:  Selling fireworks. After University: UNIX systems programmer doing bug fixes of the AIX kernel for IBM. Today: Manager of near-shore web application development team and Excel VBA consultant. Learn Next:  Just finished Udacity Machine Learning Engineer Nanodegree and I'm looking for volunteer opportunities as a SAS statistical programmer. Never did as much statistics work as I wanted early in my career. Hoping to make a change (switch) but it is tough to get the resume bullets I need to launch. ... View more

Hello Michel,   Thanks... It worked for me by doing suggested changes.       Manoj ... View more