SAS Support Communities

rgreen33 · ‎05-27-2022

@SASJedi, Thank you for the reply. This is great! Now, the next issue is that I want to loop thru all of my CASLIBs...getting a list of all of the files and tables in my CASLIBs. It appears that the method above will not allow for appending to the work.files and work.tables. Any suggestions for this? Thanks, Ricky

rgreen33 · ‎05-20-2022

I am working on a script that will scan my caslibs and will report to me the datasets that are not loaded. The code works (email portion lacking). However, I can only "print" my results. I need to get them into work.temp so that I can query them for email. Below is my code. I have tried everything that I can think of, but I cannot find a way to do an insert inside of my proc cas block. options emailsys=smtp symbolgen mprint mlogic timezone='america/new_york' options msglevel=i; /* start cas session */ cas mySession sessopts=(messagelevel=all); /* assign all caslibs, so that any can be used */ caslib _all_ assign; proc datasets library=work kill; run; quit; proc sql; create table work.temp (myCaslib char(255), myFilename char(255), myMessage char(255)); quit; proc cas; %let myCaslib = "PUBLIC"; /* Lists the files in a caslib's data source. */ table.fileinfo result=fileresult caslib=&myCaslib; /* Display the results of the above action; */ /* Describe(fileresult); */ filelist=findtable(fileresult); do j over filelist; table.tableexists result=r / name=j.name caslib=&myCaslib; if r=0 then print &myCaslib " " (j.name) " : Dataset not loaded."; /******************************************************** * Need help here. Instead of the above print, I would like to * write the 3 print items to work.temp. How can I do this within * this proc cas block? *********************************************************/ end; quit; /* Email message with dynamic content based on data */ filename msg email to="myEmail@mydomain.com" from="sas-alerts@mydomain.com" subject = "SAS Viya Dataset NOT Loaded"; data _null_; file msg; put "This is a test of email from Viya."; run;

rgreen33 · ‎11-05-2021

@elisehoo1 , I am still testing things. I will post the solution once I have things working. Thanks, Ricky

rgreen33 · ‎11-05-2021

Perfect! I did not realize that the refresh would work like this. Thank you so much for the link. I was making this harder than it needed to be. I'm now rethinking the script that I already have written. From the above link, if I setup a "refresh" job, any ideas on how it would work if a new sashdat file is encountered (one where the table is not yet in memory)? Since the "target" does not exist, will it skip it, or will it go ahead and load it? I'm also now wondering if the sashdat file will be able to be replaced for those files that have already been loaded into memory??? I'm wondering if I should allow users to upload files to a different directory...and then import them into my CASLIB (folder). I'm trying to understand what the "import" job would do if I set it to newer...to import ONLY the files that have been updated. Ideas on how to piece this together to make it work? Thanks, Ricky

rgreen33 · ‎11-04-2021

I have a folder setup on my SAS Viya server, where sashdat files are being dropped. I am working on a SAS Viya Studio script that will do 2 things... If a new file is found, which has never been loaded into memory, the script will load the file into memory and promote it so that it is available to SAS Viya Visual Analytics. I have this part working, using "proc cas". If a sashdat is updated (replaced by a new version), I want to drop and reload the in-memory data. This is the part that I am struggling with. I was thinking that I could compare the date/time on the file with the loaded (in-memory) date/time, but I have not yet found a way to do this. Any suggestions for part 2 above? Thanks, Ricky

rgreen33 · ‎09-27-2021

I using Viya Visual Analytics 8.5.2. I am working with a Schedule Chart. I have the following: Task: processName Start: startTime Finish: endTime Group: status Data tip values: processName, startTime, endTime, duration Hidden: startDate (I added this so that I can have a slider to look at data one day at a time) By default, my Schedule Chart is being sorted by processName. I would like to be able to sort by startTime. However, when I attempt to change the sort, I only have the following options: processName: Ascending; processName: Descending. Does anyone know how I can accomplish this? Thanks, Ricky

rgreen33 · ‎04-28-2021

@SASKiwi , we are running SAS Viya release V.03.05.

rgreen33 · ‎04-23-2021

@MarkBodt_NZ , Thank you for your reply. All of my data loads straight from SQL Server or Oracle...no transformations needed. Thus, I have everything setup as basic load jobs in the Viya scheduler (just copied and modified the sample load jobs provided by SAS). When each of the jobs run, a log file is generated and is available via the Viya Environment Manager Schedule Monitoring interface. From there, I can down the log files individually and look at them. Unfortunately, the log file can contain and error from Oracle or SQL Server...but the status of the job in the Monitor is "Successful". Thus, I need to capture the errors in these log files. However, I do not know how to programmatically access these log files. I understand the Studio jobs, as that is how I was loading my data in SAS 9.4...before moving to Viya. Is there a way in SAS studio to reference (and scan) the log files that appear in the Viya Environment Manager Schedule Monitoring interface? Thanks, Ricky

rgreen33 · ‎04-19-2021

In SAS 9.4, I had all of my load jobs setup with code at the end to check the status...and email my admins when a load job failed. Now that we have moved to SAS Viya, I am not seeing a good way to do this with jobs that are running via the scheduler in Environment Manager. I have jobs that are loading data from Oracle and SQL Sever into CAS. The status of the job is showing success. However, if I did into the log files, I am seeing that occasionally, I have jobs that fail. How can I capture these failures and send alerts that the failures occurred. Has anyone come up with a solution for this? I'm thinking that I may have to parse the individual log files...but how? Thanks, Ricky

