About johnfrytz

johnfrytz · ‎11-01-2021

I'm passing the selected values of the drop-down into the parameter. When the selection is cleared , the parameter displays "<No item selected>". I'm using the parameter in a calculation. It seems that the calculation is retaining the result for the first condition of the IF-ELSE statement. Hence I wanted to know the equivalent value for "<No item selected>" to ensure I get the correct results.

johnfrytz · ‎10-19-2021

Has anyone able to create a workaround for this for version 8.3?

johnfrytz · ‎10-06-2021

@TeriPatsilaras Thanks. I'll try it out

johnfrytz · ‎10-04-2021

There is a refresh option, I encountered it before. It basically recalculate the object. Try the "automatically refresh object". If not, look for the refresh option on the object which the parameter it sourced. Apologies, I forgot which test VA report I was able to the same thing.

johnfrytz · ‎10-04-2021

I was trying to get away from having another set of data which either a monthly aggregate or transactional type (monthly as of status record).

johnfrytz · ‎10-03-2021

Has anyone able to plot the data based on effectivity dates (period)? Data sample: Name Category Effective_from Effective_to ID1 Group1 Jan 2021 Jun 2021 ID2 Group1 Jan 2021 May 2021 ID3 Group2 Jan 2021 Jul 2021 ID4 Group2 Jan 2021 Jun 2021 ID5 Group1 Jan 2021 Apr 2021 ID6 Group3 Jan 2021 Jun 2021 Can this be graphed in a line chart where all data will be counted each month and will no longer be counted once the effectivity period ends? Thanks

johnfrytz · ‎09-30-2021

Is there a way to retain percentages on the columns and actuals in the totals only?

johnfrytz · ‎03-29-2021

Hi, I'm trying to test the usage of tags on SAS Drive 2.2. I can't seem to search item which contain 2 or more tags. Sample: Report 1 ( tag: tagsam1 rep1) Report 2 ( tag: tagsam1 ) Report 3 ( tag: rep1) Report 4 ( tag: tagsam1 rep1 rep2) I want the search result to show Report 1 and Report 4 by searching #tagsam1 #rep1. The result always shows all reports. Any idea? Thank you in advance. Have a great day.

johnfrytz · ‎08-03-2020

Hi, I'm trying to import spk package from my /home/usrid folder or /data/package directory(linux) in SAS Environment Manager in Viya. Is there another way of importing the package other than browse via your local machine (client)? Currently the data file is in the server on the folders I've mentioned. I'm trying to do a work around not having to download the file then importing it. Thanks

johnfrytz · ‎06-10-2020

Thanks Anand. It seems my luck might have run out.

johnfrytz · ‎06-09-2020

Yup, something like that. Like a file or info where the start and end time of the previous background submitted jobs.

johnfrytz · ‎06-08-2020

Hi everyone. Does anyone know where to locate the info shown here? My problem was before this there were other jobs listed. Sadly the logs for the completed jobs does no have time stamps. Is there a way to locate such info in any system folder or logs in Unix/Linux. It was a pain to run the jobs again because it takes around 10-12hrs to complete.

johnfrytz · ‎04-28-2020

For what I know, you can submit a background job by right-clicking the program in the navigation pane and select Background submit. My question us, does anyone know or have tried doing it programmatically. For example, if the value of parameter set is between : 1 - 300 then execute 1 background job. 301 - 600 then execute 2 background job. 601 - 900 then execute 3 background job. .... and so on depending on the maximum allowed background job of the user. Cheers.

johnfrytz · ‎11-28-2019

Cheers @Pmyosh . Thanks for the response. You are correct, I've just tried declaring the caslib again. Encountered no error in that portion. cas mySession sessopts=(caslib="myCaslib"); caslib casuser list; caslib myCaslib list; Log: 95 cas mySession sessopts=(caslib="myCaslib"); NOTE: 'MYCASLIB' is now the active caslib. NOTE: The CAS statement request to update one or more session options for session MYSESSION completed. 96 caslib casuser list; NOTE: Session = MYSESSION Name = CASUSER(test) Type = PATH Description = Personal File System Caslib Path = /opt/sas/viya/config/data/cas/default/casuserlibraries/test/ Definition = Subdirs = Yes Local = No Active = No Personal = Yes NOTE: Action to LIST caslib CASUSER completed for session MYSESSION. 97 caslib myCaslib list; NOTE: Session = MYSESSION Name = MYCASLIB Type = PATH Description = Path = /Users/test/workshop/ Definition = Subdirs = Yes Local = Yes Active = Yes Personal = No NOTE: Action to LIST caslib MYCASLIB completed for session MYSESSION. I guess , I need further understanding on proper usage of CASUTIL especially working with different caslib.

johnfrytz · ‎11-27-2019

Thanks for the suggestion. I've explored the use case of rankings used it and in some cases relied on parameter to get a value range by generating a flag value. Used the value (0,1) to filter my data. Cheers

Online Status	Offline
Date Last Visited	‎10-20-2022 07:34 AM

What is the Value equivalent of No selection for a drop down list?

Re: Link from a key value to another report

Re: SAS Visual Analytics Report Example: Percent of Total – For All, F...

Re: How to show date from a data source in SAS VA 8.3 report?

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

SAS VA 8.3 can it plot data based on effectivity date (period)?

Re: SAS Visual Analytics Report Example: Percent of Total – For All, F...

SAS Viya : using multiple Tags on SAS DRIVE 2.2 , can you specifically...

SAS Viya : Using Environment Manager, locate folder

Re: SAS Studio background submit logs

Preventing a mouse from zooming in and out when viewing a chart - SAS ...

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

Re: SAS Viya : using multiple Tags on SAS DRIVE 2.2 , can you specific...

Re: SAS Viya : Using Environment Manager, locate folder

Re: SAS Studio background submit logs

SAS VA : Consider Geomap Location Pin to be loaded as a data set

Re: Working with Interactive filters in dynamic text. How to make cond...

What is the Value equivalent of No selection for a drop down list?

Re: Link from a key value to another report

Re: SAS Visual Analytics Report Example: Percent of Total – For All, F...

Re: How to show date from a data source in SAS VA 8.3 report?

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

SAS VA 8.3 can it plot data based on effectivity date (period)?

Re: SAS Visual Analytics Report Example: Percent of Total – For All, F...

SAS Viya : using multiple Tags on SAS DRIVE 2.2 , can you specifically...

SAS Viya : Using Environment Manager, locate folder

Re: SAS Studio background submit logs

Re: SAS Studio background submit logs

SAS Studio background submit logs

Can you programmatically do background job submit in SAS studio?

Re: SAS VIYA : How do I change which caslib to be active?

Re: Working with Interactive filters in dynamic text. How to make cond...

SAS Analytics Explorers