That worked! Many thanks! 🙂   - Dr. Abhijeet Safai ... View more

Interesting! Thanks! 🙂   - Dr. Abhijeet Safai ... View more

Thank you @FreelanceReinh  for the information. I wanted this to happen in work library, so Universal Viewer will not work there. However, another thing which you pointed out helped.    You brought my attention to ballardw's solution Re: In VIEWTABLE, How Can I Directly Go to Certain Observation?  again. I had read it many many times but was not able to understand it. This time I got to know why I was not able to understand it.   I was not able to understand the meaning of command line. It can be enabled from Tools > Options > Preferences > View. Once this command line is enabled, use of forward on command line was the think I was looking for.   Your information about Tools > Options etc., helped me to look for it and that helped to understand command line and after that ballardw's solution made sense. Thanks to ballardw and to you @FreelanceReinh !    - Dr. Abhijeet Safai     ... View more

I got the answer at least to my question. Thanks to my colleague Akash Kadam.    First let me share that my question was not related to SAS Viya but it was related to Base SAS.    I used following code in the programme 'inside' proc sgplot and the issue was solved.    styleattrs datacontrastcolors=(black) datacolors = (lightgray gray);    Yes, it was that simple. Thanks. Thanks to Akash once again!   - Dr. Abhijeet Safai         ... View more

Correct! I am also finding answer to this question. The question is - There are two colors in the graph for bars - blue and red. Now I want to change these colors. What is the way to change these colors? Is there is some option somewhere where I can use something like colors = (gray, green) etc.? Thanks in advance.    - Dr. Abhijeet Safai ... View more

I would like to post it again that the solution given by @Tom is wonderful. He said that the records are not unique and that gave me hint and I was able to find out a variable which was not previously included in the by statement of proc transpose and this problem was solved. I am posting here again because again I faced the same problem and it got solved by addition of a variable in by statement which was not added previously. So the solution to this kind of problem is mostly - to find out the variable which is not added in by statement of proc transpose and to add it.    Thank you.   - Dr. Abhijeet Safai  ... View more

These things are known most of the times, but ready reference here is really helpful! Thank you.   - Dr. Abhijeet Safai ... View more

Thank you!   - Dr. Abhijeet Safai ... View more

@Tom  Thanks for your response.    However, I have not posted any code. Maybe you wanted to say - The code posted here has opposite problem.    Thank you.   - Dr. Abhijeet Safai ... View more

In my case, I had closed a %do loop, so I was not able to find out the error. Later I found out with the help of a colleague (Sushil)  that it was closed with end (and not %end). So the problem was I was trying to close %do loop with end and not %end, so the error.    Thank you.   - Dr. Abhijeet Safai ... View more

Somehow a similar problem just got solved for me. An ending bracket ")" was given extra in one of the calls to a macro and after removing that the problem got solved for me.    Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Correct!   I would like to go view nth record directly. Currently I have to keep scrolling till that record comes but can I go to a particular number of (nth) record directly? It will be a great feature if it could be implemented.    Thank you. - Dr. Abhijeet Safai ... View more