Hi All   data have ; text="The subject experienced [AESER] adverse event of [AESEV] intensity, reported as '[VBA]' ([LLT])."; output; text="[Samsung - the first major smartphone maker to release a foldable smartphone]"; output ; text="School districts across the [COUNTRY] are on the cusp of integrating [new technology in K-12 classrooms] by such as [SOCIAL_MEDIA] use as early as preschool.exploring unexpected [CURRICULUM] such as Facebook/Twitter use as early as preschool."; output; run ;   i want to split the entire text into multiple variables based on the square/Angular brackets ([), both start and close brackets along with the text present in the brackets  should be present in each variable as shown below. Tried with do loop and array, something missing in the loop . Can any one suggest how to perform this split.   VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 The subject experienced [AESER] adverse event of [AESEV] intensity, reported as [VBA]' ([LLT])   [Samsung - the first major smartphone maker to release a foldable smartphone]               School districts across the [COUNTRY] are on the cusp of integrating [new technology in K-12 classrooms] by such as [SOCIAL_MEDIA] use as early as preschool.exploring unexpected such as Facebook/Twitter use as early as preschool.         ... View more

I have string with variable names and text embedded in it and all variable names are embedded in square brackets. While concatenating need to cross check the result values present in the variable. In case of multiple results, these should be concatenated using comma  (addition of “and” before the last entry only). Variables are combination of character and numeric. For example If A , B present then concatenation should be A and B. If 3 results are present result should be A, B and C .   text="The details of the student are (values=[NAME] [SEX] [AGE] [HEIGHT] [WEIGHT]).";   data class; set sashelp.class; /* scenarios to be considered*/ if name="Alice" then do ;call missing(height,weight);end; if name="John" then do ; call missing(sex,age);end; if name="Carol" then do ; call missing(age, height, weight) ;end; ab=catx(',',name,sex, age, height, weight) ; run ;   output should be as below. The details of the student are Alfred,F,14,69 and 12.5. The details of the student are John,59 and 99.5. The details of the student are Carol and F.     Any suggestion or sample code how to get the required output.  ... View more

Hi ,   The text that is present in square/Angular brackets are mostly considered as VARIABLE NAME, but in certain scenarios the plain text is also placed in square brackets to emphasize it.So in the code while concatenating the variable names are concatenated and converted into actual values present in that variable. The plain text that is placed in square brackets which is not variable should be placed as it is in the text .    For example in the second row entire text is placed in square brackets , it should be kept as it is without processing. In the third row new technology in K-12 classroom is placed in square brackets , this should be unprocessed.   As per my thoughts all variable names are single word and free text placed in square brackets are more than a word. How to handle such scenarios.   Have  Want  The subject experienced [AESER] adverse event of [AESEV] intensity, reported as '[VBA]' ([LLT]). The subject experienced serious adverse event of severe intensity, reported as 'headache' (value]). [Samsung - the first major smartphone maker to release a foldable smartphone] [Samsung - the first major smartphone maker to release a foldable smartphone] School districts across the [COUNTRY] are on the cusp of integrating [new technology in K-12 classrooms] by exploring unexpected [CURRICULUM] such as [SOCIAL_MEDIA] use as early as preschool. School districts across the US are on the cusp of integrating [new technology in K-12 classrooms] by exploring unexpected Response such as Facebook/Twitter use as early as preschool.   i am using the below code  data want; length sentence $500.; set have ; sentence='"'||tranwrd(sentence,'[', '"|| strip('); sentence=tranwrd(sentence,']', ') ||"'); sentence=strip(sentence)||'"'; run ;   After conversion it looks like below , it converts the free text placed in square brackets, it should be avoided. "The subject experienced" ||strip(AESER)|| "adverse event of" ||strip(AESEV) ||"intensity, reported as" ||'strip(VBA)' ||strip'(LLT)'". "strip(Samsung - the first major smartphone maker to release a foldable smartphone)" "School districts across the" ||strip(COUNTRY)|| "are on the cusp of integrating strip(new technology in K-12 classrooms )by exploring unexpected" ||strip(CURRICULUM) "such as" ||strip(SOCIAL_MEDIA)|| "use as early as preschool." ... View more

