Hi all, We have 10tb+ of 10k+ sas7bdat files in a complex folder structure. What would be the fastest and most efficient way to check all of them for file damage (not repair), say due to download/transfer problems, corrupted sectors and what not?   Thank you,   A ... View more

Hi all,   It's a strange request but surprisingly interferes a lot of with the workflow and I was wondering if you guys had any insigths. I have SAS EG 8.3 Update 3 (8.3.3.181) (64-bit). When I select a piece of code using my mouse and pull the mouse to the bottom of the screen trying to extend the selection, the scrolling is very slow, non-responsive adn often i have to wiggle my mouse a bit to continue selecting the code. It wasn't like that in the previous versions of EG, it was clunky but not as bad. Any ideas on how i can increase the speed of scrolling when extending the selection using a mouse? The system is win10 64 on 8c16t system with 128gb of RAM.   Thank you! ... View more

Dear all,   Win 7x64 machine, 4.2ghz i7, 24 gb of 2133 ram, newest SAS and EG and the EG is the only program where i have copy paste freezes of about 2 seconds every time I ctrl-c. EG just freezes if i ctr-c anything from one letter to a node in the process flow for about 2-3 seconds. It doesn't matter if the project is completely empty/new/big. I used to have that problem in 2010, it disappeared after EG updates and returned this year.   Driving me nuts!   Any advice?   Thank you ... View more

Hi, Thsi is a follow up to my previous question about non-matcing observations which had great responses! I'm trying to build on PROC SQL way to find nonmatching observations between 2 datasets and add columns with aggregate statistics from the original datasets or even some other datasets. This will help to understand better the mechanics of PROC SQL.   data dataset1; input id $ group $ gender $ age; cards; 111 A Male 11 111 B Male 11 222 D Male 12 333 E Female 13 666 G Female 14 999 A Male 15 999 B Male 15 999 C Male 15 ; run; data dataset2; input id $ group $ gender $ age; cards; 111 A Male 11 999 C Male 15 ; run; %let dsn_in1=work.dataset1; %LET dsn_in2=work.dataset2; %LET dsn_an=work._t_nonm3; %LET group_var=group; %LET var1in1=group; %LET var1in2=group; %LET var2in1=gender; %LET var2in2=gender; proc sql; ************ 22 seconds **********; create table &dsn_an. as select *, count(distinct(&group_var.)) as group_cnt from (select a.*, count(a.&group_var.) as obs_per_group_cnt from &dsn_in1. as a left join &dsn_in2. as b on a.&var1in1.=b.&var1in2. and a.&var2in1.=b.&var2in2. where a.&var1in1. ne b.&var1in2. and a.&var2in1. ne b.&var2in2. group by a.&group_var.); quit; So the questions is how can I add to this &dsn_an. some group by stats from the original 2 datasets or even just some counts? Like count(distinct(a.&group_var.)) as ds1_group_cnt, count(distinct(b.&group_var.)) as ds2_group_cnt? Can I have  count(a.&group_var.) as obs_per_group_cnt but for for all groups/observations in dataset2 ( b)? I have tried different ways but the best i could get is the correct count for dataset 1 and 0 for dataset even though there are clearly distinct groups in dataset 2. I aim to do this in one proc sql to improve io perf.   If there are good resources on how to manage multiple subqueries with aggregate statistics with say 2+ group by's for different variables from different datasets, that would be great!   Thank you!   Apologies for the rushed question.   ... View more