How do I get more detail about the lines in BOLD? When I use option LISTOBS it will list the observations that it finds different. However when I view them I don't see any differences. How do I find out which vars are different when there are 95 vars? (Method=RELATIVE(0.0000222), Criterion=1.0E-09) Data Set Summary Dataset Created Modified NVar NObs ORDATA.ORACLETEMP 03MAY24:07:20:37 03MAY24:07:20:37 95 26553 SNOWDATA.SNOWTEMP 03MAY24:07:21:21 03MAY24:07:21:21 95 26553 Variables Summary Number of Variables in Common: 95. Number of ID Variables: 10. Number of Observations in Common: 24450. Number of Observations in ORDATA.ORACLETEMP but not in SNOWDATA.SNOWTEMP: 2103. Number of Observations in SNOWDATA.SNOWTEMP but not in ORDATA.ORACLETEMP: 2103. Total Number of Observations Read from ORDATA.ORACLETEMP: 26553. Total Number of Observations Read from SNOWDATA.SNOWTEMP: 26553. Number of Observations with Some Compared Variables Unequal: 0. Number of Observations with All Compared Variables Equal: 24450. Values Comparison Summary Number of Variables Compared with All Observations Equal: 85. Number of Variables Compared with Some Observations Unequal: 0. Total Number of Values which Compare Unequal: 0. Total Number of Values not EXACTLY Equal: 3628. Maximum Difference Criterion Value: 2.2094E-16. Here is my code: title "ordata.&ordsn versus &snowdsn"; proc compare base=ordata.&ordsn compare=snowdata.&snowdsn Criterion=0.000000001 fuzz=.001 out=result listobs outbase outcomp outdif outnoequal maxprint=50; id member medicaid_no claim_number line_number PAY_DT F_DOS L_DOS DOS AMT_REQ QTY ; attrib _all_ label=''; format _all_; informat _all_; run;
... View more
I tried ("cou" is 1,2,3,4,5.....; "var" is continuous variable with decimal points):
proc sql;
create table mt as
select cou,
pctl(75, var) as var_p75
from check_1
group by cou;
quit;
But it returns me with multiple rows per cou.
... View more
Hello! I have a question. Soon I will work with some data that are located on a shared fold in the google drive. This dataset is a STATA dataset. How can I import a STATA dataset that is located in google drive? Thank you very much for your help!
... View more
Does anyone know if there exists any function in SAS that resembles the
"lincom" and "nlcom" of STATA?. These functions computes point
estimates, standard errors, significance levels, confidence intervals,
etc. for linear and non linear combinations of previous estimated
parameters. Down here you've got links to descriptions of the functions of STATA
nlcom:
http://www.stata.com/help.cgi?nlcom
Lincom:
http://www.stata.com/help.cgi?lincom
... View more