Below I create two tables, with the second table a subset of the first. What I'd like is to retain only the observations from the first table where the MemberCTG and HCPCS on a given observation in the first table matches the MemberCTG and HCPCS on an observation on the second table.    My thought was to somehow pass the MemberCTGs from the second table into a macro list and filter the first table on those, then do the same thing with the HCPCs from the second table and filter the first table on that again. But that seems like it ends up being a far too complicated solution for the problem I'm trying to solve.   PROC SQL; CREATE TABLE cb.LONGTERMOX09252019_Filter1 AS SELECT t1.ClaimID, t1.LineNum, t1.MemberID, t1.MemberCTG, t1.date, t1.HCPCS, t1.billed, t1.allowed, t1.paid, t1.MR_Cases_Admits, t1.MR_Units_Days, t1.MR_Procs FROM cb.LongTermOx09252019 t1 ORDER BY t1.MemberCTG, t1.HCPCS, t1.date; QUIT; data cb.LONGTERMOX09252019_Filter2 (keep=MemberCTG HCPCS Count); set cb.LONGTERMOX09252019_Filter1; by MemberCTG HCPCS; if first.HCPCS then count=0; count+1; if last.HCPCS and count > 35 then output; run; ... View more

  Hi All. I'm trying to run the code below and getting an error saying ERROR: Variable srcLOB is not on file HCGOUT.OUTCLAIMS_xxxx.   I don't know why this would be the cases, because I've checked using Proc Contents and the variable does exist. Any idea why this is happening?     libname hcgout "/sasapps/HCG/HCG_PROD/Data_Sets/Output_NET"; %let list = linenum memberid memberctg incurd_yr_mo hcpcs; %let hcpc = "E0431" "E1390" "E1392" "K0738"; %let loblist = "MCAD" "MCHM"; data hcgTables2014toPresent ; set hcgout.outclaims_2014 (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date)) hcgout.outclaims_2015 (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date)) hcgout.outclaims_prior (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date)) hcgout.outclaims_current (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date)); run;     ... View more

I've tried no quotes, single quotes, double quotes, etc. but can't get my hcpc macro list to work in the code below. It tells me that there was a Syntax error while parsing WHERE clause.   Please help me fix my code, but also help me understand the general rule and what makes my first list different from my second.   libname hcgout '/CUDM/HCG/HCG_PROD/Data_Sets/Output_NET' ; %let list = linenum memberid memberctg incurd_yr_mo hcpcs; %let hcpc = "E0431", "E1390", "E1392", "K0738"; data hcgTables2014toPresent ; set hcgout.outclaims_2014 (where= (hcpcs in &hcpc.) keep=&list.) hcgout.outclaims_2015 (where= (hcpcs in &hcpc.) keep=&list.) hcgout.outclaims_prior (where= (hcpcs in &hcpc.) keep=&list.) hcgout.outclaims_current (where= (hcpcs in &hcpc.) keep=&list.); run; ... View more

