cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
yj111
‎07-11-2022
  • 5 Posts
  • 6 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: How to compare the record with previous one to make change log dat...

by Fluorite | Level 6 in SAS Programming
‎07-07-2022 05:10 PM
‎07-07-2022 05:10 PM
Thank you. I do have over 100 fields need compare, I would think maybe array() with lag() function combination work on this situation ... View more

How to compare the record with previous one to make change log dataset

by Fluorite | Level 6 in SAS Programming
‎07-07-2022 04:02 PM
‎07-07-2022 04:02 PM
I need create change log dataset which need compare the records in historical daily snapshot dataset and capture all the changes and put into change log data set. the daily snapshot dataset looks like below: report date ID_PART PART_TYPE PART_NM PART_COST 1/1/2022 1A1  AA BOLT   $                                   3.00 1/2/2022 1A1  AA BOLT   $                                   3.00 1/3/2022 1A1  AA BOLT   $                                   4.00 1/4/2022 1A1  AA BOLT   $                                   4.00 1/5/2022 1A1  AA BOLT   $                                   4.00 1/6/2022 1A1  BB BOLT   $                                   4.00 1/7/2022 1A1  BB BOLT   $                                   4.00 1/8/2022 1A1  BB BOLT   $                                   4.00 1/9/2022 1A1  BB BOLT   $                                   4.00 1/10/2022 1A1  BB BOLT   $                                   4.00 1/11/2022 1A1  BB BOLT   $                                   4.00 1/12/2022 1A1  CC BOLT   $                                   5.00 1/13/2022 1A1  CC BOLT   $                                   5.00 1/14/2022 1A1  CC BOLT   $                                   5.00 The result I am looking at is something like below:   any suggestions?  THANK YOU!!   ... View more

Re: How to find dynamic minimun value with macro?

by Fluorite | Level 6 in SAS Programming
‎10-11-2021 05:49 PM
‎10-11-2021 05:49 PM
thank you Paige! small changes I made from your suggestion: data want; set have; array X X1-X6; if _n_>=1 and _n_<5 then min_for_row=min(X(_n_+1),X(_n_),X(_n_+2)); else if _n_=5 then min_for_row=min(X(_N_-1),X(_N_)); ELSE IF _N_=6 THEN MIN_FOR_ROW=X(_N_); run; ... View more

Re: How to find dynamic minimun value with macro?

by Fluorite | Level 6 in SAS Programming
‎10-11-2021 05:28 PM
‎10-11-2021 05:28 PM
It works perfectly!!    Thank you! ... View more

How to find dynamic minimun value with macro?

by Fluorite | Level 6 in SAS Programming
‎10-11-2021 04:40 PM
‎10-11-2021 04:40 PM
I need find dynamic minimum value depend on _n_ , some like below,   Column K is the field I want, but the min range is changed by N. I did have some marco set up but it did not work since it did not take _N_ as numeric  %LET T=_N_; want =MIN(OF X(&T)-X(&T+3));   anyone can help?  many Appreciate here!     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-11-2022 11:48 AM
Likes given to
Quick links