About Lorielus

Lorielus · ‎12-05-2018

The eventual solution used: data name_list; input ID Name $; datalines; 1 Jim 2 Steve 3 Susan 4 Karen ; run; data have; input text $100.; infile datalines truncover; datalines; Jim AAA Steve Susan BBB Susanne CCC ; run; proc sql noprint; select count(*) into :n from name_list ; quit; data want; set have; array names[&n] $30 _temporary_; if _n_ = 1 then do i = 1 to &n; set name_list(keep = name); names[i] = name; end; do i = 1 to &n; text = tranwrd(text,strip(names[i]),'[NAME REDACTED]'); end; keep text; run;

Lorielus · ‎12-04-2018

Thank you for your time, I really appreciate it, I'll seek an alternative solution.

Lorielus · ‎12-04-2018

Thank you - so how do I reference LIB.NAMELIST.Name in that code?

Lorielus · ‎12-04-2018

Hi, Thanks for your effort on this, I really appreciate it. You are right in the intent as I outlined in the original post. However, again the issue is not with the replacement of words within the string, but how do I reference a list of words from a column in a data set. In other words, you have defined the list of words with: data list; length wrd $200; wrd="string";output; wrd="removed";output; run; But I cannot type out 412,000 variations of wrd="string";output; to create the list to loop through - so the question as before remains, how do I define "list" in the above as the column "Name" from LIB.NAMELIST?

Lorielus · ‎11-30-2018

Hi, Apologies, I think I'm maybe being misleading, I'm not looking for an overall solution, just the syntax for how to reference LIB.NAMELIST.NAME as the target for the TRANSWRD statement. Many thanks.

Lorielus · ‎11-30-2018

Hi, Context here is I have a rudimentary SAS skillset at best (normally an SQL data monkey), and am looking for some syntax advice on how to reference a specific column from a data set to use as a list of strings to find and replace within a large free text string with a "[NAME REDACTED] placeholder. The overall goal here is to replace a huge list of names (~400k) from free text description fields. The name list (referring to this as LIB.NAMELIST) appears along the lines of: ID Name 1 Jim 2 Dave 3 Susan 4 Fiona My plan was to do this with a simple WHILE look, something along the lines of the below (italics is where I don't know how to reference this dataset & column in the loop): data=have; set=want; nstart=1; nend=400000; do while(nstart<=nfinish); TRANWRD(DescriptionField,(SELECT NAME FROM LIB.NAMELIST.Name WHERE ID = nstart),"[NAME REDACTED]"; n+1 ; END ; Any help would be much appreciated! Many thanks in advance.

Online Status	Offline
Date Last Visited	‎12-05-2018 10:37 AM

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

How do I find & replace a large list of names from a large string (Red...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

Re: How do I find & replace a large list of names from a large string ...

How do I find & replace a large list of names from a large string (Red...