About Panagiotis

Mubarak_Basha · ‎08-20-2025

Hey Folks! I love the scanner program but i too written a similar piece of program to find any pattern from a log file or sas program. You can mention a wild card characters (*) in datalines to search in multiple files or sas codes. Hope this will helps! Learn Together ! Grow together ! Here's my program: data code; length fileloc myinfile $ 512 Log_file_name $100. ; input fileloc $ ; infile dummy filevar=fileloc filename=myinfile end=eof LRECL=512 truncover dsd ; do while(not eof); input ; linenum + 1; if index(_infile_, 'ERROR') then output; Log_file_name=myinfile; end; put 'Finished reading ' myinfile=; datalines; &logdir./&filename. /*Your log filename here including directory - Ex : /work/prod/outputfile*.log */ ; run;

MubarakBasha · ‎08-20-2025

Hi Folks!, Thanks for the case study like this. Expecting more cases to practice as a SAS developer . Happy to share ! keep learning ! Keep inspiring ! Here's my solution for the given case study : data Tsunami; format DATE_TIME datetime19. Regioncode id best12.; set data.earthquakes_dirty; id=scan(id_regioncode,1,'-'); Regioncode=scan(id_regioncode,2,'-'); FLAG_TSUNAMI=upcase(FLAG_TSUNAMI); EQ_PRIMARY=coalesce(EQ_MAG_MW,EQ_MAG_MS,EQ_MAG_MB,EQ_MAG_ML,EQ_MAG_MFA,EQ_MAG_UNK); DATE_TIME=dhms(mdy(month,day,year),hour,minute,seconds); drop id_regioncode month day year hour minute seconds EQ_MAG_MW EQ_MAG_MS EQ_MAG_MB EQ_MAG_ML EQ_MAG_MFA EQ_MAG_UNK; run; proc sort data=Tsunami out=Tsunami1 dupout=dup_rec nodupkey; by id; run; proc sort data=Tsunami ; by id; run; data valid_tsunami invalid_tsunami; set Tsunami; if Regioncode in (1, 10, 15, 20, 30, 40, 50, 60, 70, 80, 90,100, 110, 120, 130, 140, 150, 160, 170) and FLAG_TSUNAMI in (" ", "TSU") and not missing(DATE_TIME) and (0 <= EQ_PRIMARY <= 9.9) and (0 <= FOCAL_DEPTH <= 700) then output valid_tsunami; else output invalid_tsunami; run; data invalid_final1; set invalid_tsunami dup_rec; run; proc sql; select id into:dupid from dup_rec; quit; %put &=dupid; proc sql; create table invalid_final as select *, case when REGIONCODE not in (1, 10, 15, 20, 30, 40, 50, 60, 70, 80, 90,100, 110, 120, 130, 140, 150, 160, 170) then 'Region Code' when EQ_PRIMARY < 0 or EQ_PRIMARY > 9.9 then 'EQ Primary' when FOCAL_DEPTH < 0 or FOCAL_DEPTH > 700 then 'Focal Depth' when EQ_PRIMARY=. and FOCAL_DEPTH=. then 'EQ Primary, Focal Depth' when DATE_TIME=. then 'DATE Time' when id=&dupid then 'Duplicate ID' end as INVALID_DESCRIPTION FORMAT=$50. from invalid_final1; quit;

obiobi · ‎04-28-2025

Thank you for responding.

DCMarks25 · ‎12-27-2024

My book from feb 2019 does not have an edition on the cover

ballardw · ‎06-21-2024

Can you show an example of what you want for a 2-d version of your graph? I would think most understandable might be just a box with the number of school mean programs. Something like this example: https://support.sas.com/kb/24/900.html only use the number to display instead of the state abbreviation. Use CBOX with CBACK=white to have the numbers appear on a white background for readability and to draw attention. Probably still need to play with locations for some of the New England states like Connecticut and Rhode Island as may not be room If you want to overlay a 2-dimensional rectangle then you could create an annotate data set drawing rectangles that look like a 2-d bar at each state. Or maybe use a fill pattern to represent the bar information

SumanE · ‎04-07-2024

Thanks for every one

Cynthia_sas · ‎03-09-2024

Hi: If you mean that the Virtual Lab opens a "Citrix" window, then you are NOT using SAS OnDemand for Academics, instead, you are using the internal Citrix-based Virtual Lab that is accessible from INSIDE the course. The benefit of using this Virtual Lab is that the data is already made for you. However, you are correct, that in the Citrix-based Virtual Lab, you CANNOT upload files from your personal machine. This is by design. You do NOT need to upload any files because in the Citrix Virtual Lab, the date files and all the folders are already created for you. Look in your Virtual Lab session for the "S:" drive, and under S:\workshop\EPG1V2, you should find the Programming 1 folders and files. There are explicit instructions inside the Course Overview section, that explain the data is already created for you inside the Citrix-based Virtual Lab. If you want to switch to SAS OnDemand for Academics, you would need to start from https://welcome.oda.sas.com which is a separate, stand-alone link that you have to start in a separate browser section. In looking at your screen shots, it appears to me that you are using the Citrix-based internal Virtual Lab, which has restriction on uploads from your machine because the data is already made for you on this Virtual Lab. Cynthia