rgreen33 · ‎10-31-2020

I have several "load" jobs setup in Viya, via the "Jobs/Scheduling" section of Environment Manager. With the schedules being buried within each job, how can I get a list of all of my schedules, so that I can see a wholistic view of when my schedules are set to run? Thanks, Ricky

rgreen33 · ‎10-23-2020

@XavierBizoux Super! Thank you for the updated info! I will take a look. Thanks again!

rgreen33 · ‎10-22-2020

@XavierBizoux , I know that this post is a few months old, but this is the best news that I have seen today! Unfortunately, I am new to Viya (we are currently in the process of moving from SAS 9.4M5 to Viya - currently in the process of migrating/fixing our reports and configuring the Viya environment). In Viya, we have a dev environment and a prod environment, so your post will welcomed news, as I have been struggling with the promotion process. Being new to the Viya environment, I do have some questions that I hope that you can expand upon. First, the links in the post appear to no longer be valid. Can you provide current URLs for these scripts? I can find the scripts at the following URL (https://github.com/xavierBizoux/viyaRestPy/), but I am not sure if the ones that should be used. I am not familiar with Python scripts. Any tips on running these scripts? Do these run locally on my machine...pulling and pushing data to Viya? Any help that could be provided is greatly appreciated. Any resources that you can might be able to point me to is also greatly appreciated. Some of my reports have images embedded. Do these scripts allow for those images to be remapped to different locations on the destination server? You mentioned in your post the following: "This option is better if the report exists and you don't want to break the links to this report." Does this mean that if we have weblink that are pointing directly to reports (using the "Copy link" option in Viya, which embeds the URI into the URL) will remain the same and continue to work after promoting and existing report from dev to prod? Obviously, this is a concern with what I am currently seeing in Viya. I appreciate any help that you can provide on this. During our migration, I was greatly surprised that a better solution was not included in Viya. I was hoping that I had missed something on my research. However, it seems that others have the same questions that I have. I look very forward to hearing from you. Thank you, Ricky

rgreen33 · ‎10-21-2020

I found that I could place my files in the /data/home/my_user folder. I was then able to access my files via this path in my script.

rgreen33 · ‎10-19-2020

I'm new to Viya (we are in the process of migrating from SAS 9.4 to Viya) and I am running into several issues when attempting to promote reports from one environment to another (dev to prod). I would like to hear how others are getting around these issues: Unable to import into a particular folder. My folder structure is different from one environment to another. When I attempt to promote a report from dev to prod, the dev folder structure is brought over to my prod environment...and then I have to move the report and clean up the mess that is left. Has anyone found a way around this? Unable to overwrite existing files. As mentioned previously, when I promote items from dev to prod, I am forced to promote and then move the items. Unfortunately, it appears that Viya is unable to overwrite an existing file, which means that I must delete the file and then move the promoted file into its final location. Has anyone found a way around this? Images that included in reports seem to break, as I have no way to remap their location. Has anyone found a way around this? @Sas - please help us out here and make this promotion process easier!!! Thanks, Ricky

rgreen33 · ‎10-19-2020

@BrunoMueller, I am still not able to get this to work. It is probably worth noting that I am trying to use this with %shpimprt, as my shapefilepath. Any ideas? Can my shape file be in SAS Content, or must it be on the file system?

Online Status	Offline
Date Last Visited	‎08-09-2022 04:12 PM

SAS Support Communities

Re: Need to insert rows into work.temp inside of proc cas block

Need to insert rows into work.temp inside of proc cas block

Re: Reloading in-memory table when sashdat file has been replaced

Re: Reloading in-memory table when sashdat file has been replaced

Reloading in-memory table when sashdat file has been replaced

Sort Schedule Chart by Start Time (X Axis)

Re: How can I get the status of a failed job and send alert via schedu...

Re: How can I get the status of a failed job and send alert via schedu...

How can I get the status of a failed job and send alert via scheduled ...

How can I get a list of schedules (on jobs)?

Re: Reloading in-memory table when sashdat file has been replaced

SAS VA 7.4 Heat Map Color Issue

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

Re: DI Studio Job: Status Handling/Send Email - how can I include HOST...

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: Need to insert rows into work.temp inside of proc cas block

Reloading in-memory table when sashdat file has been replaced

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

CLI error connecting to SQL Server

Re: We just enabled ACM ETL Processing today - when will reports show ...

Re: Need to insert rows into work.temp inside of proc cas block

Need to insert rows into work.temp inside of proc cas block

Re: Reloading in-memory table when sashdat file has been replaced

Re: Reloading in-memory table when sashdat file has been replaced

Reloading in-memory table when sashdat file has been replaced

Sort Schedule Chart by Start Time (X Axis)

Re: How can I get the status of a failed job and send alert via schedu...

Re: How can I get the status of a failed job and send alert via schedu...

How can I get the status of a failed job and send alert via scheduled ...

How can I get a list of schedules (on jobs)?

Re: Promotion Viya to Viya : Change folder location of report.

Re: Promotion Viya to Viya : Change folder location of report.

Re: From SAS Studio (Viya), how do I reference a file that is stored i...

Issues related to report promotion from Viya DEV to Viya PROD

Re: From SAS Studio (Viya), how do I reference a file that is stored i...

SAS Global Forum 2017

Follow Us

What is...