There's surprisingly little in the SAS knowledge base to be found for this NOTE, and that is related to z/OS. So the only thing that's left from my POV is some difference between the two environments (user permissions, option settings) that makes the macro syntactically or semantically wrong in the CIS.   In any case, I'd put the issue to SAS technical support. With them, it's easier to reveal the code. ... View more

Looks like &_input contains the name of a SAS SQL view that requires sorting, and the sort fails because it runs out of resources. Inspect the SQL view (DESCRIBE) and run the step(s) manually. You might also need to increase resources like disk space in WORK and UTILLOC locations. ... View more

Yeah. It is Oracle DBA job. You can query Meta Data(Dictionary table) to get the number of records of a Oracle Table. Ask Oracle DBA how to write this kind of Oracle SQL statement, and Pass - through it by SAS Proc sql . ... View more

If you have character variables of considerable length (which are rarely completely filled) in your SAS dataset, and don't use compress=yes, then your output .csv files will automatically shrink, as the empty space is discarded and only the non-blank bytes are written.   I'd rather let SAS write one large file, which I'd then split with either operating system tools or a separate step in SAS. Alternatively you could use the FILEVAR= option in the data step, cumulate the number of bytes for each iteration, and switch the output file when a treshold is reached. ... View more

Thats a fairly large amount of data your dealing with then, if its multiples of 1gb in a CSV.  May I ask why you need to split it into multiple files.  A couple of other ideas: Generate one CSV and stream it via HTTP Generate one CSV and ZIP that using the inbuilt function of WinZip/RAR to split the archive into chunks of 1gb Reassses if you really need to send that amount of data, what is the purpose of it, i.e. if they are just summarising it, why not summarise at your end and send the summarised data Can you compress the data in any ways, for instance code longer text strings into small numbers, and provide a code list or formats catalog with the data - you would be amazed at the amount of storage space saved merely by changing a 20 character string into a 3 number coded value.  ... View more

It's true that SAS Visual Analytics, which includes SAS Visual Data Builder, cannot create, edit or save an information map.  However, SAS Visual Data Builder can import the business logic from a relational information map and represent it as an SQL query.  The instructions are in the SAS Visual Analytic User's Guide here: http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p0vj8bo0sy9qzln1vcl0yxt64vqn.htm.   Information about creating information maps is available in the Base SAS Guide to Information Maps.   Hope this helps, Joy ... View more