yabwon · ‎11-05-2023

Hi Peter! ( @Panagiotis ) Thanks for the link, very interesting article. I enjoyed reading and learned something new. Unfortunately it still does not answers my question. In my question I had a SAS dataset generated by FCMP as an input rather than "text of a function code" (like in your "source" statement). But I guess I can do a workaround myself by creating a new text variable which concatenates (as a text string) the "Value" variable from the FCMP's dataset and push the result then to the actionSet, right ? All the best Bart

Panagiotis · ‎10-03-2023

I think it's because you are not specifying the caslib in the dataDiscovery.profile action. In CAS, you have what's called an active caslib. The active caslib is like your current working directory. If you do not specify a caslib, CAS will use the active caslib. By default, the Casuser caslib is typically the active caslib. You can check with this code: proc cas; sessionProp.getSessOpt / name = 'caslib'; quit; /* results */ {caslib=CASUSER(user-name)} In your working code you changed the active caslib in the CAS statement to the AAAA caslib. Now if you specify a CAS table without specifying where the CAS table is, it'll use AAAA by default. cas mysess sessopts=(caslib=&caslib.); Then you load the sashelp.cars SAS data set into memory in the AAAA caslib. Now this data set was loaded to the AAAA caslib (whatever data source that connects to. Could be a database, path, cloud, etc.). In the CASUTIL code you specified the outcaslib parameter, indicating which caslib you want to load this table to. If you didn't specify the outcaslib parameter, it would use the active caslib. proc casutil; load data=&libname..&table. outcaslib="&caslib." casout="&table." REPLACE; run; In your dataDiscover.profile action you don't specify where the CAS table you want is. So SAS will use the active caslib by default. In your working code the active caslib is AAAA since you set it in your CAS statement. In the code that's erroring out my guess is the active caslib is Casuser, and the CARS table doesn't exist in Casuser. dataDiscovery.profile result=r / table={name="&table."}, /* <--where should I look for this table??? SAS will look in the active caslib */ casOut={name="Profilazione", replace=true}; /* <--where should I create this table??? SAS will use the active caslib */ run; I recommend always specifying the caslib and not relying on the active caslib, even though it's not always required. It's very easy to change the active caslib accidently, and this could cause issues like this. Being explicit avoids these issues and honestly makes your code easier to read. Here is how I would type out the action. proc cas; loadactionset / actionSet="dataDiscovery"; run; dataDiscovery.profile result=r / table={ name="&table.", caslib="&caslib" /*Specify input caslib. If this is omitted, the active caslib is used */ }, casOut={ name="Profilazione", caslib="&caslib", /*Specify output caslib. If this is omitted, the active caslib is used */ replace=true }; quit; I also have a series of blogs on CAS actions. Feel free to check out them out: https://blogs.sas.com/content/sgf/2021/08/06/cas-action-a-series-on-fundamentals/

Zengahoe · ‎09-24-2023

Thanks. Will try it out.

Panagiotis · ‎08-24-2023

You're welcome! I just learned about this function. Great question! - Peter

Panagiotis · ‎06-12-2023

