How to apply mean filter in sas jmp2/11/2023 ![]() ![]() Double click the "Join" picture, and change it to a Left Join. Drag the "COUNT" field into Select Data.Ĭlick the "Join Tables" button, and in the join window make sure the tables are joined on Employee_ID. ![]() Drag all of the columns into the "Select Data" tab.Ĭlick the "Add Tables" button, and select the table you created in Step 1. Here's a simple example:īuild a new query on your original dataset. ![]() The general principle is to join this new table back to your original table, and get some kind of information from the join. This depends on what you need to do next. You should get a list of all of the Employee_ID values that appear more than once in your input file. In the "Filter Data" tab, drag this variable into the "Filter the summarized data" area, and set the filter to > 1. This will cause EG to create a variable which is the count of that value of Employee_ID. On the second one, in the "Summary" column, select "Count". You'll have two columns, probably "Employee_ID" and "Employee_ID1". Drag Employee_ID into the "Select Data" box, and then drag it in again.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |