have a question. I am have been tasked with copying an already existing SAS Solution and improving upon it. I am trying to allow the user to manage some of the tables within the solution like look up tables. That way the application becomes self maintaining and not left to the programmers to do the heavy lifting. My first attempt is a simple table: I just want to query from a table named 'Company' and then display the results in an html table. In addition, I want to give the users a link to edit that name or set it as inactive. I can't get it to work. I apologize for lack of specifics. I can add code in here if it would be helpful as well as the version of SAS if needed.
Thanks in advance
Yes, it is defintely out of my wheelhouse. Used to be a .net developer but doing this out of necessity. It's a long story but the solution is to match to group up organizations run by a single account. We are in the process of overhauling this system but are two years away at a minimum. The previous solution had a process with over 4000 lines of if statemennts and you had to add to it each time to needed a new item.
The answer is "yes." But if you want to deploy a SAS app for allowing users to maintaining data tables, I recommend taking a look at https://datacontroller.io/, created by @AllanBowe and his team.
I am not sure what you want to do.
If you want to use ODS HTML to generate an HTML file then just do that.
ods html body=_webout;
proc print data=national.company;
var companyname;
run;
ods html close;
If you want to use a data step to craft your own HTML file then do that.
data _null_;
file _webout;
if _n_=1 then put '<html><body><table><tr><th>CompanyName</th></tr>';
if eof then put '</table></body></html>';
set national.company end=eof;
html_string=htmlencode(trim(companyname));
put '<tr><td>' html_string +(-1) '</td></tr>';
run;
OK, essentially what I am trying to create is a two column table. One with the name of the company and the other column and link to another page where I can edit that record via an html form. Are both of these items possible to do inside a SAS stored process?
Yes. There are ways to generate a link PROC REPORT.
See the (2) example in this article. https://support.sas.com/rnd/base/ods/templateFAQ/links.html
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.