sas - strange behavior by sas9.3 indexed dataset -


i writing following query in sas 9.3:

create table xyz select count(distinct x)  sasdata.dsn (keep=x);

the sasdata.dsn indexed on variables x , y composite index.

what's strange see query while execution creating temp files of indexes in sastmp (as seen) 

-rw-rw-r-- 1 krousetlp unix_kroger_dm 21798912 jun 19 03:18 sastmp-000000008.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21471232 jun 19 03:18 sastmp-000000009.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21667840 jun 19 03:19 sastmp-000000010.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21864448 jun 19 03:20 sastmp-000000011.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21749760 jun 19 03:21 sastmp-000000012.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21823488 jun 19 03:22 sastmp-000000013.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21651456 jun 19 03:23 sastmp-000000014.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21798912 jun 19 03:25 sastmp-000000015.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21651456 jun 19 03:27 sastmp-000000016.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21569536 jun 19 03:29 sastmp-000000017.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21635072 jun 19 03:31 sastmp-000000018.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21774336 jun 19 03:33 sastmp-000000019.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21757952 jun 19 03:36 sastmp-000000020.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21897216 jun 19 03:38 sastmp-000000021.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21790720 jun 19 03:41 sastmp-000000022.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21774336 jun 19 03:44 sastmp-000000023.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21757952 jun 19 03:48 sastmp-000000024.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21635072 jun 19 03:51 sastmp-000000025.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21618688 jun 19 03:55 sastmp-000000026.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21774336 jun 19 03:58 sastmp-000000027.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21798912 jun 19 04:02 sastmp-000000028.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21839872 jun 19 04:06 sastmp-000000029.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21848064 jun 19 04:11 sastmp-000000030.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21766144 jun 19 04:15 sastmp-000000031.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21757952 jun 19 04:20 sastmp-000000032.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21774336 jun 19 04:25 sastmp-000000033.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21618688 jun 19 04:30 sastmp-000000034.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21774336 jun 19 04:35 sastmp-000000035.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21700608 jun 19 04:40 sastmp-000000036.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21569536 jun 19 04:46 sastmp-000000037.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21676032 jun 19 04:51 sastmp-000000038.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 22077440 jun 19 04:57 sastmp-000000039.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21839872 jun 19 05:03 sastmp-000000040.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21725184 jun 19 05:09 sastmp-000000041.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21577728 jun 19 05:16 sastmp-000000042.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21749760 jun 19 05:22 sastmp-000000043.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21643264 jun 19 05:29 sastmp-000000044.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21258240 jun 19 05:36 sastmp-000000045.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21594112 jun 19 05:43 sastmp-000000046.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 22175744 jun 19 05:50 sastmp-000000047.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21708800 jun 19 05:58 sastmp-000000048.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21880832 jun 19 06:05 sastmp-000000049.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 21700608 jun 19 06:13 sastmp-000000050.sas7bndx.lck -rw-rw-r-- 1 krousetlp unix_kroger_dm 12836864 jun 19 06:17 sastmp-000000051.sas7bndx.lck

is there reason this. performance quite bad have suggestions on how can distinct count of variable involved in composite index.


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more