About DrAbhijeetSafai

DrAbhijeetSafai

This did not help me directly, because that was not my question, but this answer helped me indirectly to solve another problem. Thanks. - Dr. Abhijeet Safai

DrAbhijeetSafai

Simply Amazing! Thanks! - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎11-02-2023

Hi Peter, Greetings! I also had the similar question as how to create a format from a dataset. I found following two sources useful. 1) SAS Documentation: https://documentation.sas.com/doc/en/vdmmlcdc/8.1/proc/n1e19y6lrektafn1kj6nbvhus59w.htm 2) A paper with title "Creating a Format from Raw Data or a SAS® Dataset " by Wendi L. Wright : https://support.sas.com/resources/papers/proceedings/proceedings/forum2007/068-2007.pdf The paper is of 2007 and in documentation, a table named 'The CTLR Dataset' gives lot of information. However, if there is any better way of understanding it, please let me know. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎10-27-2023

Thanks a lot! It was very helpful! 👍 - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎10-17-2023

I found the reply helpful, but it is difficult to read the answer in current alignment. Hence, I am wring the same answer with proper alignment. ================================================================================= data _NULL_; format dt datetime20. dt2 E8601DT20. ; dt=datetime(); dt2=dt; put dt= dt2=; txt=put(dt,datetime20.); txt2=put(dt2,E8601DT20.); put txt= txt2=; run; http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm ================================================================================ Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎10-15-2023

I was able to solve it with the help of following paper. Especially their idea of creating numeric sorting variables for soc and pt worked. PharmaSUG China 2015 – Paper 02 Fifty Shades of Sorting Haibin Shu, AccuClin Global Services LLC, Wayne, PA John He, AccuClin Global Services LLC, Wayne, PA Elena Rojco, DentaQuest, Salem, NH Link: https://www.lexjansen.com/pharmasug-cn/2015/PT/PharmaSUG-China-2015-PT02.pdf Thank you. Dr. Abhijeet Safai

DrAbhijeetSafai · ‎10-15-2023

At least at the moment, I have same query. I will share here if the query gets solved or if I get answer. Thanks. - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎09-22-2023

Thank you SASKiwi. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎09-22-2023

Thank you very much! It is SAS 9.4 and it is running on a server. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎09-21-2023

Dear SAS Experts, Greetings! I need to run a programme in batch mode and running the programme is taking say some minutes to hours. I want to ask if I can work in another programme for some other work in SAS when the first programme is running? Currently I am not trying this because of risk of some errors. But I have seen once that I can open another programme when first one is running in batch mode. My question is if I can run a programme in batch mode and work in another programme while first one is running in batch mode? I am able to see that I can do that but my question is if it is harmful and is it advised to do it? Thanks in advance. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎09-11-2023

I found this interesting!

DrAbhijeetSafai · ‎07-17-2023

That worked for me. Thanks. - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎12-05-2022

Dear All, Greetings! I think now I know what the issue was as it is solved. The issue was that I was defining labels again when some columns appear twice in the report. I understood that the labels of columns need not be defined twice in the define statement after forward slash. That was the issue. Sharing here because it has got solved. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎11-21-2022

Dear Madam, Greetings! I think that the source of issue is from the data itself. Because headers are not getting repeated for other reports but only for this one report coming from one dataset. It is a PDF in which I have collected multiple reports (about 30) below each other. It is a task related to patient profiles. As guided by you, I will surely create a new post and will refer back to this post in that post if the issue persists and if it is related to SAS. At the moment, I think that it is a data issue and hence it needs to be resolved at the data level. Thanks a lot for the quick response. Thanking you, Yours sincerely, - Dr. Abhijeet Safai

DrAbhijeetSafai · ‎11-18-2022

Thanks. I am happy to see that there are solutions to this problem because I am facing the same problem now. I cannot use RTF because use of PDF is the requirement of the work. I will try to see if I can use other ways to solve the issue. I am happy to find the others also have faced this issue and there might not be something wrong in the code. Thanks for this discussion. - Dr. Abhijeet Safai

Online Status	Offline
Date Last Visited	3 weeks ago

Re: remove trailing blank for %let macro variable

Re: Convert .XPT to SAS Datasets

Re: Make Format from DataSet

Re: Nested header with underlining not working correctly

Re: How to convert DATETIME to ISO8601 format ?

Re: How to sort in descending order by SOC, PT

Re: How to sort in descending order by SOC, PT

Re: Can I run a programme in batch mode and work in another programme?

Re: Can I run a programme in batch mode and work in another programme?

Can I run a programme in batch mode and work in another programme?

Re: remove trailing blank for %let macro variable

How can I import XML file into SAS?

Re: How can I import XML file into SAS?

Re: Convert .XPT to SAS Datasets

Re: How to convert date9. to datetime20. or vice versa using proc sql

Re: How to convert DATETIME to ISO8601 format ?

Re: remove trailing blank for %let macro variable

Re: Convert .XPT to SAS Datasets

Re: Make Format from DataSet

Re: Nested header with underlining not working correctly

Re: How to convert DATETIME to ISO8601 format ?

Re: How to sort in descending order by SOC, PT

Re: How to sort in descending order by SOC, PT

Re: Can I run a programme in batch mode and work in another programme?

Re: Can I run a programme in batch mode and work in another programme?

Can I run a programme in batch mode and work in another programme?

Re: if observation in one dataset is in another dataset

Re: Title won't left align PROC REPORT

Re: titles display twice in pdf file

Re: titles display twice in pdf file

Re: titles display twice in pdf file

SAS User Groups

The Curiosity Cup

SAS Analytics Explorers