Hi,   Would like to seek your expertise if has anyone tried to execute bcp command using systask?    Reason is that we would want to achieve SAS orchestrating all the jobs. I have some sas datasets which will serve as reference tables to know which file to pick up and to which table to load to and then I'm planning to create a macro parameterized by the table name. In that way I only have one script to maintain instead of multiple bcp scripts one for each table.   Thanks in advance! ... View more

I have a free text column which I need to delete and replace some sections. I'm able to use prxchange for those with known structures such as employee id, postal code. But I also need to mask names and other sensitive information   Input Free Text: Name: John Doe DOB: 1991-10-10   Output Cleansed Text: Name: XXX DOB: YYYY-MM-DD   Is there a way I can use prxmatch then if it matches a portion I will manipulate the succeeding string next to it?     ... View more

I would like to consult expertise of the community regarding my plan if it would be feasible.   (1) Load file to SAS (2) Call python/R to do some treatments on the SAS dataset (3) Load SAS dataset to RDBMS   If everything is on a sas script, will SAS be able to capture if there are any failures in the pyhton script called?   NOTE: Reason there's a python/R as there were previously built scripts to cleanse the data. While it can be done in SAS thru prxmatch,etc we don't want too waste much effort replacing a working one in python/R   Greatly appreciate your inputs and thoughts on this.   Thank you! ... View more

This is connection to my previous post found in this link: https://communities.sas.com/t5/Base-SAS-Programming/Clustering-Links/m-p/264960#M52032   Given that I have already performed the household linkages previously, and executed the household tagging again and there were changes, how can I properly update the household tagging.   I have provided some sample data as well as the data i'm working on(tmp) to update the clusters. I didn't include my current code to update as it doesn't provide the desired results but I created the desired output for your reference.   In the result, ids 1,2 retain their old household tag; id=3 got included on the same household with 1 and 2; id = 4 retain and id = 5 moved to a different household; ids 8 and 9 are inserted.   Appreciate any recommendations on how to acheive this.   data old; input household id; datalines; 1 1 1 2 2 4 2 5 3 6 3 7 ; data new; input household id; datalines; 2 1 2 2 2 3 4 5 4 6 4 7 5 8 5 9 ; proc sql; create table tmp as select a.household, coalesce(a.id,b.id) as id, b.household as new_household from old a full outer join new b on(a.id=b.id) ; quit; data desired; input household id; datalines; 1 1 1 2 1 3 2 4 3 5 3 6 3 7 4 8 4 9 ;         ... View more