many  procs ! with datasteps, ......  As I say before , the code is correct, in the first time gives an error , in the second time, when I have more disk space, i get the results without any error .. ... View more

Save your files by either copy and pasting to a text file, I recommend this one because the browser refreshes unexpectedly. Or File>Save The key for #2/3 is to set up the shared drive, moved the files to the myfolders folder and to reference it as '/folders/myfolders/' To allocate a library you first need to set up a shared drive to that location. Generally you need to set up a folder called myfolders under C:\SAS-University-Edition\myfolders as specified in the instructions. You can set up your folders under here and then reference them as: libname mylib '/folders/myfolders/project1'; To import files place them in the myfolders folder and then you can use proc import or a data step as in Base SAS, again using the '/folders/myfolders/excel_file.xlsx' path to the file. Detailed instructions for everything above is in the first link I referenced. ... View more

Hi,   I'm not sure of what platform you are running this on, but if you are using mainframe Z/OS, you might consider having one subtreatment in a generational file and then at the end in a separate JCL step, you might concatenate the gdgs into one dataset through a SyncSort - Copy option and you will have all subtreatments combined to one master dataset.    The individual generations will be pointing to sub-treatments and the output of the SyncSort  copy will hold the master data that includes all subtreatments.    If you are running in a Unix platform, you might use a concatenation utility to do what Syncsort does on the mainframe.   Hope this helps...!!!     ... View more

Please ask a proper question!  https://communities.sas.com/t5/SAS-Communities-Library/How-to-ask-a-question-in-SAS-Analytics-U-Communities/ta-p/221163   You expect people to spend their time for you so please have also the courtesy to invest the time required to provide the necessary information.   ... View more

Sorry, still not clear to me what you mean by that. Again, I think showing some example data and desired result might help. ... View more

Thank you for answer.. yes, your answer can reply to in party of my question.. you can see my answer to andreas_ids ... View more

Use sashelp.vstable to build a call execute (proc compare). ... View more

you say "Currently the implementation of proc sql without an order by variable will tend to order data by the values of the varaibles as they appear on the Select clause"   You mean that : sas will order the final data by the variables in select clause ? Thank you ... View more

So if it runs on UNIX then 1) It will not write a file with a name like 'c:\dir\class.xls' since Unix filenames will look instead like '/dir/class.xls' . 2) You will need to either have the directory that Unix writes to cross mounted to your PC or use some software such as FTP to move the file to your PC.      Are you sure that the file is being moved to your PC as a BINARY file?  If FTP moves the file as a text file then it will insert extra carriage returns and those will ruin the binary structure of an XLS file. 3) Or perhaps you are using a SAS PC Files Server that the Unix SAS program can connect to and write a file in Excel format?  Where is that server running? Is it on your PC or some other PC on the network? You should be able to paste the lines from your SAS log with the PROC EXPORT command as I have done above. If you do not have such lines in your SAS log then perhaps you are not using PROC EXPORT at all?  Are you using an Export Task in Enterprise Guide? ... View more

You should be able to. ... View more

I will send you the error message later But , if  i remember well, it will write ERROR .....EXCEL..... Question: we do not need a  window server with SAS/ACCESS to PC Files ? ... View more

In newer EG version the default appears to be set to 32767 - but you can of course always change it to the value you need. ... View more

As far as I am aware Excel workbooks are stored in a proprietary format that cannot be analysed by any Unix command. Also I don't follow your logic wanting to verify that column 1 in a spreadsheet contains 0 without "reading the table". You have to read in the Excel file in some form to be able to verify its contents. If you access Excel from SAS using the EXCEL LIBNAME statement SAS is still reading the data even to create a temporary VIEW. This would one of the options I would recommend. ... View more

Guess that would be done on OS level via a Unix command. What's going to work will depend on your environment. Good thing is: There is heaps of information & discussions around this on the Internet. Just two links: process - How to list processes locking file? - Unix & Linux Stack Exchange How can I determine what process has a file open in Linux? - Super User ... View more

If you have multiple workspace sessions, you can run multiple programs simultaneously.  I described these steps in a blog post about "multitasking" in SAS Enterprise Guide. Also, you can enable "parallel execution" on a single workspace definition -- EG will spawn multiple sessions to submit jobs in parallel.  To enable, select File->Project Properties, then the Code Submission tab.  There is a checkbox to enable this per project. Chris ... View more