问任何人都可以使用示例代码将SAS表导入postgresql

EN

libname A1 postgres server=mysrv1 port=5432 user=myusr1 password='mypwd1' database=mydb1;

 libname mydata '/folders/myfolders/';

 data A1.yourtable;
  set mydata.yourtable;
  run;

                                                                                              then move csv data into postgres

import pandas as pd
from sqlalchemy import create_engine

engine = create_engine("postgresql://user:password@localhost:5432/databasename", echo=False)
df = pd.read_sas('sas7bdat file location')
df.to_sql('tablename', con=engine, if_exists='replace')