I have this big dataset were I want to select the first entry of the each customer by date in to the register so that I can put them in a new table/dataset were each customer is represented once.      My dataset looks like this:   Data Have;   Customer_ID$   ent_date          Code$           1                   1/1/2018             N06 1                   1/2/2018             A10 2                   3/5/2018             B20 2                   4/20/2018           B20 3                   5/27/2018           Y20 4                   9/1/2018             N06AA 4                   9/16/2018           A10B 4                   10/12/2018         B20.     Data Want;   Customer_ID$   ent_date          Code$           1                   1/1/2018             N06 2                   3/5/2018             B20 3                   5/27/2018           Y20 4                   9/1/2018             N06AA     Thanks! ... View more

Hello!   I have a dataset (simplified example) with only one variable.    Data have; input class$; A A A B B C C C C D   I would like to calculate the percentages and counts of each variable in my dataset using PROC SQL.   Output would be similiar to proc freq:   Desired output should be ;   class Frequency Percent A 3 30 B 2 20 C 4 40 D 1 10   How can I do this with PROC SQL?   Thanks! ... View more

Hello!   I have a dataset (simplified example) containing the following variables;   Data salary; input age_group$ gender$ year$ salary; 25-29 M 2017 25000 25-29 M 2018 30000 25-29 W 2017 30000 25-29 W 2018 35000 30-34 M 2017 25000 30-34 M 2018 50000 30-34 W 2017 25000 30-34 W 2018 75000     I would like to create a table looking like this:   25-29 (age_group) 30-34 (age_group)   Gender Gender   M W   M W     Salary Salary   Salary Salary     Sum Sum   Sum Sum   2018 64000 35000   50000 75000   2017 34000 30000   25000 25000     M and W should be under agegroup and gender, not separeted ( there was an error in the HTML when I made this post).   Same table but from notepad;     25-29 (age_group) 30-34 (age_group)   Gender Gender   M W   M W    Salary Salary   Salary Salary    Sum Sum   Sum Sum  2018 64000 35000   50000 75000  2017 34000 30000   25000 25000         I have tried proc tabulate and proc transpose, but probably I am doing somethin wrong as I don't get the result I want.  Would be super if someone could provide a code for this.   ... View more