Value Comparison Results for Variables |
_______________________________________________________________________________________________________________________ |
|| Actual Sales |
|| Base Compare |
COUNTRY STATE PRODTYPE PRODUCT YEAR MONTH || Actual Actual Diff. % Diff |
__________ ____________________ __________ __________ ____ _____ || _________ _________ _________ _________ |
|| |
Canada British Columbia FURNITURE BED 1998 Janua || 1.522,00 1.674,20 152.2000 10.0000 |
Canada British Columbia FURNITURE BED 1998 Febru || 285,00 313,50 28.5000 10.0000 |
Canada British Columbia FURNITURE BED 1998 March || 502,00 552,20 50.2000 10.0000 |
Canada British Columbia FURNITURE BED 1998 April || 48,00 52,80 4.8000 10.0000 |
I am not sure what you are saying is the issue.
Are you just talking about how SAS in general is displaying the variable ACTUAL? Or is it something specific to PROC COMPARE is the issue? Or perhaps to ODS EXCEL?
Is the variable named ACTUAL numeric or character? What display format do you have attached to it in your two input SAS dataset? Does it display the values the way you want?
Unfortunately I have missunderstood the commax format. What I'm looking for is found in the nlnum format and the locale of my country.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.