How to refresh data table from SAS

collin — Sat, 10 Jun 2023 23:39:11 GMT

How to refresh data table from SAS?

Usually people refresh data from Excel but I'd like try to refresh data from SAS.

I follow below step but not success.

source -> right click --> run script. (I'm sure that I already connect with SAS service, login successful)

Re: How to refresh data table from SAS

bryan_boone — Mon, 01 Nov 2021 15:57:23 GMT

If you look at the source script, you'll probably see something like this:

Meta Connect( "my sas server", 8561, "My SAS Auth Domain", ProfileLookup );
_importsasconn = SAS Connect( "My SAS Workspace Server" );
_importsasconn << Import Data(
	"MyLibrary.MyTable",
	SQLTableVariable( 1 ),
	UseLabelsForVarNames( 0 )
);

What this means is that the source script is going to look up a SAS Meta Data Profile that you've defined under

File->SAS -> Server Connections

When the profile is found, it will execute the Import Data portion of your script into a new table (not "in place").

If you run into problems post back any error/log messages that you encounter.

-Bryan

topic Re: How to refresh data table from SAS in Discussions

How to refresh data table from SAS

Re: How to refresh data table from SAS