Recently in the SAS Community Library: SAS' @BethEbersole reveals 4 steps to stop money laundering, solve law-enforcement cases, find missing children and more with SAS Visual Investigator.
It would be nice to be able to copy text from an individual cell in the list table. This is possible in a crosstab but it would be nice to mimic the excel function of copying from a regular table/cell for the list table.
... 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
There have been quite a few spam questions over the past few months where it took sometimes days until they got removed.
Proposal
Implement an automated process that moves questions from the visible list to some hidden queue for investigation if marked by multiple users an inappropriate content.
To avoid that this process can get misused: Only include users that marked the question if they are not New Users but already on a certain level (to exclude fake users).
And just thinking:
Eventually request from New Users for their first few post some additional identification step when posting a question to make it a bit harder to automate posting such questions.
... View more
I am having an issue where I am trying to create a volatile table using SAS, then being able to connect and review this table. Ultimately I am trying to join a Teradata Volatile table with Hadoop data, but I figure this is the first step. You can see a sample layout of my code below, and the only error I get when running is that my_VTD_Test doesn't exist, which is true at the start of the program. Everything else completes just fine, but when I try to look at the table data, I get an error that it doesn't exist again. So it looks like its running but not gathering any data. I appreciate any feedback with this.
libname tdwork teradata AUTHDOMAIN=MYAUTH
mode=teradata server="myserver"
connection=global dbmstemp=yes;
PROC SQL NOERRORSTOP;
CONNECT TO TERADATA (AUTHDOMAIN=TDAUTH server="myserver" connection=global mode=teradata);
execute (drop table my_VTD_Test) BY Teradata;
execute( create volatile table my_VTD_Test as
(select Name, Place, Service
from MYTDSCHEMA.Table_NAME
)
with data primary index(Name) On Commit Preserve Rows ) by teradata;
DISCONNECT FROM teradata;
quit;
... View more
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