Hello,
I am attempting to utilized SAS to created a code that obtain the data from the clerk directory to help make my co-workers job easier and help make it easier to inform them about this important new update regarding vital records. I review several articles and am stuck on the step involving the processing/parse the web page contents to gather the data. I have made some progress but I am not sure how to create a data steps that allows me to actually read formName, formCounty, formJobTitle, and formEMail
I am attempting to to pull Clerk Name, Job Title, County, and Email from this webpage: https://www.cdcatexas.com/Directory/Clerks
* Pull out Clerk Name, Job Title, County, and Email;
filename src temp ;
proc http
method="GET"
url="https://www.cdcatexas.com/Directory/Clerks"
out=src;
run;
/* Read the entire file and skip the blank lines */
/* the LEN indicator tells us the length of each line */
data rep;
infile src length=len lrecl=32767;
input line $varying32767. len;
line = strip(line);
if len>0;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.