So, I made 2 datasets: I want to get just list of variables with the same values except missing: For example, bothe datasets have the same Id-s (variable "name"), CrAtBat = ab CrBB =fkae CrHits =vrgsd CrHome =dfwef CrRbi =vewef CrRuns =fff Div =wsfde_d Division = vdfgew League =dfgwe_23 Position = fgerg Salary =vregf Team =fre YrMajor = rewa logSalary = fwef nAssts =cefwe nAtBat =efqwef nBB =qfqewfq nError =qfefe nHits =fewfe ... View more

Name from both datasets are IDs. Var_x is different than var_a, obviously. In one dataset, there are additional observations or missing —those cases should be ignored. ... View more

In one dataset, there are variables before “=“ and in another dataset, there are variables after “=“ sign: CrAtBat = ab CrBB =fkae CrHits =vrgsd CrHome =dfwef CrRbi =vewef CrRuns =fff Div =wsfde_d Division = vdfgew League =dfgwe_23 Position = fgerg Salary =vregf Team =fre YrMajor = rewa logSalary = fwef nAssts =cefwe nAtBat =efqwef nBB =qfqewfq nError =qfefe nHits =fewfe ... View more

Let me go back. I have 2 datasets. Dataset 1 has 20000 observations and 300 variables. Dataset 2 has 10000 observations and 500 variables. I want to compare those datasets and list out all variables with the same values (one may have more ID (names as suggests the dataset observations) and missing values. I should ignore those additional observations or missing, just compare existing ids variables in both datasets ... View more

There are no duplicates ... View more

This output I would like to : CrAtBat = ab CrBB =fkae CrHits =vrgsd CrHome =dfwef CrRbi =vewef CrRuns =fff Div =wsfde_d Division = vdfgew League =dfgwe_23 Position = fgerg Salary =vregf Team =fre YrMajor = rewa logSalary = fwef nAssts =cefwe nAtBat =efqwef nBB =qfqewfq nError =qfefe nHits =fewfe ... View more

Thank you. Numeric variables should compare with numeric and character variables should compare with character—-that is the goal =finding variables with the same values. I do not want any output data. I want just the list of variables with the same values. For example, if variable1’s values are equal with variable2’s values, then I want Variable1 and variable2, etc ... View more

Sorry, I updated the file again ... View more

Sorry, just attached a correct file. ... View more

Thanks. I just want to line up by this symbol “-“ ... View more

Don’t know. It generates html graph. How can I annotate? ... View more

Thanks. But does not line up by “-“—does not produce what I wanted ... View more

Thank you. data test; set sashelp.class; if age in (12,13) then gr=1; else if age =14 then gr=2; else gr=3; run; proc sort data=test; by gr; run; proc format; value gr 1="kids Reference" 2="teenagers 9 (4-24)" 3="old 78 (32-189)" ; proc template; define style mystyle; parent=styles.sasweb; class graphwalls / frameborder=on; class graphbackground / color=white; end; run; ods graphics on / reset=all; ods html style=mystyle path='.' file='newgraph.html'; ods graphics / reset=all width=6.5in height=4.5in border=off ; legend1 label=none; proc sgplot data=test DATTRMAP=attrmap1; scatter x=weight y=Height /group=gr ; keylegend / location=outside position=bottom NOBORDER down=4; label gr='Age, years OR (95% CI)'; format gr gr.; run; ... View more

Proc sgplot data... Format Cc Ccformat.; Run; ... View more