Hey all! I'm pretty much a novice, so anything out of the ordinary requires me to call on the help of others, which is what I'm doing.   What I want to do is to take a piece of html source code like I have below, and "clean" it such that all that remains is a list of keywords/hashtags. What I have going for me is that (for all intents and purposes) you can be pretty sure that the "#" acts as a faithful indicator that there's a keyword to follow. Any help will be greatly appreciated.   description available."}},{"node":{"comments_disabled":false,"__typename":"GraphImage","id":"1998217523958621257","edge_media_to_caption":{"edges":[{"node":{"text":"Summer is coming! \u2600\ufe0f \ud83c\udf1e\n#Freude #FreudeCrewMember #FreudeAmKFZ #VWJetta #mk2 #volkswagen #AudiS3 #Audi #VWAudi #VAG #lowered #boost #orange #red #car #tuning #summer #comingsoon #carmeet #seasoniscoming #driving #carsarelife #static @red_jetta_1.8_t"}}]},"shortcode":"Bu7GEBDg6RJ","edge_media_to_comment":{"count":0},"taken_at_timestamp":1552426113,"dimensions":{"height":1080,"width":1080},"display_url":"https://scontent-lax3-1.cdninstagram.com/vp/f5d30fea48bee4d2492d8fa8d28922f2/5D15DD26/t51.2885-15/e35/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","edge_liked_by":{"count":10},"edge_media_preview_like":{"count":10},"owner":{"id":"11297619899"},"thumbnail_src":"https://scontent-lax3-1.cdninstagram.com/vp/08ae6f6b7cac751844513bb5e5730fb3/5D1955C3/t51.2885-15/sh0.08/e35/s640x640/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","thumbnail_resources":[{"src":"https://scontent-lax3-1.cdninstagram.com/vp/0e3d9a608cf07804893534062e8ae3fb/5D172664/t51.2885-15/e35/s150x150/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":150,"config_height":150},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/03375eff9b3fc793c2eafc77ae4d1087/5D10FB2E/t51.2885-15/e35/s240x240/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":240,"config_height":240},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/6322eb6c96db8f7cd2852510909ef475/5D219E94/t51.2885-15/e35/s320x320/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":320,"config_height":320},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/ad83b93d7dab9e019b32472320b5cc65/5D09F7CE/t51.2885-15/e35/s480x480/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":480,"config_height":480},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/08ae6f6b7cac751844513bb5e5730fb3/5D1955C3/t51.2885-15/sh0.08/e35/s640x640/53786494_357691698290379_8067023115557724894_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":640,"config_height":640}],"is_video":false,"accessibility_caption":"Image may contain: car and outdoor"}},{"node":{"comments_disabled":false,"__typename":"GraphImage","id":"1998201676453166113","edge_media_to_caption":{"edges":[{"node":{"text":"Ferrari FF #cars #carporn #carphotography #topcars #coolcars #automotivephography #automotivephographer #autogespot #amazing_cars #instacars #instacars247 #carsarelife #carphoting #supercarsdaily #supercars247 #supercarsdaily700 #carspotting #carspotter"}}]},"shortcode":"Bu7CdZ6lLwh","edge_media_to_comment":{"count":0},"taken_at_timestamp":1552424223,"dimensions":{"height":1080,"width":1080},"display_url":"https://scontent-lax3-1.cdninstagram.com/vp/bd6284b185ea7effbe3e5600d31cebca/5D0A5644/t51.2885-15/e35/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","edge_liked_by":{"count":12},"edge_media_preview_like":{"count":12},"owner":{"id":"11657938037"},"thumbnail_src":"https://scontent-lax3-1.cdninstagram.com/vp/65a41539f298087294633eb9468befe6/5D0674A1/t51.2885-15/sh0.08/e35/s640x640/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","thumbnail_resources":[{"src":"https://scontent-lax3-1.cdninstagram.com/vp/cc5a4aa3f60c8243cf537a788a21562b/5D1B9C06/t51.2885-15/e35/s150x150/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":150,"config_height":150},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/d243b9483f25106e203c538fa84bc4df/5D1ACE4C/t51.2885-15/e35/s240x240/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":240,"config_height":240},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/0a65c76e5938c677fee8e4625ea83d0b/5D1CDDF6/t51.2885-15/e35/s320x320/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":320,"config_height":320},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/eaaeb4aac8c2f0ba9f4fe2d35b1d27a4/5D0659AC/t51.2885-15/e35/s480x480/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":480,"config_height":480},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/65a41539f298087294633eb9468befe6/5D0674A1/t51.2885-15/sh0.08/e35/s640x640/52543684_432358277570476_3435469715500693989_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":640,"config_height":640}],"is_video":false,"accessibility_caption":"Image may contain: car"}},{"node":{"comments_disabled":false,"__typename":"GraphVideo","id":"1998184571132976705","edge_media_to_caption":{"edges":[{"node":{"text":"Car is still his favourite word but at least he\u2019s throwing some colours in as well now \ud83d\ude02"}}]},"shortcode":"Bu6-kfWDB5B","edge_media_to_comment":{"count":4},"taken_at_timestamp":1552422264,"dimensions":{"height":750,"width":750},"display_url":"https://scontent-lax3-1.cdninstagram.com/vp/59ea755e6d8892326277c6bff273591e/5C8ADCC0/t51.2885-15/e15/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","edge_liked_by":{"count":20},"edge_media_preview_like":{"count":20},"owner":{"id":"7112182"},"thumbnail_src":"https://scontent-lax3-1.cdninstagram.com/vp/32e320a234c664f6f5b217961188d229/5C8A6C3E/t51.2885-15/e15/s640x640/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","thumbnail_resources":[{"src":"https://scontent-lax3-1.cdninstagram.com/vp/1c6fc3793741f0e27deea7fa9dcec1c2/5C8A53E1/t51.2885-15/e15/s150x150/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":150,"config_height":150},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/b27a2d0567b421fc68e5e12b1a3ba2aa/5C8AF36B/t51.2885-15/e15/s240x240/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":240,"config_height":240},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/1e9cdc399524e00fc52b5aa284fdbc99/5C8B8B11/t51.2885-15/e15/s320x320/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":320,"config_height":320},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/39874c4e5cb8e97e49072d460d422df0/5C8A6C8B/t51.2885-15/e15/s480x480/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":480,"config_height":480},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/32e320a234c664f6f5b217961188d229/5C8A6C3E/t51.2885-15/e15/s640x640/51820254_395521411001257_3011032355330220914_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":640,"config_height":640}],"is_video":true,"video_view_count":59}},{"node":{"comments_disabled":false,"__typename":"GraphImage","id":"1998169659401479808","edge_media_to_caption":{"edges":[{"node":{"text":"Is Adobe Photoshop really worth it for pictures?\ud83e\udd14 #taillighttuesday \ud83d\udcf8 \u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\nCar Mods \ud83d\udd27 \n@corsaperformance | @jltperformance\n@diodedynamics | @pmas.maf \n@luxeautoconcepts | @lund_racing\n@fordperformance\n\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\nSponsors \u00a9\ufe0f\n@carlock.co | @lightingtrendz @ace_auto_detailing \u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\u25ab\ufe0f\nHashTags #\n#fordperformance #performancepackage #s550 #photography #carcommunity #fordmustanggt #brembo #carsarelife #mustangfanclub #mustangclubest #diodedynamics #mustangfanclub #s197 #mustangnation #fastlife #mustangjuice #mustang_everyday #mustangsociety #mustangsofinstagram #carporn #corsaexhaust #stanggang #mustangaddicts #fordracing #mustang_lifestyle\n\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\u25aa\ufe0f\nCredits \ud83d\udcf8 @icyy_cali (iPhone XS Max)"}}]},"shortcode":"Bu67LftlqaA","edge_media_to_comment":{"count":4},"taken_at_timestamp":1552420407,"dimensions":{"height":1350,"width":1080},"display_url":"https://scontent-lax3-1.cdninstagram.com/vp/029125e9463a896cee5c1ff2b74cdafb/5D290065/t51.2885-15/e35/p1080x1080/52762717_121260398971453_4664182291038734575_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","edge_liked_by":{"count":87},"edge_media_preview_like":{"count":115},"owner":{"id":"509207344"},"thumbnail_src":"https://scontent-lax3-1.cdninstagram.com/vp/ee8ead928fd617283b3ecfc5290c46b5/5D26BAF6/t51.2885-15/sh0.08/e35/c0.180.1440.1440a/s640x640/52762717_121260398971453_4664182291038734575_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","thumbnail_resources":[{"src":"https://scontent-lax3-1.cdninstagram.com/vp/7de95911fb39b4b53b4d0343e1874bf9/5D09853D/t51.2885-15/e35/c0.180.1440.1440a/s150x150/52762717_121260398971453_4664182291038734575_n.jpg?_nc_ht=scontent-lax3-1.cdninstagram.com","config_width":150,"config_height":150},{"src":"https://scontent-lax3-1.cdninstagram.com/vp/a74615dc2821a069e1cdbfdbde2f24a3/5D288C77/t51.2885- ... View more