Can i extract datasets starting with "ab_" from a folder and append them using a datastep or proc sql without naming each and every dataset name ... View more

Hi, I want to insert start and end dates if there is any gap between end date from previous row to start date in the next row. data WORK.IND; infile datalines dsd truncover; input START:DATE9. END:DATE9. UID:$200. ED:32.; datalines4; 30MAR2016,31MAR2016,S110,5 01APR2016,02APR2016,S110,10 03APR2016,04APR2016,S110,15 05APR2016,17APR2016,S110,20 18APR2016,18APR2016,S110,0 25APR2016,25APR2016,S110,0 18MAY2016,18MAY2016,S110,0 23MAY2016,24MAY2016,S110,0 ;;;;   need then dates to be split like something below   30-mar-16 31-mar-16 5 S110 01-apr-16 02-apr-16 10 S110 03-apr-16 04-apr-16 15 S110 05-apr-16 17-apr-16 20 S110 18-apr-16 18-apr-16 0 S110 19-apr-16 24-apr-16 20 S110 25-apr-16 25-apr-16 0 S110 26-apr-16 17-apr-16 20 S110 18-may-2016 18-may-2016 0 S110 19-may-2016 22-may-2016 20 S110 23MAY2016 24MAY2016 0 S110 ... View more

I have 2 datasets one main dataset and i need to check with the other dataset and if the id is same then flag as Y. Below is the example: any help on doing in one step data WORK.main; infile datalines dsd truncover; input ID:BEST12.; datalines4; 111 134 122 221 232 198 908 762 212 2122 3435 2123 ;;;;   second dataset data WORK.BOOK11; infile datalines dsd truncover; input LL_1:BEST12. MM_2:BEST12.; datalines4; 111,908 134,762 122,212 221, 232, 198, ;;;;   I need the final dataset like below: ID MM_Flag LL_Flag 111 N Y 134 N Y 122 N Y 221 N Y 232 N Y 198 N Y 908 Y N 762 Y N 212 Y N 2122 N N 3435 N N 2123 N N   any help in how to solve this please ... View more

I have a dataset in the below format data M.TEST; infile datalines dsd truncover; input id:BEST12. score:BEST12. seq:BEST12. vis:BEST12.; datalines4; 1,22,1,1 1,23,2,1 2,12,1,1 2,22,2,1 3,11,1,1 3,23,2,1 3,19,3,2 3,13,4,2 ;;;;   id score seq vis 1 22 1 1 1 23 2 1 2 12 1 1 2 22 2 1 3 11 1 1 3 23 2 1 3 19 3 2 3 13 4 2     I want to create a new record for every id and subtract scores of  seq 2 to seq 1 and get the scores for the third one and seq regenerating based on new order.Can anyone help me on how to do it.   id score seq vis 1 22 1 1 1 23 2 1 1 1 3 1 2 12 1 1 2 22 2 1 2 10 3 1 3 11 1 1 3 23 2 1 3 12 3 1 3 19 4 2 3 13 5 2 3 -6 6 2 ... View more

I have a char date which is something like "17 Nov 2016" and i want to make it as "2016-11-17".   Tried  A=INPUT(E,is8601da.);    But it didnt work as the input is char variable.   Any help? ... View more

I have a date which is "2006-07---" and i want to remove "---" as those are missing dates and make it to "2006-07".   any suggestion on how to do it. basically make these --- to iso date format ... View more

proc sql noprint; select distinct strip(VARIABLE) into :commonrs separated by ', ' , distinct strip(VARIABLE) into :commonvrg separated by ' ' from COMMON; quit;   I am using the above code, just to make sure before sending test data as i get syntax error, can anyone help me figure out where the issue was. distinct strip(VARIABLE) into :commonvarsmrg separated by ' ' from COMMON; -------- 79 76 ERROR 79-322: Expecting a :. ERROR 76-322: Syntax error, statement will be ignored. ... View more