About ErinKSimmons

ErinKSimmons · ‎04-05-2024

Each of the <No item selected> is an individual parameter set in the "Choose Filters Here" prompt container.

ErinKSimmons · ‎04-05-2024

I have done this, but I am having trouble with the solutions I have found for dropdown list not working for the multi prompt parameters where I would like to create an advance filter so I don't see <No Selected Value> but rather just a blank in this space.

ErinKSimmons · ‎04-18-2023

Thanks, I used the macro approach solution. Your untested macro worked, for the record.

ErinKSimmons · ‎04-18-2023

We have a bit of code (see below) that will output to a table in the work library a list of all tables in a user specific schema. Then will delete a table if it exists. This bit of code works well if the user's schema has tables in it, however some users are new and haven't created any tables so their schema is empty and PROC DATASETS generates the following warnings. WARNING: No matching members in directory. WARNING: Output 'members' was not created. How do I create and empty table, but with the same column names, when there are no members. Or is there a better way to generate a table full of dataset names for occupied and empty libraries. libname MySchema oracle authdomain=oracle_auth path=database; **List out Tables in MySchema to delete table if it exists; ods output members=my_tables; proc datasets library=MySchema; quit; data _null_; set my_tables; if upper(name) eq 'TEST' then do; call execute('proc delete data=MySchema.TEST;run;'); end; run;

ErinKSimmons · ‎01-18-2023

http://support.sas.com/kb/66/147.html Run program and have PROC PRINT to generate the HTML, EXCEL etc. results. Then I down the three dot menu > Download > Excel File and nothing happens. Seems it is related to this support issue, but I can't tell if our SAS Viya/Data Studio is already updated to include this Hot Fix.

ErinKSimmons · ‎11-03-2022

@AllanBowe thank you for this idea, but it isn't quite the goal I am after.

ErinKSimmons · ‎11-03-2022

Understood. In the past in EG we would create a LIBNAME to a network drive path and use that to bring in and output SAS and Excel datasets and files. The goal is to mimic that in Viya.

ErinKSimmons · ‎11-02-2022

I thought you meant the OS of the computer that would be accessing the drive. The Viya OS is Linux

ErinKSimmons · ‎11-01-2022

OS is Microsoft Windows 10 Enterprise Version 10.0.19044 Build 19044 SAS Viya release V.03.05

ErinKSimmons · ‎11-01-2022

To give background. We had been using SAS EG and are converting SAS Viya and data studio. Our current network drives and set up has been in place for a while and the architecture was set up by someone no longer here and to further compound the issue the branch being the administration (network or SAS). We have a need to pull in and output data to a network drive and are getting push back and as an end user I am trying to learn what I need to ask for and to whom I need to ask do it. So for me it wasn't an easy google search and any advice is appreciated.

ErinKSimmons · ‎11-01-2022

Is there an article that I could reference for our SAS Admin about how to give this access to the network drive folder?

ErinKSimmons · ‎07-28-2020

Each month we pull a snapshot of the Value of Inventory. We try to run this the first of the month, but if that falls on a weekend, we do it the following Monday. This is only one of several monthly files we output. The files all follow the name pattern OH_DI_ALL_DDMONYYY where DDMONYYYY is the date the data was run since it won't necessarily be the first of the month. The only thing that changes in the directory name is the month portion. There is a subfolder ValueofInventory in each month's subfolder. I want to access one SAS dataset from each month within the ValueofInventory subfolder in that month folder. I am using the : because I want to go into 49 month folders into the ValueofInventory subfolder and access the one SAS dataset, whose subscript date (DDMONYYYY) may vary. Yes I want to add the variable to indicate what directory it comes from because it was a snapshot in time and never originally intended to be concatenated but rather use just one file at a time. Now they want to append to track a historical value from all of these different snapshots so I have to create this variable to do the time series graphing.

ErinKSimmons · ‎07-28-2020

I am hoping to get code that will loop through the past 49 months of data and import the SAS dataset saved there and then append all 49 together with a new column for the date from the file name. DATA _NULL_; DO i = 1 to 49; DATA _NULL_; MP1DB = INTNX('month',today(),-i,'B'); CALL SYMPUTX ('CURRENTMONTH',CATS(SUBSTR(PUT(MP1DB,yymmn6.),1,4), '-',SUBSTR(PUT(MP1DB,yymmn6.),5,2))); RUN; libname wm "\\SFLC-SAS-AP\pod-data3\MDR\&CURRENTMONTH.\ValueOfInventory\"; data work.oh_di_all_MPi; set wm.oh_di_all_:; month=&CURRENTMONTH.; run; END; RUN; %macro append; data work.oh_di_all; set %do i = 1 %to 49; oh_di_all_MP&i %end; ; run; %mend append; %append;

ErinKSimmons · ‎03-01-2020

Thank you! This was also a great solution. Small note, a ) is missing in this line: max_two_weeks=max(max_two_weeks,sum(of two_weeks{*}); should be: max_two_weeks=max(max_two_weeks,sum(of two_weeks{*}));

ErinKSimmons · ‎03-01-2020

Thank you Patrick for your quick solution

Online Status	Offline
Date Last Visited	‎04-09-2024 10:21 AM

Re: Displaying checkbox selections

Re: Displaying checkbox selections

Re: PROC DATASETS on empty library

PROC DATASETS on empty library

SAS Data Studio in SAS Viya Download Excel Results after PROC PRINT

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: Displaying checkbox selections

Re: SAS Studio: Accessing PC/Local files

Re: Looping through Files to Import SAS Data Sets

Re: Looping through Files to Import SAS Data Sets

Re: Two Week Maximum by Group

Re: SAS Studio: Accessing PC/Local files

Re: Displaying checkbox selections

Re: Displaying checkbox selections

Re: PROC DATASETS on empty library

PROC DATASETS on empty library

SAS Data Studio in SAS Viya Download Excel Results after PROC PRINT

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: SAS Studio: Accessing PC/Local files

Re: Looping through Files to Import SAS Data Sets

Looping through Files to Import SAS Data Sets

Re: Two Week Maximum by Group

Re: Two Week Maximum by Group