About Hari2

Hari2 · ‎06-02-2020

Hi All, - I have Imported data from Excel file in which I have a column with both date and time Ex: 05/09/2018 9:46. (dd/mm/yyyy hh:mm) - I am using ANYDTDTM. to convert it to datetime format and the code I am using is Below. input(coll_date_time,ANYDTDTM.) as erdttime format=datetime15. - Here, we have dates in the form of dd/mm/yyyy hh:mm and expectation from above piece of code is 05SEP18:09:46. However, above code is giving output as '09MAY2018:09:46'. It's considering day as month and Month as Day. while the same code is giving correct Output for ''29/01/2019 10:40" as 29JAN19:10:40 (here its considering correctly when day is above 12) . Please provide what should I specify here to get correct output as required. Thanks for your support in advance.

Hari2 · ‎11-26-2019

HI Team, - I want to connect to connect to a New Library with in SAS, However we have many datasets in that Library and I do not want to pull all of them rather I want to pull only one data set / Specific 2,3 datasets. - How can I do this through Libname staement. Please suggest.

Hari2 · ‎06-21-2019

Hi All, I have a variable in which we have value with Single Quote in it. Ex: ABC 'DEF. When I find for this like within a dataset, data abc; set abcd; where col1 = 'ABC 'DEF'; run; It is giving error as ' Where clause operator requires Compatible variables' And here Col1 is a Character Variable. Please suggest your inputs.

Hari2 · ‎10-05-2018

Thanks RW9. I completely agree with what you said, I just wrote in Urgency. Going forward, I will definitely post all details . Thanks for your support.

Hari2 · ‎10-05-2018

@Kurt_Bremser : Thank you So much. Its giving Output for all now. It is simple issue but Wasted my time for Long time. But just a clarification, the same code is giving Output for all subjects when I write into PDF , That's the reason I did n't try to update the code. Please help me to understand what is the difference here between PDF & RTF in this case.

Hari2 · ‎10-05-2018

HI All, I am facing issue with ODS RTF when I write with in a Loop. please check below details and help me. I want to write list of lets take 50 subjects Output into a single RTF file and for each subject we have some 10 PROC Reports(1 for each Panel) and all should come in a single Output file. But the code below , is giving Output only for last Subject, (Ex: if I have 10 subjects as Count, the output file is getting generated only for 10th Subject). I am not sure what is going wrong in this. please provide your suggestions. Thanks in advance. Sample code: %di I=1 %to &cnt; ods RTF startpage=never; ods rtf file = 'xxxxxxx.rtf'; %calldomains; /*(in this macro we have written Proc report code for each panel and roughly we have 10 Proc reports, so here for each subject we should get 10 tables frome ach panel and next subject output should come in same RTF file).*/ ods RTF startpage=Now; %end; ods rtf close; ods listing;

Hari2 · ‎09-24-2018

Thanks Cynthia. This is what I was expecting and It was helpful. One more , I actually used Background color , however its coming entire line in the page. I want to restrict it only to the Text that is available . Could you please suggest how to make it. Ex: My Output should have first line with Heading as "Your Complete Details" aligned Center with some Background color and BG Color should only fit to the Text not the entire Line.

Hari2 · ‎09-18-2018

Thanks Cynthia. This is what I was expecting and It was helpful. One more , I actually used Background color , however its coming entire line in the page. I want to restrict it only to the Text that is available . Could you please suggest how to make it. Ex: My Output should have first line with Heading as "Your Complete Details" aligned Center with some Background color and BG Color should only fit to the Text not the entire Line.

Hari2 · ‎09-12-2018

hi , Thanks for reply. but here, the thing is when I use the macro variable it replaces the text what ever we have given. But my requirement is, when I display URL through macro variable in in PDF, it should come as hyperlink (Means, in PDF when a link comes with underline, we can directly click on that to navigate). but currently macro variable is not coming with hyper link rather it just puts the required URL without Underscore.

Hari2 · ‎09-12-2018

