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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.