topic Re: Profiling Character data fields in SAS in SAS Programming

Profiling Character data fields in SAS

amarkaur — Tue, 24 Sep 2019 14:54:45 GMT

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

Re: Profiling Character data fields in SAS

ballardw — Tue, 24 Sep 2019 14:58:43 GMT

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

Re: Profiling Character data fields in SAS

Reeza — Tue, 24 Sep 2019 17:20:55 GMT

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.

Re: Profiling Character data fields in SAS

amarkaur — Tue, 24 Sep 2019 17:55:20 GMT

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

Re: Profiling Character data fields in SAS

Reeza — Tue, 24 Sep 2019 18:13:04 GMT

Characterize Data task in EG or SAS Studio does that.