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
I think a two-way table would do just as well
input 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
proc tabulate data=have format=5.0;
class itemid itemname;
table itemname, diff*itemid*max="";
View solution in original post
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!
Submit your idea!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.