Watch this Ask the Expert session to learn the fundamentals of the SAS Viya platform and CAS, then dive into CASL, the scripting language designed to support the entire analytics life cycle on the SAS Viya platform. Watch the Webinar You will learn how to: Describe the two computing engines in the SAS Viya platform. Explain CASL and its components. Understand when to use CASL. Use CAS actions to submit requests to the CAS server and work with the results. Develop analytic pipelines using CASL. The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached. Q&A In SAS Viya, do I need to use the CAS language (CASL)? No, you don’t. CASL is the native language of the CAS server, but you can also use SAS, Python, R, Java and more through the CAS API to process data on the distributed CAS server to accomplish everything we have done today using CASL. SAS Developer Page https://developer.sas.com/guides/open-source-sas.html Python Integration to SAS Viya https://blogs.sas.com/content/sgf/2020/06/19/getting-started-with-python-integration-to-sas-viya-index/ SAS Viya Programming Documentation https://go.documentation.sas.com/doc/en/pgmsascdc/v_039/pgmsasgswlcm/home.htm In SAS Viya, you can use a variety of languages to work with your data. So, when should I use CASL, SAS, or Python/R? This depends on the task you want to complete and your comfort level with the programming language. For example, if you are Python programmer and want to continue to use Python, use the Python SWAT package to execute code on the CAS server, and bring back smaller, summarized results to your local Python client for additional processing using other Python packages. Or if you are a SAS programmer you can use SAS Studio to execute SAS code on the distributed CAS server, and bring back smaller, summarized results back to the SAS client to continue processing using traditional SAS code. Or you can use the fedSQL language to execute SQL on the distributed CAS server. In the end I recommend using the language you are most comfortable with. Every language has its own benefits and considerations. Can you explain the difference between the SAS compute server and the CAS server? Viya contains 2 analytic processing engines. The SAS Compute server is just like SAS 9 (sometimes called SPRE, the workspace server, or SAS9). The Compute server enables you to run your traditional SAS code as you saw earlier – Data Step, PROC Means, ODS, Excel, all of that. The CAS server is a massively parallel processing environment that can connect to the same data sources the Compute server can connect to, but if you pull that data into the CAS server, it loads the data into a distributed computing environment for massively parallel processing. The CAS server also enables you to use other Viya point and click applications for analysis, data prep or machine learning. CAS also has a variety of integration with other languages like R/Python/Java and REST APIs. With the CAS server storing the data for a long as we want, does that make it require more memory/space? And secondly, does this make processing slower than in SAS computing server? The CAS server is most likely going to be a pretty big environment. It also performs memory swapping if you're at that place where you have too much data in memory. It shouldn't make it slower because you're avoiding that input and output going from disk to memory. It will do some CAS caching or swapping. Here is some information on how the CAS server manages memory: https://go.documentation.sas.com/doc/en/pgmsascdc/v_039/casfun/n16qbskv0hwfq1n1lnrqq605p6sv.htm The CAS server and the Compute server are separate, so how much data that is loaded in CAS does not affect how the Compute server processes data. How can you use the work you did in the CAS language in SAS Visual Analytics report building? You can do all your data prep in the distributed CAS server using CASL (or Python/R/SAS/etc.). Once the data is ready, you can promote the CAS table to global scope so you (or another coworker) can use Visual Analytics (or other Viya applications) on that in-memory table. Promoting the table avoids saving it back to disk and reloading it into memory. For more information on session vs global scope tables: https://go.documentation.sas.com/doc/en/pgmsascdc/default/casfun/n09ssmi0ko8uyfn1022ezo2hv0pm.htm#p0mbflp8ta6iq3n1aswoae5s5g76 You can also save the CAS table into a file format like sashdat, parquet, csv, sas7bdat or back to a database. Once the data is saved back to disk, you can use Visual Analytics to load the data into memory and begin creating a dashboard. For more information on saving CAS tables to disk: https://go.documentation.sas.com/doc/en/pgmsascdc/default/casref/n1fujq5fhyeiprn1whq1iva21obo.htm?fromDefault= Personally, I do all of my data preparation using code like Python/SAS/CASL. Once the data is ready, I save it back to disk in the file format I need and then load it into memory using Visual Analytics for exploration and reporting. How to use SAS Macro in PROC CAS? That's a deeper conversation. You can use the macro language with CASL. I could say %LET. Give it a string and I could use and the macro variable in CASL, but there are some “gotchas”. We don't have time to go into that now. But you can use it in Proc CAS because, again, the macro language is just going to get some text and replace the text in your code. Typically when I use CASL I don’t use the SAS macro language. I use the available variable data types in CASL. I do not have clients; it is myself only. But I am running large data set, need sorting, then run time-series model. How will CAS help me? With CAS, the data resides in-memory, so you only need to load it once to process it multiple times. With CAS (like with DBMS tables), there is no need to pre-sort the data for BY group processing. The data will be retrieved using an appropriate ORDER BY clause. You can use the Time Series Analysis CAS Action set to do your analysis in parallel in CAS and return just the results to the compute server. https://go.documentation.sas.com/doc/en/pgmsascdc/default/casactforecast/casactforecast_timedata_examples06.htm How do you prevent users from filling up available server memory by loading many large datasets? Is there some sort of clean-up process that runs if a dataset is not accessed for a certain amount of time? CAS is excellent at managing memory transparently. By default, the CAS tables you create are "session scoped" - when you disconnect the CAS session, the tables are removed from memory. Is there a presentation using network analyses? Check out https://video.sas.com/detail/video/6029136083001/intro-to-network-analysis-in-sas%C2%AE-visual-analytics Can you please post python code for calling CASL? Thanks. Check out Peter's Getting Started with Python Integration to SAS® Viya blog series: https://blogs.sas.com/content/?s=Getting+Started+with+Python+Integration+to+SAS%C2%AE+Viya%C2%AE How do you load your own data? If you are authorized, you can simply create a caslib connection to any folder location accessible to the CAS server or load local data into CAS. Can you edit Python in SAS Studio? Or does it require a separate "Python Integration" product? The October 2021 release of SAS Viya introduced the Python Code Editor within SAS Studio. Does using SAS language make it less efficient? Using the SAS language with the CAS engine to process SAS code in CAS does have some overhead because SAS procs and statements are converted into the native CAS language behind the scenes. Check out some other Ask the Expert presentations: Best Practices in Migrating SAS Code to Leverage CAS https://www.sas.com/en_us/webinars/ate-best-practices-in-migrating-sas-code.html Getting to Know SAS Viya https://www.sas.com/en_us/webinars/getting-to-know-sas-viya.html

