@mkaur89 wrote:
Adding the commas did not really help. It just added that many comes to the front of the row. I would want the commas separating the prefixes.
My company is in the process of converting all of our data extraction queries to SAS. A large number of our queries are in Hyperion and I've come across this scenario in multiple queries. Our data in being extracted from a teradata server so depending on the filters i input i have no idea how many results i will end up getting.
The approach used in the data doesn't care how many records there are for each ID. It does it automatically. Did you try any of those solutions, and if you did, please post the code that didn't work.
If you're just learning, try it with example data first, even just running the code/solution from the other threads and then figure out how your data is different than the example to figure out where the issue is.
... View more