Please try   data have; input name $ dept $ date date9.; format date date9.; datalines; John Sales 01JAN2018 Mary Acctng 01JAN2018 ; data in_coming_file ; input name $ dept $ date date9.; format date date9.; datalines; John Sales 02JAN2018 Mary Finance 02JAN2018 Jake Finance 02JAN2018 ; proc sort data=have; by name dept date; run; proc sort data=in_coming_file; by name dept date; run; data want; merge have(in=a) in_coming_file(in=b); by name ; if b and not a then flag='N'; if a and b then flag='U'; run; ... View more

Could you please provide the exact sample data with 'no' as well ... View more

ok then try this   Data t2204_new; length Revenue_new $200.; set t2004; Revenue_new=CATX(',',of Revenue:); Run; ... View more

you may try Revenue_new=CATX(',', of Revenue1--Revenue4); ... View more

Alternatively you can try the proc format as below, for this you need to create a format and then use that format to derive a new variable.   Also, use the libname to call the dataset in the set statement.   proc format; value chol low-<200='Safe' 200-239='High-Borderline' 240-high='High' other=' '; run; libname dat "/home/u44696116/TheCut/input"; data out; length chol_status $ 15; set dat.input44; drop bp_status weight_status smoking_status; chol_status=put(cholesterol,chol.); run; ... View more

You may refer to my paper on perl regular expressions   https://www.phusewiki.org/docs/2019%20Amsterdam/Papers_presentations/CT/CT%20Final%20Papers/CT12.pdf  ... View more

Hi Soujanya,   Please let me know if this helps.   data have; input city1 :&$200.; cards; BRONX NY 10467-6021 LAS VEGAS NV 89119 BATTLE MOUNTAIN NV 89820-1998 NORTH LAS VEGAS NV 89031-3432 ; data want; set have; city=prxchange('s/(.*)(\s\w{2,2})(\s\d.*)/$1/oi',-1,city1); state=prxchange('s/(.*)(\s\w{2,2})(\s\d.*)/$2/oi',-1,city1); zip1=scan(prxchange('s/(.*)(\s\w{2,2})(\s\d.*)/$3/oi',-1,city1),1,'-'); zip2=scan(prxchange('s/(.*)(\s\w{2,2})(\s\d.*)/$3/oi',-1,city1),2,'-'); run; ... View more