![]() Any suggestions Currently, drug as XXXXX is not doing the trick. The example below is trying to assign an identifying variable DRUG that will let me know which drug a patient received when I stack all the data together. You can also use variables in a way that SQL Workbench/J will prompt you during. I want to capture some data using PROC SQL and then assign a variable with all the same value. ![]() Is there a way that I can get SQL to prompt the person running the query to enter the data? below is an excerpt of the code that has what I am talking about in it. To remove a variable simply set its value to nothing: WbVarDef myvar. As of right now, I just wrote it so that you enter the information at the top of the query and its stored as a variable. ![]() ![]() I have a query that I wrote in SQL server that will be run mainly by people who don't know SQL, and there are two areas that have to have a different string or date entered each time the query is run.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |