In the first dataset "ID(group)" is a value, so you need a normal assignment to change the value. data want; set have; if Subject = "ID(group)" then Subject = "id_group"; run;   EDIT: Added forgotten quotes. ... View more

Interesting. You need to post the complete log containing the code that ran, actually. Why do you want to include quotes in the values? ... View more

Check webdms.maxParallelWorkspaces and webdms.maxNumActiveBatchSubmissions ... View more

Limiting the number of sessions in SAS Studio can be achieved by changing the config of SAS Studio, the file is located in Config\LevX\Web\WebAppServer\SASServer2_1\sas_webapps\sas.sasstudio.war\config and SASHome\SASStudioMidTier\versionnumber\Static\wars\sas.sasstudio\config Have a look at the documentation! You need to restart the sas app server to apply the changes.   Unfortunately there is no easy way to achieve the same in SAS EG. In theory, with xcmd enabled, you could add some code to the script starting the sas session, checking how many session are active for the user and prevent execution of the sas executable. Fortunately i never had to implement this. ... View more

Maybe Report Writing Interface could be used to place tables next to each other. I never had to do this, so i can't provide any code. ... View more

@femiajumobi1 wrote: Thanks @ballardw Back to my question, how do I ensure in csv the value comes with one decimal point (5.0) and not default back to an integer (5). Thanks. As long as you insist on opening a csv file with a spreadsheet app and not with a simple text editor, there is no solution for the problem. A csv file is a text file, it does not contain any metadata, so it is impossible to tell the app to display values as they are and skip optimizing the data. ... View more

Please post properly formatted code using the "insert sas code" button (little running man), also post the complete log, so that we see the error message and its context, actually.   EDIT: It looks as if you have >> tab="sheet1" << in the middle of nowhere. This won't work. You have to provide the sheet-name while creating it. ... View more

You need to process the logs of the metadata server. Parsing those logs can be done with sas - not to difficult. Or with any other scripting language. ... View more

Another hash-solution (using the data provided by @yabwon 😞   data _null_; if 0 then set have; declare hash h(dataset: 'have', duplicate: 'e'); h.defineKey('x'); h.defineDone(); stop; run; ... View more

If a data step is used to read the files, a custom informat could change missing (aka null) to 0 automatically. ... View more

1) You may have heard it already, but "1812" is not a date, maybe a year, but not a date! 2) You may want to properly format your code making it readable. 3) I don't have access to your data, so i can't reproduce the problem you have => post the log! ... View more

Talking to the admin of the sas environment is recommended. ... View more

To avoid changes in types, lengths and formats don't use proc import to read a csv-file, write a data step instead. ... View more

Maybe i am wrong, but @michal_1407 wrote: ...       real time           13:08.07       cpu time            0.35 seconds means, that sas needed 0.35 seconds to its job, but had to wait 13 minutes all in all so that other processes can complete their part of the task.  With the tiny dataset used, i would exclude the network connection as possible bottleneck. Which SAS version is used? Older version used older version of Java, so maybe there is a problem in with the jdbc driver combined with a elderly Java version - just guessing. ... View more

I would be easier to help you, if you could share some data (as data step using datalines) and show the expected output. ... View more