About Kamohelo_A

Kamohelo_A · ‎08-01-2021

Hi I am trying to create a sas bargraph that one can then filter on to view specific items. Suppose the x-axis is the individual number of passes and the y-axis is the count. Then: Proc Sgplot Data = Inputs; Vbar = individual_ID; Run; should give me that noting that the individual might say play tennis, rugby, soccer and chess then I can add a Group = sport to get a single bar for an individual with stacks on it? But say I want to filter on just rugby and still track the individual number in the x-axis. Then finally, what if I want to filter on just on individual number to view more detail into them only across the various sports. Kindly assist on the latter components

Kamohelo_A · ‎07-26-2021

THANKS FOR THE HEADS UP

Kamohelo_A · ‎07-26-2021

Never mind. I resolved it using the following: PROC SQL; CREATE TABLE DATA_1 AS SELECT DATA_INITIAL_1.* , OTHER_DATA.COLUMN5 FROM DATA_INITIAL_1 LEFT JOIN OTHER_DATA ON DATA_INITIAL_1.COLUMN1 = OTHER_DATA.COLUMN1 AND DATA_INITIAL_1.COLUMN2 = OTHER_DATA.COLUMN2 AND DATA_INITIAL_1.COLUMN3 = OTHER_DATA.COLUMN3 AND DATA_INITIAL_1.COLUMN4 = OTHER_DATA.COLUMN4; QUIT;

Kamohelo_A · ‎07-26-2021

Morning I need urgent help, how do you do a join or data step merge in sas between two tables that have multiple columns that must be merged otherwise if you merge on just the one result the data table that gets created breaks and provided a number of rows that is higher than the initial table to which you do a left join. Note that I need to merge at most three columns across two tables that share the exact same three columns with the table in the left join having more columns than the other table.

Online Status	Offline
Date Last Visited	‎08-02-2021 10:52 AM

sgplot

Re: SAS PROC SQL LEFT JOIN

Re: SAS PROC SQL LEFT JOIN

SAS PROC SQL LEFT JOIN

sgplot

Re: SAS PROC SQL LEFT JOIN

Re: SAS PROC SQL LEFT JOIN

SAS PROC SQL LEFT JOIN