HI ,
I have a dataset like below which has itemid and itemname Diff is Difference
So for id id 123 Amount_1 and Amount_2 are off and for id 456 Amount_1 and Amount_2 are off but for 678 Amount_1,
Amount_2,Amount_3,Amount_4 are off how can we best show in a graph for all the three . Can anyone please help
itemid | itemname | Diff |
123 | Amount_1 | 1 |
123 | Amount_2 | 1 |
456 | Amount_1 | 1 |
456 | Amount_2 | 1 |
456 | Amount_3 | 1 |
678 | Amount_1 | 1 |
678 | Amount_2 | 1 |
678 | Amount_3 | 1 |
678 | Amount_4 | 1 |
Thank you
I think a two-way table would do just as well
data have;
input itemid itemname $ Diff;
datalines;
123 Amount_1 1
123 Amount_2 1
456 Amount_1 1
456 Amount_2 1
456 Amount_3 1
678 Amount_1 1
678 Amount_2 1
678 Amount_3 1
678 Amount_4 1
;
proc tabulate data=have format=5.0;
class itemid itemname;
var diff;
table itemname, diff*itemid*max="";
run;
I think a two-way table would do just as well
data have;
input itemid itemname $ Diff;
datalines;
123 Amount_1 1
123 Amount_2 1
456 Amount_1 1
456 Amount_2 1
456 Amount_3 1
678 Amount_1 1
678 Amount_2 1
678 Amount_3 1
678 Amount_4 1
;
proc tabulate data=have format=5.0;
class itemid itemname;
var diff;
table itemname, diff*itemid*max="";
run;
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.