cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
smallavolu
‎10-02-2023
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Create SQL Server table from SAS program

by Calcite | Level 5 in New SAS User
‎11-18-2022 10:19 AM
‎11-18-2022 10:19 AM
Thanks Quentin and SASKiwi for all your help and tips.  ... View more

Re: Create SQL Server table from SAS program

by Calcite | Level 5 in New SAS User
‎11-18-2022 01:16 AM
‎11-18-2022 01:16 AM
Yes the missing bracket was the issue. But, surprised the program did not throw any error. Any I just used MyServer.Mydatabase.dbo.SM_TEST1 .   One follow-up question, how to use pass thru SQL when we need to use insert or update statements. As how can use SAS datasets in SQL pass thru statements.   Thanks, Shirish ... View more

Re: Create SQL Server table from SAS program

by Calcite | Level 5 in New SAS User
‎11-17-2022 06:01 PM
‎11-17-2022 06:01 PM
Thanks, but still no luck. This time code does not throw any error. But, no table is created. ... View more

Re: Create SQL Server table from SAS program

by Calcite | Level 5 in New SAS User
‎11-17-2022 04:27 PM
‎11-17-2022 04:27 PM
Thanks SASKiwi.  But, which is used as user mentioned in LIBNAME "uid" as "user=uid" does have rights to create the tables. and I did cross check by creating table SSMS.   Thanks   ... View more

Create SQL Server table from SAS program

by Calcite | Level 5 in New SAS User
‎11-17-2022 04:02 PM
‎11-17-2022 04:02 PM
Hi,   I am new to SAS programming, trying to create new SQL Server table and then insert data from SAS dataset. Here are the steps I have used, 1. Create a ODBC data source (Microsoft SQL Server Native Client Version 11.0), as 'XXX_DSN'. 2. Below is the SAS program I have used. LIBNAME FA ODBC DSN='XXX_DSN' schema=dbo datasrc="XXX" user=uid password=pwd; PROC SQL; CREATE TABLE FA.SM_TEST1 ( ID varchar(12) ); quit;   I end up getting error as below. NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'YYYYDataMart'..   Please help.   Thanks, Shirish   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-02-2023 02:31 PM
  • Contact User via AIM
  • Contact User via ICQ
Quick links