SAS function htmlencode() lets you encode such characters. Below how this could work for single and double quotes and the ampersand with minimal change to your existing code. data have; Companyname="Bob's Burger"; run; proc sql noprint; select htmlencode(Companyname,'apos quot amp') into :CompanyName from work.have /*where id = &id*/ ; quit; %put CompanyName: %nrbquote(&CompanyName);   ... View more

Yes, I saw your earlier post, and suggested Data Controller so you don't have to hand-code this.  But I'll admit for little stuff I've hand-coded a few stored processes to allow users to maintain a simple table with a list of items.   It sounds like at this point you have a stored process (?) Manage_Companies that works if you use your browser to go to:   https://servername.com/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FStored_Processes%2Fcsg%2FManage_Companies.sas And I think you're creating a new stored process Edit_Company.  Is that stored process working?  Do you have a URL you can go to manually that works, something like: https://servername.com/SASStoredProcess/do?_action=execute,nobanner,newwindow&_program=%2FStored_Processes%2Fcsg%2Edit_Company.sas?ID=3 ? First I would get it to the point where you have working URLs for both ManageCompany and EditCompany. For the EditCompany you can hardcode the value for the ID parameter.   Then the next step is to work on having SAS generate a link with a URL to EditCompany.  So you could have a PROC REPORT step or whatever, that has rows for each company, and a column with a link that displays as "Edit" which when clicked will run the EditCompany stored process, passing it the appropriate ID.   But before trying to get SAS to generate the URL to run EditCompany, you need to know the exact URL you want to generate.   ... View more

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   ... View more