topic Exporting dataset to MS Access 2010 in SAS Programming

Exporting dataset to MS Access 2010

PhatRam32 — Fri, 07 Dec 2012 22:50:19 GMT

How do I go about exporting a dataset to an existing table in access?

Can someone give me an example and sample code to start with?

Kinda lost on this one..

PGStats — Fri, 07 Dec 2012 23:28:23 GMT

It is quite simple using SQL :

libname ac Access "myDatabase.accdb";

proc sql;

insert into ac.myTable (myVar1, myVar2, myVar3)

select myVar1, myVar2, myVar3

from myDataset;

quit;