Panagiotis · ‎04-24-2023

Hi SAS Viya Community, I’m presenting a live “Ask the Expert” webinar on April 27 th , 11 AM – Noon ET entitled Get Started: Using CAS Programming Language (CASL) for Distributed Computing in the SAS® Viya® Platform. I’ll cover the fundamentals of the SAS Viya platform and the distributed CAS server, then dive into CASL, the scripting language designed to support the entire analytics life cycle. Bring your questions. I’ll host a live Q&A session at the end of the webinar. You will learn how to: Describe the two computing engines on the SAS Viya platform. Explain the CAS language (CASL) and its components. Understand when to use CASL. Use CAS actions to submit requests to the distributed CAS server and work with the results. Develop analytic pipelines using CASL. Reserve your spot for the webinar. Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from this and other SAS Ask the Expert webinars. Can't join the live event? You can view this and other Ask the Expert sessions on-demand here.

Panagiotis · ‎04-24-2023

Hi SAS Programming Community, I’m presenting a live “Ask the Expert” webinar on April 27 th , 11 AM – Noon ET entitled Get Started: Using CAS Programming Language (CASL) for Distributed Computing in the SAS® Viya® Platform. I’ll cover the fundamentals of the SAS Viya platform and the distributed CAS server, then dive into CASL, the scripting language designed to support the entire analytics life cycle. Bring your questions. I’ll host a live Q&A session at the end of the webinar. You will learn how to: Describe the two computing engines on the SAS Viya platform. Explain the CAS language (CASL) and its components. Understand when to use CASL. Use CAS actions to submit requests to the distributed CAS server and work with the results. Develop analytic pipelines using CASL. Reserve your spot for the webinar. Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from this and other SAS Ask the Expert webinars. Can't join the live event? You can view this and other Ask the Expert sessions on-demand here.

MLopez · ‎04-04-2023

Hello, I fairly new to the SAS Environment and when i attempt to set up my case study i receive the following errors: ERROR: Error connecting to 72.247.205.215:443. (The connection has timed out.) ERROR: Unable to establish connection to support.sas.com. ERROR: Unable to connect to Web server. NOTE: PROCEDURE HTTP used (Total process time): real time 2:07.38 user cpu time 0.10 seconds system cpu time 0.12 seconds memory 333.34k OS Memory 44704.00k Timestamp 04/04/2023 12:21:00 PM Step Count 63 Switch Count 195 Page Faults 11 Page Reclaims 147 Page Swaps 0 Voluntary Context Switches 6970 Involuntary Context Switches 2 Block Input Operations 1032 Block Output Operations 8 NOTE: The SAS System stopped processing this step because of errors. 67 68 /* Save TSAClaims2022_2017.csv in the WORK library path */ 69 data _null_; 70 infile data; 71 input; 72 file "&path/TSAClaims2002_2017.csv"; 73 put _infile_ ; 74 run; ERROR: Physical file does not exist, /sas/grid/SAS_work718D0001686A_svcksa69901a7z/#LN00079. NOTE: The file "/sas/grid/SAS_work718D0001686A_svcksa69901a7z/SAS_workA1DA0001686A_svcksa69901a7z/TSAClaims2002_2017.csv" is: Filename=/sas/grid/SAS_work718D0001686A_svcksa69901a7z/SAS_workA1DA0001686A_svcksa69901a7z/TSAClaims2002_2017.csv, Owner Name=malop14,Group Name=ux_R2002430, Access Permission=-rw-rw----, Last Modified=04Apr2023:10:21:00 NOTE: 0 records were written to the file "/sas/grid/SAS_work718D0001686A_svcksa69901a7z/SAS_workA1DA0001686A_svcksa69901a7z/TSAClaims2002_2017.csv". 3 However, i am able to copy the hyperlink and it downloads directly, does anyone know what i can do to set this up versus having to download from csv from the site directly?

Online Status	Offline
Date Last Visited	‎05-02-2024 11:20 AM