> As an alternative, you could use a modify statement > to update the master data set with the transaction > data set. > > data master; > modify master transaction; > by key_variable; > run; > > If you use modify, neither dataset requires sorting. thanks for your advice. I tried MODIFY statement. The problem is my master file is win_64 and trans is win_32. So the MODIFY statement failed. Anyway, this is the problem on our end. ... View more

> > very long time to sort. Even worse, the newly > updated > > master file is not sorted. So next time I have to > > sort it again. > > Why do you think that? OK, I used UPDATE statement to create a new dataset. Then I did proc contents to that new datset, and it was not sorted. So if I update the master file weekly, which means I have to sort the master file every time I use UPDATE. ... View more

Thank you for your input. The code works perfectly. But if the trans file contains new records, the new obs will not be added into master file. > OK.I will give it a try.Even though I have not > touched Hash Table for a long time.It is time to > check some papers about Hash Table. > And Thank you for letting me know another additional > advantage of Hash Table. > and I found it is very efficient than sql. 🙂 > > [pre] > data master; > set sashelp.class; > un; > data trans; > length name $ 8 sex $ 1; > name='Robert' ;sex='N'; output; > name='Thomas' ;sex='A'; output; > name='William' ;sex='Y'; output; > un; > > data master(drop=rc); > declare hash hh(hashexp:10); > hh.definekey('name'); > hh.definedata('sex'); > hh.definedone(); > > do until(last); > set trans end=last; > hh.add(); > end; > > do until(_last); > set master end=_last; > rc=hh.find(); > output; > end; > stop; > run; > [/pre] > > > Ksharp ... View more

Thanks for your help. ... View more

Currently the x-axis is day, can I sum the value in the same month and output, so the x-axis is month/year? thanks I added midpoints "by month" and format days monyy. it looks like it works. Message was edited by: neilxu ... View more

thank you Robert. I was thinking about changing the dataset layout. It looks like I have to do this first then use vbar to plot. thanks for the code, very very helpful. ... View more