Hi All, I have the below dataset, need to replace the values in target variable with Replace variable. Its working fine with tranwrd , but i am unable to do using PRXCHANGE and PRX parse as i am missing how to PARSE the Target variable values in PRXPARSE Source target  replace Output Vegetables are apples and oranges vegetables Fruits Fruits are apples and oranges Sugars are Fruct and Fructose fruct GLUC Sugars are GLUC and Fructose Labtest and Labtestcd are same Labtestcd Lab.Labtestcd Labtest and lab.labtestcd are same   data aa; set abc; new=tranwrd(source,target,replacement) ; neew = PrxChange('s/\b(Vegetables)\b/Fruits/i' , -1 , strip(source));; run ;   In the above example i am replacing fruits with vegetables, but i am having huge dataset and i have to replace all the target variable with replace variable. Target variable can consists of  combination of letters , numbers and special characters , but i have to replace them with replace variable. How do i parse the TARGET variable values to use them in PRXCHANGE . Any sample code with little explanation on how to use PRXPARSE and PRXCHANGE replace in dataset. Individually it can be done , but with different combinations its causing issue. ... View more

This is an SQL condition for joining two datasets separated in a variable text as below. text="AB.name = dsn.pname and AB.ID = dsn.varID and AB.custid=dsn.customerid" ;   I need to pick the variables from dataset dsn only and store all the dsn variables from this condition into another variable. I have tried the following code using array and do loop , but something is missing from the second iteration. Variables are not created from second iteration, as a result values are also not created. May i know what is wrong in this or is their any other short cut method to generate this . I want the final output like this.(all variables in DSN dataset presnet in the text condition are separated)  Output=pname varid customerid   data a; set text ; text="AB.name = dsn.pname and AB.ID = dsn.varID and AB.custid=dsn.customerid"; mod='i'; domain="dsn"; cnt=count(text,strip(domain)); array str {3} $40. ; array fdf {3}; do i = 1 to 3 ; fdf[i]=find(text,strip(domain),mod,fdf[i]+i) ; str{i}=scan(substr(text,fdf(i)+1),2,". ","M") ; end ; outvar=catx(' ',str:) ; run ;   Any help would be appreciated  ... View more

Hi All, I have a dataset with variable HAVE and another variable Replace consisting of some text to be replaced from HAVE to new value present in the same variable, Old represent the value present in the HAVE variable and New is the value to be replaced in the same variabe HAVE. This has to be done dynamically by selecting the text from replace variable without manual checking. I am trying to find the text in Old using FIND,SCAN,SUBSTRs function and then replacing the value with TRANWRD fucntion. Is there any direct approach/function/short cut to do this in much simpler way. The output variable is WANT for reference.   Have Replace Want Benchmark indices registered recovery from the day's low point. (old="low", new="high") Benchmark indices registered strong recovery from the day's high point. Completes inspection at Factory  (old="at", new="in") Completes inspection in Factory  Patient; status; cardiac arrest (old=";",new=',') Patient, status, cardiac arrest ... View more

The observation consists of text along with the variable names, that variable while concatenating will be converted into value and forms a complete observation. The variable names are embedded  in square brackets. While concatenating they should be stripped to avoid unwanted spaces in the final observation.The number of variables are not fixed , the text may also contain some special characters as well. How to make this functional. Original is the text and output is what is expected,both are displayed below at the end.   Tried with the below code.,but something is missing the do loop while splitting the text based on delimiter ']'   data a; text="It was found that the customer transacted an average of [AVERAGE] transaction per month in [START_YEAR] and closed account in [END_YR]." ; call symputx('txt',countw(text,"]")); run ;   data b; set a ; array txt{&txt} $200. ; do i = 1 to countw(text,"]"); if i =1 then txt{i}=substr(text,1,find(text,"]")); else txt{i}=substr(text,find(text,"]")+1,find(text,"]")); end; run ;   Original  Output It was found that the customer transacted an average of [AVERAGE] transaction per month in [START_YEAR] and closed account in [END_YR]. ; "It was found that the customer transacted an average of" || strip(AVERAGE) || "transaction per month in" || strip(START_YEAR) || "and closed account in" || strip(END_YR).";   ... View more