10-30-2015 01:32 PM
I have a SAS table with columns of dataset name and field names. I need to take the dataset name, and field name in each row and test if the dataset exists under a directory; if exists, I need to test if the field exists in the dataset. Then I need to update the table with two additional columns DatasetExit and FieldExist with 'Yes' and 'No'.
Any suggestions would be highly apprecaited!
10-30-2015 01:39 PM
10-30-2015 02:06 PM
Something like this perhaps?
data have; informat memname name $32.; input memname name; label memname='Data set name' name ='Variable name' ; datalines; class sex class name class town iris species iris petalwidth iris weight frivolous name ; run; proc sql; create table want as select a.*, exist(cats("SASHELP.",a.memname),'DATA') as DataSetExists, (not missing(b.name) ) as FieldExist from have as a left join ( select * from dictionary.columns where libname='SASHELP') as b on upcase(a.memname)=upcase(b.memname) and upcase (a.name)=upcase(b.name); quit;
This has 1 for yes and 0 for no. You can assign a format or add logic. I recommend a format.