Exactly, just out of curiosity:) . ... View more

I know my question should go to SAS EG community, but since my question is very similar to Julo's, hope you all don't mind it. I had exactly same problem with Julo except that my program ran in remote Linux server through EG. The trouble is that it not only showed error message in log, but also prevented me from running any other code. I mean, even after I restarted EG and ran some new code, the same error message still popped up as if the previous include statement was still running behind. I think I may need some way to quit the session or somehow, but I don't know how to do it. Thanks in advance. ... View more

I believe Tom has given you the explanation why your path isn't working. In general: The SAS code generated by DIS executes on the server you're connected to. That's why you need to define paths as they are "seen" and accessible from the server and not how you possibly see them from your client. It's not good practice with DIS to use fully qualified path names. The reason is that you're very likely developing in a DEV environment but then promote your job to TEST and PROD. The paths will likely change between the environments and you should also allow for your %included code to have a DEV, TEST, and PROD version (eg. /rootpath/Lev3/projectpath..., /rootpath/Lev2/projectpath/...). You must code in a way that you can promote your codes to a higher environment without the need for any code changes so you should at least use a macro variable for the 'Lev' bit - and this variable should be defined in the project specific autoexec. You call the SAS file you want to use "macros.sas". If this is a SAS macro then even better would be this code is stored under a SAS Autocall Library SAS(R) 9.4 Companion for UNIX Environments, Third Edition This way you don't need a path at all in your DIS job. You should also try and avoid user written code. If you believe you have to call this macro in more than one DIS job then consider to implement by creating a User Transformation. I normally then simply call the macro in such a transformation and define prompts for the parameters to be passed in. ... View more

... > this assingment works in sas. > %let arr = 'aaa', 'bbb', 'ccc'; > > The "arr" variable contains the array of 3 strings? > Or it contains only one long string? It is a value that is assigned to a macro variable. Macro variables store text, or a string of characters. > Because when i pass the "arr" variable to %substr > function, it fail because the variable contains > comma, which is also separator in function > arguments. Yes, this is expected. > My question is ... > - in case it is only one string, how can i handle > special character (comma) in the string? By quoting, that is, hiding the comma's from macro processor.    %let arr = %str('aaa', 'bbb', 'ccc');    %put first word = %scan(&arr, 1, %str(,));    %put second word = %scan(&arr, 2, %str(,));    %*-- on log    first word = 'aaa'    second word =  'bbb'    --*; ... View more

Variables containing date-, time- and datetime-values are always integers. They look like "dates" when a format is applied to them. So adding a format to the variable containing the maximum will solve the problem. [pre]proc sql print; select max(modate) format=datetime. from sashelp.vtable; quit;[/pre] ... View more

Hello, I am newbie to sas. (a programmer forced to do someting in sas) I suppose - when I start enerprise guide I can run script locally on localhost sas server. I can add remote machine (in Enterprise guide explorer) and then run scripts over tables on remote server. In the code menu, there is "select server" item. When I want to work with tables on remote server I choose remote server and run script. I think/thought that script is running on remote server. I am trying to run some SQL based scripts. The same case is in Data Integration Studio - I enter servername/port/user/pass/repository and can run script over those tables. Basically, I need the same functionality as with SQL server - connecting with client to server and run script and get the results. In the terminology of SAS, the client is enterprise guide or data integration studio or sas.exe and I suppose that server is metadata server, database is repository. If not, please correct me. So in IDE (such as enterprise guide) I can click it and run ... and I need the same from command line with passing arguments/config to sas.exe. Something like "sas.exe -server asd -repository xyz -userid julo -pass pwd -script myscript.sas" or at least "sas.exe -config file.conf -script ,yscript.sas". But as I wrote "sas.exe /?" ir "sas.exe -h" doesn't work. Thanks in advance PS: we don't have sas/connect installed ... View more