I am having excel file i wnat to Read it a split and create new datasets when ever i reach all the columns are balnk In this should create 5 datasets like ease,west,north,south,all zones and it should go to new dataaset if it get all thecolumns as blank.All zones should have onely 1 Row it shd not read the data after balnk as it shd not read Notes: I am having differnt excel sheets with differnet zone names they are not fixed and range is also not fixed  and in some sheets i may have 8 zones and in some i will have 2 zones and i shld give the zones as dataset names I am attaching the Excel file with Data, and Text file for your Ref Output 1.Datset East zone city no east  mum anderi 123 zeharbad navi 345 kalyan new 456 2.Datset west zone city no west  hyd nlg 456 secbad sec 1256 3.Datset North zone city no North  ahmedabad ahm 23 nagur nng 456 4.Datset South zone city no south  sahanari snr 345 gur gjk 256 5.Datset all_zones zone city no  All zones all 23569 ... View more

RenaeQuery 1: i am Having Datasets in work some are having 0 obs how can i drop all the tables Ex: Dset  obs Name1  10 obs Name2  0 obs Name3  40 obs Name4  0 obs ID1    0 obs id2    10 obs i want to drop the obs with 0 records as i dont know how many datasets will be there and with Differnt names Query 2:     I am having SAS DAtasets ex: x,y,z in this the first obs will have the dataset name i want to rename the dataset name x to the name existing in first obs. In the above ex i gave x,y,z, but i dont know the exact names how can i do it. Dataset x; obs 1 Main Dataset ... View more

I am having Mob no if length =10 and first digit ne 0 then i should not consider that at that point the data should be '' if length =11 and first digit=0 then i should remove the 0 and take the rest in to variable if length =12 and first two digit=91 then i should remove the 91 and take the rest in to variable data t1; infile cards missover truncover; input name $ Mob_No $ 3-20; org=mob_no; cards; a 91+1234506789 a 98-12345678 a 01234506789 a 1234506789 a M-1234506789 a b-1234506789 a 911234506789 a 911234506789 a 01234506789 a 8989 a 98123456789 a 0123456789 a 1234056789 ; run; data test; set t1; Mob_No=upcase(Mob_No); Mob_No=trim(compress(Mob_No,' +-_()ABCDEFGHIJKLMNOPQRSTUVWXYZ')); mob_len=length(Mob_No); if mob_len in(10,11,12) then Mob_No=Mob_No; else Mob_No=''; if mob_len=10 and substr(Mob_No,1,1) ne '0' then Mob_No=Mob_No; else if  mob_len=11 and substr(Mob_No,1,1)='0' and substr(Mob_No,2,1) ne '0'   then Mob_No=substr(Mob_No,2,12); else  mob_no=mob_no; if mob_len=12 and substr(Mob_No,1,2)='91' and substr(Mob_No,3,1) ne'0' then Mob_No=substr(Mob_No,3,12); else mob_no=mob_no; /*/*Mob_No1=Mob_No;*/*/ /*/*Mob_len2=length(Mob_No1);*/*/ /*/*if mob_len2=11 and substr(Mob_No1,1,1) ='0' then Mob_No1=substr(Mob_No1,2,12);*/*/ /*/*else if mob_len2=12 and substr(Mob_No1,1,2)='91' then Mob_No1=substr(Mob_No1,3,12);*/*/ /*/*else Mob_No1=Mob_No1;*/*/ run; proc print; run; output should be a 1234506789 a 9812345678 a 1234506789 a 1234506789 a 1234506789 a 1234506789 a 1234506789 a 1234506789 a 1234506789 a a a a 1234056789 ... View more

Actually i am having a Query for probability asked in a Interview Q:1   If i have tossed a coin for 3 times what is the chance of getting Head 2 Times they told 2 times but how.Can any one explain. Q:2 I am having 9 balls out of which i am having one ball with less weight each ball weight is 1 kg and the defect ball has 1 gm les in weight.   I am having a balance at once 2 balls can we weighed in two pans. What is the probaility to find the defect ball The answer is 3 But how. ... View more

What is the difference between select when and if ,else if in sas datastep can any one help ... View more