About KMWWN156

KMWWN156 · ‎07-12-2024

I need to keep the latest dated transactions, so if sorting Ascending, then it would be the first 20, if descending it would be the last 20 Does that change anything within the code as i cant seem to get the results i want. Thanks,

KMWWN156 · ‎07-12-2024

I am looking at a large dataset of payment values and want to keep the last 20 records per account - How would i do this? Probably very simple but cannot figure this out. Example code for keeping last 1 record per account is as follows. Data TransRef; Set Transactions; by Accno TranDate; If Last.Accno; run; Thanks I have tried OBS and retain but no luck

KMWWN156 · ‎03-14-2024

Thanks all, there is some code stored within SAS EG which assigns my libraries and Macro - It appears that this needs to be run within the Addin before any code can be ran as the Addin doesn't run this automatically like EG does.

KMWWN156 · ‎03-13-2024

Hi, I have attempted to use the SAS Addin for the first time and are receiving the following error when running code within excel. I am a very basic user and imagine the answer will also, hopefully, be very simple. 18 proc sql; 19 connect to &rdbms as biw(&dbc_info); _ _ 22 79 200 200 WARNING: Apparent symbolic reference RDBMS not resolved. WARNING: Apparent symbolic reference DBC_INFO not resolved. ERROR 22-322: Expecting a name. ERROR 79-322: Expecting a ). ERROR 200-322: The symbol is not recognized and will be ignored. I have code set to run each time I use SAS EG 8.3 and see rdbms refers to my auto Teradata log on. How or what do I need to do within the Addin to get this to run?

Online Status	Offline
Date Last Visited	‎07-15-2024 01:28 PM

Re: Proc SQL Keep Last n

Proc SQL Keep Last n

Re: SAS Office Addin rdbms issue

SAS Office Addin rdbms issue

Re: Proc SQL Keep Last n

Re: Proc SQL Keep Last n

Proc SQL Keep Last n

Re: SAS Office Addin rdbms issue

SAS Office Addin rdbms issue