About mitiksh

mitiksh · ‎09-15-2023

hello, I learned: what is cas how it works. datatypes. how to load data to cas and also import csv ,xlsx file. create caslibs and use those caslib in cas session. how to save in-memory files in caslib to load them after session reset. how to alter tables like rename, apply format. create new variable using casl. table action set. simple action set just the basics like number of obs, freq, mdsummary,etc. Now my question is 1. what to learn next i am stuck as there is so much to go through. if you can just show me some topic that i must learn that would be helpfull. thanks in advance.

mitiksh · ‎09-07-2023

Thanks for your valuable information.

mitiksh · ‎09-06-2023

Subject: Seeking Guidance to Become Proficient in SAS Viya Programming Dear SAS Community, I'm reaching out for assistance and guidance as I embark on the journey to become proficient in SAS Viya programming. Although I hold a certification as a SAS Base Specialist, I have recently been tasked with learning SAS Viya and SAS Visual Forecasting. I've been diligently studying for the past two weeks, but I've hit a roadblock when it comes to CASL programming. Unfortunately, I have been unable to locate any comprehensive books on the subject. What I'm Seeking: I'm kindly requesting your assistance in charting a clear path forward. Specifically, I would greatly appreciate a sequential list of topics to study, ensuring I don't get lost in the details. If possible, please share valuable resources, as I have only been able to find scattered guides thus far. Furthermore, I welcome any suggestions and tips on how to become a proficient SAS Viya programmer. Your insights and guidance would be immensely valuable to me. Thank you in advance for your support and expertise. Best regards.

mitiksh · ‎08-22-2023

Do it like this it will work data test_fmt; length label $15; fmtname='range'; input start $ end $ label :$; datalines; LOW 20 "good" 21 high "excellent" other . "missing" ; run;

mitiksh · ‎03-21-2023

I checked with other cycle in the SAS FM those are also affected. and i am not able to save a single form in any cycle( checked forms from 3 different cycle). Can you tell me where can i find more logs about SAS FM or SAS ADD INS or anything that can help me find some clue. Thanks for you help, I really appreciate it.

mitiksh · ‎03-20-2023

for example, i have already created formsets in SAS FM. so when i open the template of those formset. It opens in excel then I am able to see the data in it. after which i made some chances in the template, then I save the template form the SAS financial management in the ribbon area. but when i click save nothing happens if i try again to save it says that there is some issue and the form cannot be saved.

mitiksh · ‎03-20-2023

hii fellow SAS users, I am using SAS FM 5.6 for a project. i am facing issues with SAS FM generated excels. what is happening is that whenever i open a template from FM studio i am able to see the data but when i try to save the template ( even if no chance are done to the template) I am not able to do so. and if save it again it says that their is some issue and it is unable to save the template. no error are being generated in SASfinancial management5.6 log file. what can i do to find the problem?

mitiksh · ‎08-18-2021

Thank you @ChrisNZ. and every other contributor for help.

mitiksh · ‎08-18-2021

Regarding Question 1: Consider this Example, 31MAR16:00:05:00, this is supposed to contain minutes 1, 2, 3, 4 and 5 on 31MAR16. Similarly 31MAR16:00:10:00, This is supposed to contain minutes 6, 7, 8, 9 and 10. Question 2: Considering the new Date time index, New entry would look like this 31MAR16:00:00:00 high = Max_high (31MAR15:00:56:00, 31MAR15:00:57:00, 31MAR15:00:58:00, 31MAR15:00:59:00, 31MAR16:00:00:00) Low = Min_low (31MAR15:00:56:00, 31MAR15:00:57:00, 31MAR15:00:58:00, 31MAR15:00:59:00, 31MAR16:00:00:00) Open = (Open Value at 31MAR15:00:56:00) Close = (Close Value at 31MAR16:00:00:00) Volume = sum_volume ( 31MAR15:00:56:00, 31MAR15:00:57:00, 31MAR15:00:58:00, 31MAR15:00:59:00, 31MAR16:00:00:00) exchange and market are same for all.

mitiksh · ‎08-17-2021

