Prev: controlling Proc mixed output
Next: model selection - logistics model
From: data _null_; on 12 Aug 2010 16:46
On Aug 12, 2:55 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
> On Aug 12, 3:08 pm, "data _null_;" <datan...(a)gmail.com> wrote:
>
>
>
>
>
> > On Aug 12, 1:47 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
>
> > > On Aug 12, 2:19 pm, "data _null_;" <datan...(a)gmail.com> wrote:
>
> > > > On Aug 12, 12:40 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
>
> > > > > Hi All,
>
> > > > > This is a real problem:
>
> > > > > There is a dataset A which is updated everyday through user
> > > > > interaction. Next day, I run a query to subset A and
> > > > > get data set B.
>
> > > > > Now I have to run query everyday to get B in order to capture the
> > > > > change in A in previous day.
>
> > > > > Is there a way to only capture the change without running the subset
> > > > > query since it takes long time to go through
> > > > > 10M records?
>
> > > > > Any thoughts are appreciated!
>
> > > > > Kevin
>
> > > > You can use the AUDIT feature, see PROC DATASETS.
>
> > > > This will maintain a dataset(auto trail) of changes to A.- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > How to update B if changes of A is recorded in audit trail? Thanks for
> > > your reply!- Hide quoted text -
>
> > > - Show quoted text -
>
> > I didn't understand I thought you just wanted to track changes in A.
>
> > So A is transaction data for B?
>
> > How do you update B now?  Show code with example data would be good.- Hide quoted text -
>
> > - Show quoted text -
>
> data A;
>    input x @@;
>    datalines;
>    1 2 3 4 876 98 09056
> ;
> run;
>
> data B;   /* QUERY_B */
>     set A;
>     if x < 100;
> run;
>
>  "A" was update everyday, so I have to submit "QUERY_B" to update B
> and it take long time.
> My question is: is it possible to update B without submitting
> "QUERY_B"?
> Audit trail is useful to track the changes in A. Is it possible to use
> that audit trail info to update
> B?
>
> Did I describe the problem clearly? Thanls!- Hide quoted text -
>
> - Show quoted text -

You are subsetting B based in a constant. I don't call that
updating. It does recreate B with possibly new data.

If you know what was changed(audit data) in A how would you use that
information to add or delete of changes records in B. This is what
variables are required complete those operations?
From: kwu0914 on 13 Aug 2010 11:47
On Aug 12, 4:46 pm, "data _null_;" <datan...(a)gmail.com> wrote:
> On Aug 12, 2:55 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
>
>
>
>
>
> > On Aug 12, 3:08 pm, "data _null_;" <datan...(a)gmail.com> wrote:
>
> > > On Aug 12, 1:47 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
>
> > > > On Aug 12, 2:19 pm, "data _null_;" <datan...(a)gmail.com> wrote:
>
> > > > > On Aug 12, 12:40 pm, kwu0914 <kwu0...(a)gmail.com> wrote:
>
> > > > > > Hi All,
>
> > > > > > This is a real problem:
>
> > > > > > There is a dataset A which is updated everyday through user
> > > > > > interaction. Next day, I run a query to subset A and
> > > > > > get data set B.
>
> > > > > > Now I have to run query everyday to get B in order to capture the
> > > > > > change in A in previous day.
>
> > > > > > Is there a way to only capture the change without running the subset
> > > > > > query since it takes long time to go through
> > > > > > 10M records?
>
> > > > > > Any thoughts are appreciated!
>
> > > > > > Kevin
>
> > > > > You can use the AUDIT feature, see PROC DATASETS.
>
> > > > > This will maintain a dataset(auto trail) of changes to A.- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > How to update B if changes of A is recorded in audit trail? Thanks for
> > > > your reply!- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > I didn't understand I thought you just wanted to track changes in A.
>
> > > So A is transaction data for B?
>
> > > How do you update B now?  Show code with example data would be good..- Hide quoted text -
>
> > > - Show quoted text -
>
> > data A;
> >    input x @@;
> >    datalines;
> >    1 2 3 4 876 98 09056
> > ;
> > run;
>
> > data B;   /* QUERY_B */
> >     set A;
> >     if x < 100;
> > run;
>
> >  "A" was update everyday, so I have to submit "QUERY_B" to update B
> > and it take long time.
> > My question is: is it possible to update B without submitting
> > "QUERY_B"?
> > Audit trail is useful to track the changes in A. Is it possible to use
> > that audit trail info to update
> > B?
>
> > Did I describe the problem clearly? Thanls!- Hide quoted text -
>
> > - Show quoted text -
>
> You are subsetting B based in a constant.  I don't call that
> updating.  It does recreate B with possibly new data.
>
> If you know what was changed(audit data) in A how would you use that
> information to add or delete of changes records in B.  This is what
> variables are required complete those operations?- Hide quoted text -
>
> - Show quoted text -

I got what I need by using the audit trail file. Thank you, data_null!
First  |  Prev  | 
Pages: 1 2
Prev: controlling Proc mixed output
Next: model selection - logistics model