I run proc sql by connecting to sql server table (proc sql; connect to sqlsvr (dsn=table_name readbuff=15000)) I would like to run a proc contents on the table (dsn=table_name) but I must be getting the syntax wrong.  Is it even possible to run proc contents when connecting to SQL server?   Any help would be appreciated... ... View more

Hey SAS Community,   Newish to SAS Enterprise Guide.    Looking to create a semi perm table (that can be accessed by multiple users) that will append a table daily with data in a new date range and remove the oldest date range from the table so its constantly in a 90 day date range.  I know someone cannot just simply write code for me, but looking for direction on functions/concepts (proc append, possibly a macro, etc....)  I should be studying.  If this has been answered before, maybe you could help me with even search terms.  I just can't find exactly what I am looking for.   This table will run analysis over date ranges on the data that will inform volume increases daily, weekly, monthly.  Hope that makes sense.   Thanks, b77 ... View more