data WORK.BTC; input time_start:DATETIME. exchange:$4. market:$7. open:BEST12. high:BEST12. low:BEST12. close:BEST12. volume:BEST12.; format time_start DATETIME. open BEST12. high BEST12. low BEST12. close BEST12. volume BEST12.; datalines; 31MAR16:00:00:00 BITF BTC/USD 413.04 413.27 413.04 413.27 8.9537465 31MAR16:00:01:00 BITF BTC/USD 413.27 413.27 413.27 413.27 0 31MAR16:00:02:00 BITF BTC/USD 413.27 413.27 413.27 413.27 0 31MAR16:00:03:00 BITF BTC/USD 413.27 413.27 413.27 413.27 4.726186 31MAR16:00:04:00 BITF BTC/USD 413.27 413.27 413.27 413.27 0 31MAR16:00:05:00 BITF BTC/USD 413.26 413.26 413.26 413.26 0.03515718 31MAR16:00:06:00 BITF BTC/USD 413.26 413.26 413.26 413.26 0 31MAR16:00:07:00 BITF BTC/USD 413.25 413.25 413.25 413.25 0.24729037 31MAR16:00:08:00 BITF BTC/USD 413.27 413.27 413.27 413.27 1.5 31MAR16:00:09:00 BITF BTC/USD 413.27 413.28 413.27 413.28 9.27629496 31MAR16:00:10:00 BITF BTC/USD 413.28 413.51 413.28 413.51 43.64005163 31MAR16:00:11:00 BITF BTC/USD 414.25 414.93 414.25 414.93 145.1566291 31MAR16:00:12:00 BITF BTC/USD 414.88 414.9 414.88 414.9 0.1309879 31MAR16:00:13:00 BITF BTC/USD 414.98 414.99 414.98 414.98 0.65589598 31MAR16:00:14:00 BITF BTC/USD 414.98 414.98 414.98 414.98 0.01226425 31MAR16:00:15:00 BITF BTC/USD 414.98 414.98 414.98 414.98 0.03889585 31MAR16:00:16:00 BITF BTC/USD 414.98 414.98 414.98 414.98 1.062 31MAR16:00:17:00 BITF BTC/USD 414.98 414.98 414.98 414.98 0.48398974 31MAR16:00:18:00 BITF BTC/USD 414.99 414.99 414.99 414.99 26.18839859 31MAR16:00:19:00 BITF BTC/USD 414.98 414.98 414.98 414.98 0.1 ; This will generate sample dataset. time_start exchange market open high low close volume 31MAR16:00:00:00 BITF BTC/USD 413.04 413.27 413.04 413.27 8.9537465 31MAR16:00:05:00 BITF BTC/USD 413.26 413.27 413.26 413.26 0.03515718 31MAR16:00:010:00 BITF BTC/USD 413.28 413.51 413.25 413.51 43.64005163 This should be the desired output. we can think about of window of 5 min and then just consider the first and the last entry in the window. we can directly copy the open and close but for high and low we need to find the max of high column and low as min of low column from those 5 entries we considered. Hope this explanation is understandable. I am a beginner so please pardon.

mitiksh · ‎08-17-2021

I have this BTC data This is collected with a time interval of 1 min. I want to change this interval to 5 min. 31MAR16:00:00:00 BITF BTC/USD 413.04 413.27 413.04 413.27 8.9537465 31MAR16:00:01:00 BITF BTC/USD 413.27 413.27 413.27 413.27 0 31MAR16:00:02:00 BITF BTC/USD 413.27 413.27 413.27 413.27 0 31MAR16:00:03:00 BITF BTC/USD 413.27 413.27 413.27 413.27 4.726186 Please help Thank you

mitiksh · ‎06-15-2021

How to safely get rid of this setup?

Online Status	Offline
Date Last Visited	‎09-16-2023 07:21 AM

Re: Help ME To Learn SAS VIYA Programming

Re: Help ME To Learn SAS VIYA Programming

Help ME To Learn SAS VIYA Programming

Re: proc format CNTLIN dataset values

Re: unable to save SAS FM template

Re: unable to save SAS FM template

unable to save SAS FM template

Re: Convert time interval from min to 5 min

Re: Convert time interval from min to 5 min

Re: Convert time interval from min to 5 min

Re: Help ME To Learn SAS VIYA Programming

Re: Convert time interval from min to 5 min

Re: Help ME To Learn SAS VIYA Programming

Re: Help ME To Learn SAS VIYA Programming

Help ME To Learn SAS VIYA Programming

Re: proc format CNTLIN dataset values

Re: unable to save SAS FM template

Re: unable to save SAS FM template

unable to save SAS FM template

Re: Convert time interval from min to 5 min

Re: Convert time interval from min to 5 min

Re: Convert time interval from min to 5 min

Convert time interval from min to 5 min

Re: SAS DI Developers: Unite! The new GIT plug-in in Data Integration ...