Hi ChrisBrooks,   I tried to write text by resolving the macro variables followed by table to create RTF document which should contain all text and table but not able to create file.   Could you please help me with the approach how can we write text from macro variables followed by SAS table in RTF file using ODS Document & Proc Document .?  Please let me know in case if you require any more details.     ... View more

Hi Chris,   Thank you for quick reply.   I have attached wroge code in my last post. Please find the sample code where i am trying to write/copy table in RTF document creating using proc stream.   I have also again attached output (Narrative_sampleN.rtf) created using same code and in third attachment , i have provided the contents that i am writting to my narrative document. Header, narrative introduction... etc using SAS macros.   In Narrative_sample.rtf, Instead of table , it is coming some different lines describing my table.   Could you please help me here.  I hope , the attached files would be useful to you for giving assistance to handle this scenario.     ... View more

Hi  Ballardw,   Please find the attached code to write/copy the table in patient narative document getting create using proc stream in RTF format. I have attached code, Narative_sampleN.rtf and word doc which content  patient narration (in RTF Format) which will be before writting the table in narration doc. I am able to write content of all different sections using SAS macro  but at the end of this  i wanted to copy/wrirte table using same proc stream but when i am trying it then instead of table , it is displaying some RTF lines describing table which needs to be handled.   attached Narrative_SampleN.rtf is output of my code in which i am trying to write table in RTF file using proc stream . Note that, before table there would be patient narration which is display in my third attachement. Only table i am not able to write/copy into my narrative RTF file.   please assist. ... View more

Hi ShiroAmada   Here in your example you are searching for specific supercript but i have many list of superscript.   In first step, can we check if supercript is present in data values or not? if it is present then store the position in variable.   is it possible? ... View more

Hi RW9,   Thanks for your quick reply.   I am able to read those superscript in dataset(Attached file) but without searching specific superscript , Can we check wheather superscript is present in my variable data values.   data test1; set test; position=find(DrugName,'®'); run;   or   Saving the superscript in new variable:   data test2; set test; position=substr(DrugName,find(DrugName,'®')); run;   Using the above code, I am able to find the position or save the subscript but here i am searching the specific superscript. But i dont know , list of posible superscript that could come in variable values. so i need to find if superscript is present or not.   Can we search ^ (superscript ) if present then retrive position without specifying any superscript present in data values.? Any specific function or statement that can be used to accomplish this task.   please assist. ... View more

Sorry for late reply.   Actually i am working onn patient narrative . Here in Investigator term variable , i can get the subcript so i need to identify it and write the explaination about it.  I dont need to set the subcript on any values or variables, Actually i want to identify and find if subscript present in my investigator term variable , if present then , i need to access it and explain in patient narrative that i am creating using SAS ODS and PROC STREAM.   I have also attached the narrative part . please assist.  ... View more

Hi All,   Could you please help me to know,  if there is any tool or code in SAS that can be used to find all redundant SAS reports.   Requirement: In Production, we have 800-1000 SAS report and  we need to find the reports which are necessary so the redundant report needs to be removed (for ex. If report is not getting updated  etc). Need your quick assistance on this.   Regards, Ashish S ... View more