ID  Regionnumber   satisfy code zipregion 1        2 2        2                     Y        1       6 3        1                      N        2       6 4        1                                           5        3                      Y        1       6 6        3                      Y                 6 7        3                        8        3                             9        4                      Y         2       6 10      0                      N                  6 11       5                      Y          1      6 12       6                      Y          2      6 13       7                      N          1      6 14       0                                   1      6         Q) If Regionnumber is same for two ids, then need to copy populated ID row column values to not populated ID column values?    If there is only unique Regionnumber or Regionnumber value is 0 ignore those rows. No need to change any column values.       Thanks in advance.         ... View more

10 or less files comes to directory /abc/landing with timestamp everyday. filenames are like a_yyyymmddhhmmss.dat, b_yyyymmddhhmmss.dat etc.,  sometimes there is a possibility of duplication of files with same content with different different timestamp for sameday. need to select latest time stamped file.   1)if 10 distinct files are there in /abc/landing/ , read all files to convert into SAS data sets.   2)if there are less than 10 files, create a subdirectory withtimestamp from filenames under /abc/landing, /abc/landing/withtimestamp keep those less numbered files into this /abc/landing/withtimestamp and wait and check the /abc/landing untill you get a remaining files with same timestamp.   3)should look /abc/landing everyday to process 10 distinct files available with same dated ones. if there are more than 10 files, should look for a) are there any duplicated files? if so, select 10 distinct files with latest timestamp b) are there any old dated files there. if there are any old dated files send them to respective dated folder and look in that respective folder enough 10 files are there to read those 10 files and delete that respective date directory.     Any documentation or papers links avilable appreciated. Thanks. ... View more

region dups r1 0 r2 1 r3 0 r4 0 region and dups are two columns in a given data set. If all the values in dups are 0's no need to send an email. if one of them is not zero like for r2, need to send an email with the above dataset attachment. ... View more

data x(index =(id)); set y; where (code1 in ('1','2','3','4','5','6','7','8')) and code2 in ('12'); keep c1id c2  ..... c2000;/* ... is hard coded columns c3 to c1999*/ run; proc sql; create table w1 as select  x.c1id,c2,.....,c2000,t1.a1,.....t1.a500 from x left join t1 on x.id=t1.id; index on x.id ; run; like above created tables w1 to w400 by changing left join tables t1 to t400 now merged all the tables w1 through w400 all by id. data final; merge w1 to w400; by id; run; Q) tested the code fine and working for one id. But when running this code for 2 million id's it is taking longer time. any suggestions to work this code faster? ... View more

data two; set one(keep=year); call symput('newyear',year); run; filename dirlist pipe 'ls "/data/set1/&year." /s'; here &year. is not resolving. any papers on this pipe? ... View more

varables                   a         e           f          h         z        t    x1 x2 x3 x4 x5 w in a given data set 'have' here a,e,f,h,z,t,x1,x2,x3,x4,x5,w are variables. Here x1 x2 x3 x4 x5 are numeric. I can change numeric to character data want; set have; z1=put(x1,5.); z2=put(x2,5.); z3=put(x3,5.); z4=put(x4,5.); z5=put(x5,5.); drop x1 x2 x3 x4 x5 ; rename z1=x1; rename z2=x2; rename z3=x3; rename z4=x4; rename z5=x5; run; Problem? want data set  variables are in this order a         e           f          h         z        t   w  x1  x2  x3  x4   x5 Need? but do need in original order    a         e           f          h         z        t    x1  x2  x3  x4  x5  w please dont say use retain before set statement. There are 500+ variables in the original data set. is there any way? with out writing each variable name in retain statement? thanks. ... View more