topic Re: How to accomplish this in SAS Programming

How to accomplish this

sasbasls — Tue, 01 May 2012 15:11:40 GMT

I want to loop thru each of record to see if value in a particular date fields gets changed over time. There are multiple records for same entity in my table(kind of history table).

Any idea how to do this using data setp/proc sql.

thanks in advance,

sasbase

Re: How to accomplish this

asishgautam — Tue, 01 May 2012 15:25:31 GMT

can you give me some more details as to how the data is stored? a list of column names for example...

Re: How to accomplish this

sasbasls — Tue, 01 May 2012 15:37:29 GMT

For example,

I have a table where historical info related to that entity is stored over time.

Entity_ID, col 2 , col 3 ...etc , and few date fields. So I want to check if a particular entity id is changed over time(against one of date fields) or not ?

Re: How to accomplish this

JasonDiVirgilio — Tue, 01 May 2012 20:39:02 GMT

You may want to show some sample data and sample output. I'm guessing you want something like:

data have;
input entity_id $4. datecol1 ddmmyy8.;
format datecol1 mmddyy8.;
datalines;
1234 010111
1234 010111
1234 010111
1234 030111
1235 020111
1235 020111
1235 030111
1235 040111
;
run;

proc sql;
select distinct entity_id, datecol1 from have;
quit;

Output would be:

entity_id datecol1

--------- ----------

1234 01/01/11

1234 01/03/11

1235 01/02/11

1235 01/03/11

1235 01/04/11

Re: How to accomplish this

Reeza — Tue, 01 May 2012 22:44:26 GMT

Not 100% clear on what you're looking for, an example of what your data looks like would be helpful.

Using Jason data the following will give you distinct entries for records where the datecol1 are have different entries. You can remove the distinct keyword for all entries instead.

proc sql;

create table want as

select distinct * from have

group by entity_id

having min(datecol1) ne max(datecol1);

quit;

Re: How to accomplish this

Ksharp — Wed, 02 May 2012 06:09:19 GMT

I think you should post some sample data and output you want to clarify your question.

Ksharp