Before call missing was added to SAS, you would use an explicit assignment statement: To set a numeric variable to missing:    X=.; To set a character variable to missing    CVAR=''; ... View more

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n1qvxz5u3uru7yn1nk7q64ohvwak.htm&docsetVersion=9.4&locale=en ... View more

@Abhi_Garg wrote: **bleep** it. I have been working on this for last one hour. It never caught my eye.   Thank you so much @Reeza.  No problem, glad it was that easy.   FYI - I spent four hours this weekend, debugging something that turned out to be a case error, because R variables are case sensitive. We all get there some days.  ... View more

SAS is GREAT for stuff like this!   Make sure your input table is sorted by "provider_number".   Tom   data _null_; file "C:\directory\file.csv" dlm = ',' dsd; set providers_Page2; by provider_number; if first.provider_number then put "<Provider>," provider_number / "<Member_list>" / "<Member>," member_first_name member_last_name member_dob product_name date_filled drug_manufacturer prescriber_first_name prescriber_last_name; else put "<Member>," member_first_name member_last_name member_dob product_name date_filled drug_manufacturer prescriber_first_name prescriber_last_name; run; ... View more

I'm not sure if you're asking me or not ... these message boards don't really show the connections between posts.  But if you are asking about my program, it does that automatically.  Whatever is part of &DRUG_LIST will be added to the WHERE clause by the posted code. ... View more