For 50 US states, we have different companies and we measure performance and other metrices of all the companies. I have created a dataset in excel for each metrix by states and companies .
First, I need to validate the data, which procedure should I use??
Also, I need to create trend charts for each state and by companies so that we can compare the performance in each state.
I tried using proc gplot but it is not working.
Any suggestion would be appreciated.