How to refresh data table from SAS

collin

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)

 

bryan_boone

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