My input dataset (Table 1) has 2 columns and 4 rows. I need to calculate row 5 and row 6 as shows in (table 2). Please help me create Row5 and Row6.   Calculation: Row 5 - Average of row 2, 3, 4 Row 6 - (Row1 - Row5)/Row5   Table 1: (INPUT DATASET) WEEK Units Week 1 81,855 Week 2 80,009 Week 3 71,972 Week 4 68,035   Table 2: (OUTPUT DATASET) WEEK Units Week 1 81,855 Week 2 80,009 Week 3 71,972 Week 4 68,035 Average (Week 2 - Week 4) 73,339 Variance 12% ... View more

Hi, Please help me write code to do this task.   I have a list of bigram's that I want to check how many time they are occurring in mr_name field and output the counter.   For  example. first row in mr_name "cxhimgqabout" has "cx" and "gq" two bigrams. So, my counter variable should say 2.   list of bigram mr_name counter bq cxhimgqabout 2 bz lolfvchickbznicefx 3 cf howmefvtoldbqcv 3 cj toldyounothing 0 cv     cx     fq     fv     fx     fz     gq     ... View more

    Here is the sample code for file creation. When I use DSD option in the file statement, it is putting double quotes around field A in the output file whereas without DSD option it gives an extra space for missing fields. Any one has a solution?   fieldval|newfield|new| |1   "fieldval|newfield"|new||1    Its putting double quotes because your delimiter is a pipe and your Field A also has a pipe.   options missing=''; data one; a='fieldval|newfield'; b='new'; c=''; d='1'; run; filename outfile "/uhome/snoone/test.txt" ; data _null_; set one; file outfile DELIMITER='|' dropover dsd lrecl=1000; put a b c d; run;   ... View more

HI, I have a table like below and want it to be transposed like the "WANT" table below. Please suggest.        HAVE                           number RG LB PM AR VL JB 9001 x a b a x b 9002 x a b a x b 9003 x x x x y x 9004 y x x x a x               WANT                           number seq value         9001 RG x         9001 LB a         9001 PM b         9001 AR a         9001 VL x         9001 JB b         9002 RG x         9002 LB a         9002 PM b         9002 AR a         9002 VL x         9002 JB b         9003 RG x         9003 LB x         9003 PM x         9003 AR x         9003 VL y         9003 JB x         9004 RG y         9004 LB x         9004 PM x         9004 AR x         9004 VL a         9004 JB x         ... View more

  Hi, I have data like the below. I need to check if the value field is increasing across months by product. I created the diff field so that if that value is positive in all observations in a group then its increasing.     Please suggest how I can program to output only those products that are increasing in value over the months.    Product month value diff x 2016/04 104.94 0 x 2016/05 91.12 -14 x 2016/06 98 7 x 2016/07 117 19 x 2016/08 235.67 119 x 2016/09 118.89 -117 x 2016/10 136.67 18 y 2016/04 1.19 0 y 2016/05 1 0 y 2016/06 1.43 0 y 2016/07 0.89 -1 y 2016/08 0.78 0 y 2016/09 1.3 1 y 2016/10 3.5 2 z 2016/06 1 0 z 2016/10 2 1 ... View more

  I have below table. I just need a simple bar graph with date on X-Axis and Volume on Y-Axis. So, I will get 12 bars.   date Volume 6/30/2015 14,400 7/31/2015 13,996 8/31/2015 14,935 9/30/2015 15,502 10/30/2015 15,944 11/30/2015 17,120 12/31/2015 16,698 1/29/2016 20,028 2/29/2016 19,685 3/31/2016 21,882 4/29/2016 22,498 5/31/2016 23,100 ... View more