About msharma1788

msharma1788 · ‎02-22-2021

Hi Team, I have below data in my final dataset. SSN REC_TYPE Name 123 53 Mukesh 123 35 Mukesh 123 01 Mukesh 234 53 Rajesh 234 35 Rajesh 345 53 Madhan 345 35 Madhan 345 01 Madhan 456 35 Richa I want to create a bypass report if my SSN is not present in any of the REC_TYPE (35,53,01) I am expecting below result for my Bypass dataset. 234 53 Rajesh 234 35 Rajesh 456 35 Richa Thanks!

msharma1788 · ‎12-03-2020

Dataset ssn Amt PLAN Mod 2345 233 9229 26 2345 244 9222 12 1234 222 9229 26 Expected result ssn Amt PLAN Mod 2345 233 9229 26 1234 222 9229 26 I need to keep only one row for this ppt if it has row for both the plans (9229,9222) . I need to just poulate row for plan 9229. How can this be done with out dropping any variable.

msharma1788 · ‎08-18-2020

Hi Team, I have a dataset ABC Var 1 Var2 Var3 PPO with HRA LocalPlus® Silver PTO Cash Out I need to set an Indicator Y if any if the variable 1, 2 or 3 contains LIKE'%Local%' . IF Var1 or Var2 or var3 LIKE'%Local%' . THEN Var4 = 'Y'; Please help as how we can do this, as LIKE works with were , what other option we have to do this and get expected result. Thanks!

msharma1788 · ‎04-27-2018

Hi Team, I have a Zip Code 1235 0234 Need result as 12350000 02340000

msharma1788 · ‎02-21-2018

I need the data to be deleted only when the SSN is in both the plans 9000 and 9020 , If its in both the plans then it should check the CV_CAT ids mentioned. and should delete that row.

msharma1788 · ‎02-21-2018

Data Set name is PLN200 SSN PLAN_ID CV_CAT 001 9000 21 001 9020 847 My code is not giving me expected result: DATA PLN200; SET PLN200; BY SSN; IF PLAN_ID = 9000 AND PLAN_ID = 9020 THEN DO; IF CV_CAT IN(26,55,65,817,827,847) THEN DELETE; END; RUN; I am expecting only "001 9000 21 " in result. Please suggest.

msharma1788 · ‎02-15-2018

Thanks! this really helps 🙂

msharma1788 · ‎02-14-2018

Requirement is to replace invalid character with valid character. In case a dataset has the below values. FIELD FLDVALUE FNAME José LNAME Colón LNAME Colón LNAME Burgos-Suárez LNAME Nogueras-López LNAME Camacho-De León LNAME Padilla-Rodríguez LNAME Vilaró MID C> LNAME Vázquez-Hernández LNAME Montaño LNAME Camacho-De León FNAME Michaéla We need the value as José = Jose Burgos-Suárez= Burgos-Suarez This data id pulled from EFT File and we need to reformat this data. Please suggest.

Online Status	Offline
Date Last Visited	‎02-08-2022 12:00 PM

How do I create Bypass report from Final dataset.

DATA Selection

Like

Add Trailing 0

Re: Data subsetting.

Data subsetting.

Re: Invalid ASCII character in name.

Invalid ASCII character in name.

Re: Like