Profiling Character data fields in SAS

[amarkaur]

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

[ballardw]

---

@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.

[amarkaur]

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 

[Reeza]

Characterize Data task in EG or SAS Studio does that.

[Reeza]

SAS EG and Studio have a characterize data task that will analyse the data.
However, conceptually, the minimum and maximum from character variables are not informative on their own. You can get missing reports from PROC FREQ partly using the NLEVELS options. That's fairly well documented on here though.