Hi,
If i have a Two datasets one has 10 variables and other one has 10 variables or may be less or more
How to compare the datasets variables names and properties (Char, numeric, format, informat, length....) if both same then it should come TRUE or If it's not same any one then it should come ERROR.....how to do can any one help on this...
Thanks,
You should start with PROC COMPARE, and taket it from there...
Thanks LinusH, But i'm looking in Macro code not PROC
Why?
req is macro
?
"Macro" meaning what?. Can't you embed PROC's in the macro?
Otherwise, you can use SAS File I/O functions, which can call from %sysfunc. But I believe thatwill generate some more coding...
Below code should give you a start. Now it's only about wrapping a macro around the code (if you must) where you pass libname and tablenames.
data have1;
set sashelp.class;
run;
data have2;
set sashelp.class;
/* label sex='Different from have1';*/
run;
%let Same_Flg=0;
proc sql noprint;
select count(*) into :Same_Flg
from
(
select name, type, length, npos, varnum,label,format,informat,notnull,precision,transcode
from dictionary.columns where libname='WORK' and memname='HAVE1'
outer union corr
select name, type, length, npos, varnum,label,format,informat,notnull,precision,transcode
from dictionary.columns where libname='WORK' and memname='HAVE2'
)
group by name, type, length, npos, varnum,label,format,informat,notnull,precision,transcode
having count(*) ne 2
;
quit;
%let Same_Flg=%eval(&Same_Flg = 0);
/* Same_Flg: 1 if no differences, 0 if differences */
%put XXXX &Same_Flg;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.