Prev: SAS using advanced excel
Next: Libname Function and Connection Strings
From: Ken Barz on 5 Jan 2010 13:28
We have a generalized macro that creates libname assignments based on values passed in a metadata dataset using the libname function. Naturally, now we have a new data management system that breaks that. So, if I have a libname that looks like so:

libname datain oledb init_string="Provider=VFPOLEDB.1;Data Source=&inpath.\_system.DBC";

is there some syntax to get the libname function to set using the init_string stuff? The simplified data step we're using is something like:

data _null_;
set meta.tsc_current_header;
if type='libname' and include='Yes' then do;
if parameter = 'DATAIN' then do;
libn = libname(parameter, resolve(value) , 'oledb');
end;
else do;
libn = libname(parameter, resolve(value));
end;
end;
run;

where parameter is the libname and value (for all other libname assignments) is the path.
Thanks,
Ken
 | 
Pages: 1
Prev: SAS using advanced excel
Next: Libname Function and Connection Strings