About ybolduc

ybolduc · ‎05-10-2019

Hi Mokalake, SAS may not be the best tool to do Web Scraping the way you want to do it. But if you really way do this with SAS, you will need to use PROC HTTP to download the page. Once you have the page downloaded, the best would be to use Regular Expressions to find the information that you are looking for. You will likely need to use SAS Macros to wrap your logic and make iterate properly. Note that both PROC HTTP and Regular Expressions are fairly advanced skills in SAS. Thanks,

ybolduc · ‎01-16-2019

Hi PaalNavestad, I believe you would have more success with the libname pcfiles engine: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=n1qk7lv0f535qkn1mydookwetyrp.htm&docsetVersion=9.4&locale=en Thanks, Yoan

ybolduc · ‎10-22-2018

Thanks Margaret, this is very useful to use as a reference when planning our Cloud implementation!

ybolduc · ‎08-27-2018

Hi KurtBremser, Kudos to you for being so patient with this poster!

ybolduc · ‎08-27-2018

You get this error because all your parameters are positionnal parameters and you are trying to address some of them as name parameters (i.e.: line_index=2).

ybolduc · ‎08-24-2018

Can you please provide a copy of your log and the datasets your are using? Thise is likely caused by missing values.

ybolduc · ‎08-20-2018

Hi Mathie, I get the feeling that you may need to hire a technical architect for your solution. This is a support forum, we can provide input for technical detals but I think at this point the answers you are looking for would better be addressed by someone who will take the time to understand your need and your existing technology and provide you different options. Thanks,

ybolduc · ‎08-20-2018

Hi Mathie, Yes, SAS can connect directly to a MySQL database and extract the data. It can also write the result back to MySQL. To do so, you will need to acquire SAS/Access to MySQL. SAS being an extremely poverful and flexible platform, there is an extremely large numbers of way to do this. Using Stored Process as mentionned earlier is probably the most user-friendly approach if there is no existing SAS practice at your corporation. Thanks,

ybolduc · ‎08-13-2018

Thank you very much Simon! This the kind of document we were dreaming off about 8 years ago at one of my previous jobs 🙂

ybolduc · ‎08-10-2018

Hi, I was wondering if anyone has used SAS 9.4M5 (or just SAS 9.4) on a Windows or Linux Software RAID? Was there any issue? Did you get the performance gains that you expected? How has it impacted you CPU and memory usage? Thanks in advance!

ybolduc · ‎08-02-2018

First of all, yes you can connect to a Linux SAS Metadata from a Windows workstation using SAS Enterprise Guide. Regarding the setinit, you may have to reach out to your sale rep to obtain a SID, order and plan file that will allow you to download the depot and install on Windows. The challenges you may face will depend on your skill level. To an experience SAS Administrator/Installer, this is pretty routine stuff. I've seen EG clients connect to SAS Platform running on Solaris, Linux, AIX and Windows. All configurations are pretty similar, that is the beauty of SAS 🙂

ybolduc · ‎08-01-2018

I think regular expression would be the easiest way to do it. Here is how I would do this: data want; length mytext $100.; input mytext $; flag = ifn(prxmatch('/[^a-zA-Z0-9 ]/', mytext) > 0, 1, 0); datalines; Hello Sébastien ; run;

ybolduc · ‎08-01-2018

Personnaly, I would go for option #1. Before applying the label and formatting, I'd probably include a step to validate that all expected columns are present and have the right type. This would allow you to discard the file right away and send a notification. Saving you the trouble of regularly scrubbing the logs in search of "ERROR:". I try as much as possible to assume that the data I receive could be wrong and put in place the right validations.

ybolduc · ‎07-31-2018

The SAS documentation actually includes an example with relative path (see Example 1): http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lestmtsglobal&docsetTarget=p1s3uhhqtscz2sn1otiatbovfn1t.htm&locale=fr#n00bihrpksgveyn1i4sccqyilq74 But be careful when using relative path, they are normally relative to the working path which is not necessarily the same as the path where the current program is stored. So in some context, relative paths can lead to unexpected behaviors.

ybolduc · ‎07-31-2018

The dot is simple punctuation, properly formed sentences end with a dot. Does SAS really print XXXXXX as the path or did you hide it yourself? Are you sure the "working path" is really where you expect it to be?

Online Status	Offline
Date Last Visited	‎01-27-2020 04:54 PM

Re: web scraping

Re: Specify where PC File server is located

Re: Updated papers from the SAS Performance Lab.....

Re: how to create a sas program and run using unix

Re: All positional parameters must precede keyword parameters

Re: full join proc sql

Re: SAS API

Re: SAS API

Re: SAS 9.4M5 and Software RAID

SAS 9.4M5 and Software RAID

Re: SAS API

Re: INTNX Function Not Working

Re: SAS 9.4M5 and Software RAID

Re: Kindly Help to resolve code

Re: NonEnglish Character

Re: Updated papers from the SAS Performance Lab.....

Re: SAS 9.4M5 and Software RAID

SAS 9.4M5 and Software RAID

Re: libname --- meta library='～' metaout=data;

Re: Linux SAS EG Installation in Windows

Re: web scraping

Re: Specify where PC File server is located

Re: Updated papers from the SAS Performance Lab.....

Re: how to create a sas program and run using unix

Re: All positional parameters must precede keyword parameters

Re: full join proc sql

Re: SAS API

Re: SAS API

Re: SAS 9.4M5 and Software RAID

SAS 9.4M5 and Software RAID

Re: Linux SAS EG Installation in Windows

Re: NonEnglish Character

Re: Importing and labeling multiple CSV files without coding variables...

Re: %include to run multiple programs

Re: %include to run multiple programs