About mwhitaker

mwhitaker · ‎12-11-2019

Hi, We have been using the macro %Squeeze for years. you can find it in the SAS Notes here: http://support.sas.com/kb/24/804.html Attached is an update to this macro, where I have expanded it's scope to include Libnames defined on Databases, ODBC for MS SQL Server, or maybe others. It depends on the implicit pass through abilities of that SAS-Database Relationship for it to work well. That is, the SQL used to get the sizes of the columns needed to reduce the overall size of the table needs to be performed on the database server side. It works for us using ODBS to a MS SQL Server database. I have no access to other databases, so there has been no testing for these. We are using it to insure the size of the data coming from these places are reasonable, and maybe to speed up the writing of this data. I give it here, without support, for others to enjoy or curse at . Mike

mwhitaker · ‎03-01-2019

Use a Libname Statement to create another connection, It looks like you are writing to a dbo schema. Libname dbo odbc Required='....' schema=dbo; Then a Proc Append (The Data Set will not work, because it will want to delete the current table) Proc Append base=dbo.ukbb_statin data=[your table] [other options as needed]; you need to get the data over there somehow, and this seems the cleanest to me. That last Execute statement will not be used. I would try just the Libname and Proc Append,, and see if the table is created by SAS. Good Luck Mike

Online Status	Offline
Date Last Visited	‎12-11-2019 06:12 PM

A useful update to the Squeeze macro?

Re: Execute statement for MS SQL Server

A useful update to the Squeeze macro?

A useful update to the Squeeze macro?

Re: Execute statement for MS SQL Server