About Ryanb2

Ryanb2 · ‎02-12-2024

Thanks, Sajid01. If running from the snippets folder is more complicated then I don't have any concerns about running from a non-snippets folder, but running from a non-snippets folders gives me the same error message.

Ryanb2 · ‎02-12-2024

Thanks, BrunoMueller. I ran your code and I can see the URL in the log doesn't match the URL I currently see in my session nor does this URL include anything that looks like a port number. I'm not sure I know what to do with this information.

Ryanb2 · ‎02-12-2024

Thanks for the suggestion. Sorry. I was doing some masking so I doctored the image a bit. I always use the insert as path option so case and path should not be the issue.

Ryanb2 · ‎02-09-2024

Thanks, BrunoMueller. I think this image includes everything you mentioned.

Ryanb2 · ‎02-08-2024

Thanks for the reply BrunoMueller. I moved my code to another folder but I'm still getting the same error message. The error message indicates a problem with the path. Whether I try the filename statement with or without referencing the SAS code I get the same message so I don't think this is about the file extension. When I right click my program and select properties it has a sas extension and the type is SAS Program. filename ffile FILESRVC folderpath='/Users/ryanb/My Folder/SAS_FILES' filename='program.sas'; %include ffile / source; filename ffile clear; ERROR: Folder denoted by path '/Users/ryanb/My Folder/SAS_FILES' was not found. ERROR: Error in the FILENAME statement.

Ryanb2 · ‎02-07-2024

I looked up ls parameters and came across --full-time. It generates output a little different than before but everything is now consistent. filename pipedir pipe %sysfunc(quote(ls -lR --full-time "&pathDir" )) lrecl=1000; data DIR; infile pipedir truncover; input line $char1000.; run;

Ryanb2 · ‎02-07-2024

I'm very close but I'm getting some strange results: filename pipedir pipe %sysfunc(quote(ls -lR "&pathDir" )) lrecl=1000; data DIR; infile pipedir truncover; input line $char1000.; run; this code returns some values with the year and others with the time. -rw-------. 1 ryanb domain users 40016 Aug 7 2023 FILENAME1.mor -rw-------. 1 ryanb domain users 40016 Aug 14 10:10 FILENAME2.mor It will provide one or the other but never both, at least in the sample I reviewed.

Ryanb2 · ‎02-07-2024

Thanks! Yes. I was masking my path and pasted my example in the wrong format. I appreciate you making that clear and for letting me know I don't need DIR or quotes in the command statement. I pasted some code below that worked as you described. filename pipedir pipe %sysfunc(quote(ls -lR /TEMP )) lrecl=1000; data DIR; infile pipedir truncover; input line $char1000.; run;

Ryanb2 · ‎02-07-2024

Wow! I was not sure where to put your changes in my line but it worked on the first try! Very nice. The format is different than in windows but the information is the same and it includes the subfolders. Much appreciated! filename pipedir pipe %sysfunc(quote( dir ls -lR "C:\TEMP" )) lrecl=1000; data DIR; infile pipedir truncover; input line $char1000.; run;

Ryanb2 · ‎02-07-2024

Thanks for your suggestion, MAGG. I tried adding the sas program as you described but I'm still getting the same error message.

Ryanb2 · ‎02-07-2024

Thanks for the reply BrunoMueller. I tried the code exactly as you provided after replacing my userid (see below) but I'm getting an error message when running the filename statement: ERROR: Folder denoted by path '/Users/ryanb/My Folder/My Snippets' was not found. ERROR: Error in the FILENAME statement. filename mypgm filesrvc folderpath="/Users/ryanb/My Folder/My Snippets"; I also right clicked on the My Snippets folder and selected "insert as path" and verified I was using the correct path.

Ryanb2 · ‎02-07-2024

I'm a base SAS user but getting into SAS Viya. One thing I do frequently in base SAS is inventory files on the local network or my C drive as shown below: filename pipedir pipe %sysfunc(quote( dir "C:\TEMP" /S )) lrecl=1000; data indata; infile pipedir truncover; input line $char1000.; run; It returns raw information about the folder path, the contents of the folder, the subfolder paths and subfolder contents. Each file includes date/time modified, and file size in addition to the filenames. I can parse and combine the raw data to get exactly what I need which I then use to find new files and import them automatically. However, when I run similar code in SAS Viya using an NFS mounted drive I only get the filenames for the immediate folder. No subfolders and none of the other information. This is useful enough for most purposes but not including the subfolders is going to be a problem. Does anyone know how to get the kind of information I get using my PC SAS version when using SAS Viya for a mounted drive? Because SAS Viya exists on a Linux server are there some Linux commands that can be run from my SAS code that give me what I need?

Ryanb2 · ‎02-07-2024

I've used base SAS for 15 years and now I'm moving to Viya. In base SAS I use a lot of %include statements to run other SAS programs from a SAS program, for example: %include 'C:/sample_sas_code.sas'; runs sample_sas_code.sas from my sas program However, when I try using the %include statement in Viya to run code I stored in my snippets folder I keep getting "ERROR: physical file does not exist". I right click on the SAS program and select "insert as path" so I'm pretty sure the path is correct. I'm guessing this is common knowledge but I've been googling this for a while and haven't been able to find the right word combination to find out how to achieve this in SAS Viya. I've seen mention that %include doesn't work in Viya but maybe just not in CAS(?). Is there someone who can point me in the right direction?

Ryanb2 · ‎10-23-2020

That worked! Thank you. It's frustrating the solution is not simpler. It seems logical and practical that strings to exclude could be contained in parentheses like in my example code. It would make it a lot easier to add more strings to exclude if testing showed more were needed. Much appreciated.

Ryanb2 · ‎10-23-2020

Thanks for your response. I considered doing something like this, but I simplified my code greatly in this post. I need to match on far more strings and for many more fields in a SQL statement. I will likely need to exclude more strings as well. If I was working in a data step I might write something like this and then process all the columns in an array, but I'm looking for a regular expression solution.

Online Status	Offline
Date Last Visited	‎01-10-2025 06:17 PM

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

How do I close an Access database located on a windows pc or local net...

Can I rename column 1 without knowing the name of column 1?

How do I extract filename, path, and date modified from a mounted dire...

Re: How do I constrain row height when defining column width in proc r...

How do I constrain row height when defining column width in proc repor...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

Re: How do I close an Access database located on a windows pc or local...

PRX match on string but excluding substring

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I inventory a mounted LAN folder from SAS Viya?

Re: How do I inventory a mounted LAN folder from SAS Viya?

Re: How do I inventory a mounted LAN folder from SAS Viya?

Re: How do I inventory a mounted LAN folder from SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

Re: How do I run a sas program from another sas program in SAS Viya?

How do I inventory a mounted LAN folder from SAS Viya?

How do I run a sas program from another sas program in SAS Viya?

Re: PRX match on string but excluding substring

Re: PRX match on string but excluding substring