Can you explain in non code what that program is trying to do? I wouldn't normally use an "ALTER TABLE" statement in SAS.  To add a column to a table would require SAS to totally recreate the table. So at that point why not just use a data step or an SQL create table statement to make the table you want? ... View more

That's essentially what I am doing... however, the macro is located in another file. so i %include the macro(s) file and then call the macros from the other program. so my macro (in the external file) would look something like this: %macro test; rsubmit server="server"; data make_ds; set ds2; run; endrsubmit; %mend test; this then throws an error: connection to "server" does not exist. you must establish  a connection by issuing the signon with the server=option or setting the global autosignon option. remote submit to "server" canceled. and then sas hangs with "remote processing in progress" so i tried to add the signon="sever" option to the macro, which presented me with a window to fill out some credentials, and eventually told me that the SAS/CONNECT Server name should be a quoted string. ... View more