About miaeyg

miaeyg · ‎08-20-2021

You can sort the dataset by ID and also within ID in reverse order (by descending) "months" and then use the LAG function to get the previous 6 values and sum them up whilst checking if you are in the same value of ID in the LAG as in the current record. There is a paper on this topic which discusses this issue and offers also a different approach without the LAG function: https://support.sas.com/resources/papers/proceedings16/11221-2016.pdf

miaeyg · ‎08-20-2021

מי שניסה להשתמש בפורמט הבינלאומי NLDATE להצגת תאריך בטח נתקל בתצוגה השגויה הבאה: 11 data _null_; 12 td = today(); 13 put td nldate.; 14 run; 20 אוגוסט 2021 אז מה עושים? אפשרות אחת לעבור להשתמש בפורמט אחר בשם HDATE שמותאם במיוחד לקהל הישראלי או אם חשוב לכם להמשיך להיות בינלאומיים ולהמשיך להשתמש ב NLDATE אזי ראו את הקוד להלן שמתקן את הבעיה: %let datefmt = %nrstr(%Y %B)%sysfunc(byte(253)) %nrstr(%d); proc localedata; load registry; contents DATE_FORMAT; modify key=DATE_FORMAT value="&datefmt"; save registry / _ALL_ syntax=SAS; quit; שימו לב שלאחר הרצת הקוד יש להוסיף את האופציה הבאה להפעלה של SAS -localedata registry מקווה שזה עזר. מזכיר לכם שמי שמתענין יש גם פורמטים של תאריך לפי לוח שנה עברי. אייל

miaeyg · ‎08-14-2021

Hi @data_null__ You did not indicate which encoding your SAS session was started with and you also did not post your SAS code. I assume your session encoding is some ASCII encoding like LATIN1 or similar. If so, try starting SAS with encoding=UTF8 just for testing if it resolves your issue. Be aware that switching to UTF8 encoding may have impact on your existing SAS datasets and existing SAS code so use it with extreme caution. Maybe others will have better ideas.. Eyal

miaeyg · ‎08-13-2021

Hi @Aexor Review this as a starter: https://communities.sas.com/t5/SAS-Communities-Library/Best-Practices-for-converting-SAS-code-to-leverage-SAS-Cloud/ta-p/665878 HTH, Eyal

miaeyg · ‎08-13-2021

Hi @MaT721 , I am not sure if what I am suggesting is the best way but I think it will work...you can use the SAS Viya REST API to create a compute server session and then submit SAS code which assigns a fileref that points to your image that you want to download and then download it using this API: https://developer.sas.com/apis/rest/v3.5/Compute/#download-a-file Another option which I am not sure will work is to somehow use the Files API but I am not sure if it can be used to access files on disk or just files in the SAS Content Server. HTH, Eyal

miaeyg · ‎08-13-2021

Hi @smm662002 Yes, I believe you need to sum the two. One if "fixed" size columns and the other is "variable" sized columns like varchar. HTH, Eyal

miaeyg · ‎08-11-2021

Hi, I think this is what you are looking for: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg/cas-table-tabledetails.htm?homeOnFail Eyal

Online Status	Offline
Date Last Visited	‎10-10-2021 01:53 PM

Re: SAS sum of next N rows for every row

תיקון לפורמט NLDATE כך שיציג תאריך נכון עם עברית

Re: WARNING: Some character data was lost during transcoding in column...

Re: Updates required in VIYA

Re: Download a file in a personal folder on Viya

Re: How to get the size of a table in CAS?

Re: How to get the size of a table in CAS?

Re: Updates required in VIYA

Re: SAS sum of next N rows for every row

Re: WARNING: Some character data was lost during transcoding in column...

Re: Download a file in a personal folder on Viya

Re: SAS sum of next N rows for every row

תיקון לפורמט NLDATE כך שיציג תאריך נכון עם עברית

Re: WARNING: Some character data was lost during transcoding in column...

Re: Updates required in VIYA

Re: Download a file in a personal folder on Viya

Re: How to get the size of a table in CAS?

Re: How to get the size of a table in CAS?

SAS Users Group in Israel