I need to run sas profile on a table with Employee names, addresses, SSN , sex etc.
what procedures can I use?
used FREQ, will only give me frequency and I want to min and max as well.
Means/Summary can give me mean of observation with missing data but since these are character fields what other procedure can be used and waht are the benefits?
Thanks,
Amar
@amarkaur wrote:
I need to run sas profile on a table with Employee names, addresses, SSN , sex etc.
what procedures can I use?
used FREQ, will only give me frequency and I want to min and max as well.
Means/Summary can give me mean of observation with missing data but since these are character fields what other procedure can be used and waht are the benefits?
Thanks,
Amar
I suggest providing some example data and what the result should look like after "profiling".
I do not see where min and max of name, address, ssn, sex make sense. Do you mean something related to the min count??
I am very sure I do not follow what "mean of observation with missing data" is supposed to be as the mean of missing is missing.
Example for Name, addresses , Zip , Sex
Using IDQ tool when I profile table for each field, I get how many unique values, how many missing/null values, minimum value, maximum value for that field (length), datatype etc.
Can I get similar results using any SAS procedure.
Using proc freq, I do get the frequency and counts of missing values.
Thanks,
Amar
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.