Hi all,   I want to ask a complicated (for me) question about SAS programming. I think I can explain better by using simple example. So, I have the following dataset:   Group          Category  A                  1 A                  1 A                  2 A                  1 A                  2 A                  3 B                  1 B                  2 B                  2 B                  1 B                  3 B                  2   I want to count the each category for each group. I can do it by using PROC FREQ. But it is not better way for my dataset. It will be time consuming for me as my dataset is too large and I have a huge number of groups. So, if I use PROC FREQ, firstly I need to create new datasets for each group and then use PROC FREQ for each group. In sum, I need to create the following dataset:                                                                                 CATEGORIES  Group     1   (first category)                                                                 2                       3  A             3 (the number of first category in A group is 3)                   2                       1 B             2 (the number of first category in B group is 2)                   3                       1   I do not write explainations for second and third categories as it is the same with the first category.I think I can explain it. Thanks for your helps. ... View more

Hi,   I want to ask a question about cumulative sum. I think I can explain better by using the simple sample. So, I have the following dataset:   Group       Time                Value A               14:25                5  A               14:25                10 A               14:26                 8 B               14:25                 4 B               14:25                 7 C               14:25                12 C               14:25                 3 C               14:26                 6 C               14:26                 9   I want to get the following datasets:   Time         A                  B                    C 14:25       15 (5+10)     11 (4+7)          15(12+3) 14:26        8                  0                     15(6+9)   Thanks in advance for your helps. ... View more

Hi all, I want to ask a quick question. I think I can explain better by using simple sample. So, I have the following data:   Time          Value 13:45          0.2 13:45          0.4 13:45          0.3 13:46          0.1 13:46          0.2 13:46          0.3 13:46          0.5 13:46          0.4   I want to add one more column. The value in this column should be the standard deviation for each minute. So, I want to get the following data:   Time          Value        St.D 13:45          0.2           0.1  (it is the standard deviation of 0.2,0.4 and 0.3 - so st.dev for 13:45) 13:45          0.4           0.1 13:45          0.3           0.1 13:46          0.1           0.1528  (it is the standard deviation of 0.1,0.2,0.3,0.5 and 0.6 - so st.dev for 13:46) 13:46          0.2           0.1528  13:46          0.3           0.1528  13:46          0.5           0.1528  13:46          0.6           0.1528    Many thanks in advance for your helps.     ... View more

Hi all, I need to use PROC.SQL statements for my analysis. The problem is, SAS uses C disk in order to create temporary files when I use SQL statements. My datasets are very large and I do not have enough space for that. Could you please explain me how to allocate this temporary file in other place rather than C disk? ... View more

Hi all,   I have a question. I want to ask my question as an example. I have the following datasets:           AAA              Value           1                    25           2                     .           3                     .           4                    22           5                     .   As you can see, there are some missing observations in column VALUE. I want to equalize this missing value to previous observations. So, the result should be:           AAA              Value           1                    25           2                    25 ( because the previous number is 25)           3                    25 ( because the previous number is 25)           4                    22           5                    22 ( because the previous number is 22)   Many thanks in advance.    ... View more