Hi Fredrike, Thanks for your Reply. This is exactly what I was looking for. But in my case the level of Managers is unknown. An employee can have two levels of Managers above him while other might have six levels of Managers. Is there any way, that can be achieved. Thanks, Karuna
... View more
Thanks for the prompt reply, Scott. But I think i was not able to explain the problem in hand. I too have created a Geo Hierarchy with Country, State and City. But currently, I have two fields Emp Id and Mngr Id, for 1st level, we will find the Mngr Id for the Employee; for the 2nd level, the Mngr id will become Emp Id and we will find the Mngr Id till we get to the highest Level. Hope I am clear this time.
... View more
Hi, I have Employee data in which Employee id and Manager id are present. An employee can have many levels of Managers for eg. his Manager, his Manager's Manager and so on. Is there any way by which when I click on Employee, I get the data like EMP -> his Manager -> his Manager's Manager -> upto the level specified in SAS VA. Thanks in advance!! Karuna
... View more
To convert a character date into Date format, you can use the following: In the Report designer, create a 'New Calculated Item' and use the Parse operator(under simple text). For example, Parse('Joining_date', 'DATE9.') returns a date value where 'Joining_date' is my Date column name and 'DATE9.' is the date format.
... View more