HI All, I just want to create macro variable with hyper link and which will be used to display in ods PDF Output . for ex var1 = Google.com with hyper link. Thanks

Hari2 · ‎09-12-2018

HI Cynthia, in the above code which you suggested, How to align any specific line in Center. ex: I want to keep data in first line in CENTER. please provide which option to use. Please reply as soon as you see this. Thanks in advance.

Hari2 · ‎03-27-2018

Hi All, I am generating PDF/RTF output using PROC report. in the output file, I am getting blank row after each and every record. please suggest me how to suppress the blank rows. Thanks, Hari

Hari2 · ‎01-22-2018

Hi Reeja, Thanks for response. please see mock data below. Also see the expected graph in the attachment. Please check and provide code. Sub AE Term Start DT End Dt Relation Relation Code Action taken Action Code Outcome Outcome Code AE Start day AE End day 100 ABC yes 2 None 1 recovered 1 7 54 100 CDE No 1 None 1 resolving 2 12 19 100 ache No 1 Interrupted 2 resolving 2 33 44 100 aaaa yes 2 Interrupted 2 resolving 2 12 18 100 gggg yes 2 Discon 3 resolving 2 22 55 100 eeee No 1 None 1 recoverd 1 13 14 100 tttt No 1 None 1 resolving 2 16 19 100 yyyyy yes 2 Discon 3 recoverd 1 4 20

Hari2 · ‎01-22-2018

HI All, I need to generate a Graph for AE data for each subject considering AE Start, End date, Relation, Action taken and AE Outcome. Please refer sample Graph attached. I am using SAS 9.4 I have a derived dataset of AEstdy and AEenddy. (Ex: AEstdy=5 means AE started n 5th day from the first dose given) Requirement: 1. X-Axis should be have data points from AE start and end day. Ex: consider 0 to 200. 2. Y axis should be grouped with Adverse event. 3. For each subject we should have a separate page where we have to show the vector line from which day it started till ended. also we have to show Relation, Action taken and AE Outcome, Severity on top of the vector line with some codes (1,2,3 for actual values) and we should indicate these codes in the form of legends at the end of the page to understand. please refer attached image where I need similar Graph , request you to help me on this. Please consider similar variable names and provide SGPLOT code get this kind of Graph.

Hari2 · ‎01-06-2018

Thanks a Lot Cynthia. 🙂

Online Status	Offline
Date Last Visited	‎05-23-2022 11:17 AM

Re: Check latest sas log for errors and send auto email based on the r...

Re: Check latest sas log for errors and send auto email based on the r...

Re: Check latest sas log for errors and send auto email based on the r...

Check latest sas log for errors and send auto email based on the resul...

SAS informat to convert "worddate along with time" into date variable

Re: Reading Data separated with Multiple delimiters and saved in a si...

Re: Reading Data separated with Multiple delimiters and saved in a si...

Re: Reading Data separated with Multiple delimiters and saved in a si...

Reading Data separated with Multiple delimiters and saved in a single...

Re: Avoid Warnings, when Null values in Variables used in PROC TRANSPO...

Re: How to pull specific datasets into a new Library

Re: Need Help to search value which has quote in it in sas dataset

Re: ODS RTF not giving Output in a loop for all subjects

Re: ODS RTF not giving Output in a loop for all subjects

Re: ODS RTF not giving Output in a loop for all subjects

Issue with ANYDTDTM

How to pull specific datasets into a new Library

Need Help to search value which has quote in it in sas dataset

Re: ODS RTF not giving Output in a loop for all subjects

Re: ODS RTF not giving Output in a loop for all subjects

ODS RTF not giving Output in a loop for all subjects

Re: Get the value of a macro variable into a BOX

Re: Get the value of a macro variable into a BOX

Re: How to Create a SAS Macro variable with Hyper Link

How to Create a SAS Macro variable with Hyper Link

Re: Get the value of a macro variable into a BOX

Empty Rows in the Proc Report Output

Re: Generate AE Graph for individual subjects

Generate AE Graph for individual subjects

Re: Get the value of a macro variable into a BOX