I have two datasets (ABC1/ABC2), where i need to validate that they are exactly similar (values wise and structure wise) and need to generate a report,   proc compare base=ABC1 compare=ABC2 briefsummary listall; run;   Issue here is that the dataset ABC2 doesnt contains the variable attribute values like (format, Informat and Label). Hence the report that is being generated is including all the variables as mismatch because of the misiing attribute values of the variables in  ABC2.   I need the output as Comparison of two dataset based on their variable name, type and length only, the comparison should not include mismatches for their formats, informats or label.   How can I customise the output for this comparison?   ... View more

Hi All,   I need to create a csv file for each of the dataset present under a library, having the data of proc content output of each dataset. A macro will solve this, i am able to get the list the dataset with:   proc sql; create table columns as select distinct(memname) as table_name from dictionary.columns where libname = 'WRK' ; quit;   but how to proceed to read all the file names and fetch them to generate a csv having their proc contents is what i am stuck with...   Thanks in advance!! ... View more

Generating a XML file in the datastep that acts as input for another program:   Filename outxml "C:\phase4.xml";   data _null_; file outxml; /*XML Output File */ set testxml NOBS=Lst; /* SAS File with input data */ by fileName;  if _n_=1 then do; put '<?xml version="1.0" encoding="utf-8"?>'; end; fileName= compress(fileName, ); put '<DataFile fileName="' fileName'" ';  put 'dataCon="'  dataCon'" dataStdVer="' dataStdV'" dVersion="'   dVer'" />'; if _n_=lst then do; put '</DataFile>'; end; run;     Current output: <?xml version="1.0" encoding="utf-8"?> <DataFile fileName="test1.sas7bdat " dataConformance="CDR1 " dataStandardVer="1 " domainVersion="1 " /> </DataFile>     All the variable are being resolved with a trailing space which is creating problem. While i checked the datafile, there are no trailing blanks, even the compress function is not helping. There seesm to be a problem with the quotation marks placement, if anyone can help me resolve this. Thanks! ... View more