hi, I have a dataset like this; ID             A              B          C       D 1              21          45          90     76 1              25          32          78      21 2             34           74           34     89 2             43            88          12      94 2             54            33          77      90 I want to do transposing and the desired o/p will be like ID        _name_     value 1              A             21 1              B             45 1              C             90 1              D             76 1              A              25 1              B              32 1              C              78 1              D              21 2              A              34 2              B              74 2              C              34 2              D              89 ...............and so on... how can i do this? ... View more

I have a dataset in which the first variable'name' like this ,say Name FRUIT apple Orange Grapes Mango Cherry FLOWER Jasmine Lilly Lotus COLOUR blue Pink Yellow red How can i insert an empty row in proc report as i have splitted into different pages using pagebreak like: Name FRUIT apple Orange Grapes Mango Cherry ---------------- FLOWER Jasmine Lilly Lotus --------------------- COLOUR blue Pink Yellow red ... View more

I have a dataset like this Id var cat n value 1 var1 cat1 1 A 2 var2 cat2 2 B 3 var3 cat3 1 C 4 var4 cat1 1 A 5 var5 cat2 2 B 6 var6 cat3 2 C 7 var7 cat1 1 A 8 var8 cat2 1 B 9 var9 cat3 2 C The required o/ p looks like this                         A                         B                                C                  N=1    n=2            n=1     n=2                n=1      n=2 Cat1 Var1      xx (xx)  xx(xx)       xx (xx)  xx(xx)       xx (xx) xx(xx) Var4      xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Var7     xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Cat2 Var2     xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Var5     xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Var8      xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Cat3 Var3      xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Var6      xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Var9      xx (xx)  xx(xx)       xx (xx) xx(xx)       xx (xx) xx(xx) Where xx(xx) refers to counts of each var with percentages in braces. Someone please help me with a soln. Thanks ... View more

How can i read date variable having different lengths Like 1/01/1991 01/02/1992 02/03/ 1995 8/08/2000 I have tried anydtdte. Bt it only reads the one having single digit for day . If i use mmddyy10. then it will reads only the one having 2 digits for day. Someone please help. Thank you. ... View more

I have a dataset like this Id visits val date1 date2 101 1 2.4 02jan2019 05jan2019 101 2 4 05jan2019 05jan2019 101 3 5 10jan2019 05jan2019 102 1 6 05jan2019 15jan2019 102 2 7 12jan2019 15jan2019 102 3 8 15jan2019 15jan2019 103 1 2.3 17 jan 2019 20jan2019 103 2 6 18jan2019 20jan2019 103 3 8 19jan2019 20jan2019 I want to derive a flag variable , as per the conditions The flag should be populated ONLY for last non missing 'val' variable for each subjects Also date1 < date2 like Id visits val date1 date2 flag 101 1 2.4 02jan2019 05jan2019 Y 101 2 4 05jan2019 05jan2019 101 3 5 10jan2019 05jan2019 102 1 6 05jan2019 15jan2019 102 2 7 12jan2019 15jan2019 Y 102 3 8 15jan2019 15jan2019 103 1 2.3 17 jan 2019 20jan2019 103 2 6 18jan2019 20jan2019 103 3 8 19jan2019 20jan2019 Y ... View more

I have a dataset like Id name 1 negative 2 45 3 1E 4 positive 5 24 I want to derive a new variable 'Flag' in which the values having alphabets should be ' '(missing character value) and no change for others.like, 1 2 45 3 4 5 24 Someone pls help.. Thanks ... View more

how can i count the total within the subgroup? that is for the given data the variables are id ,month ,recruitment.    A      1  4  A      2  2                      A      3   3   A      4   6                       A     5   3   B      1   1  B      2   2   B       3  4  B      4   5   B    5   4  C   1   1  C   2   3  C   4   2  C  5   1  D   1   2   D   2  3  D   3  2  D  4  1  D  5 4 i want to calculate the recruitment of individual ids, desired output; id      total recruitment A      18 B       16 C       7 D      12   please help. ... View more