Hi, I am trying to import data in sas like: A   B    C    D    E x    y    z     h     i s1  s2   s3   s4   s5 where A B C D and E are column names. I have 240 columns in my dataset and the code I am using is: data INFO;           infile Attdata notab dlm='09'x dsd missover LRECL = 100000000;           length A B...........E $200; input A B.....E; run; Whenever I import data some of the rows of column B, C etc gets stacked below rows of A like: A   B    C    D    E x                 h     i s1  s2   s3      s5 y    s4 z Is there a way to fix this? Do i need to do something with lrecl one? Thanks for your time. ... View more

Hi, I want to export my sas dataset to specific cells in excel. I am trying to use macro but everytime I run it, my sas stops responding. Can anyone tell me the macro statement for exporting? Thanks a ton! ... View more

I have a data in sas like: Category Response A 50% - 70% A 0% A 0% A More than 70% B More than 70% B 1% - 49% B 0% B 0% B 50% -70% I want my result data to look like: Response A B 0% 2 (50%) 2 (40%) 1% -49% 0(0%) 1 (20%) 50%- 70% 1 (25%) 1 (20%) More than 70% 1 (25%) 1 (20%) Explanation of result data: There are two categories A (=4)and B (=5) and there are four different types of response 0%, 1% -49%, 50% -70% and more than 70%. In category A, only two out of four responded 0%, thus result is 2 (50%). Similarly in A, on;y one out of four responded 50-70%, thus result is 1 (25%). Same as B for each response. I would be grateful for your time reagarding the same. ... View more

I have a data in sas like: Category              Response A                         50% - 70% A                          0% A                          0% A                          More than 70% B                          More than 70% B                          1% - 49% B                            0% B                             0% B                           50% -70% I want my result data to look like: Response                  A                B 0%                          2 (50%)        2 (40%) 1% -49%                   0(0%)         1 (20%) 50%- 70%                 1 (25%)       1 (20%) More than 70%         1 (25%)         1 (20%) Explanation of result data: There are two categories A (=4)and B (=5) and there are four different types of response 0%, 1% -49%, 50% -70% and more than 70%. In category A, only two out of four responded 0%, thus result is 2 (50%). Similarly in A, on;y one out of four responded 50-70%, thus result is 1 (25%). Same as B for each response. I would be grateful for your time reagarding the same. ... View more

Hi, I am performing a macro with statements : %macro stuff (); %do i=2 %to 6  ....... followed by series of statements and then macro end statement. My question is when I write "%do i=2 %to 6", this mean that macro would perform on colum 2 to column 6 in my data set. But if I want to skip column 4 and start macro function again from 5, then which statement should I write for "%do i=2 %to 6". I have tried several different statements like %do i=2 %to 3 and %do i=5 %to 6 but nothing is working. Is there a way to do this in same statement or should I have to write it in altogether different syntax? Thanks a lot for your suggestions. ... View more

Hi I have a data in sas like: Role                      A                  B                     C                                 D                 E IT                       Bone            Diabetes       haemoglobin                  -                 Fibrin Doctor                Bone               -                Haemoglobin               Blood             -      Doctor                   -               Diabetes        haemoglobin               Blood            Fibrin  Clinic                  Bone             -                          -                        Blood            Fibrin Clinic                  Bone               -                Haemoglobin               Blood                     How can I rearrange data to get like this:                               IT                           Doctor                          Clinic Bone                      1 (100%)                 1 (50%)                      2 (100%) Diabetes                 1 (100%)                 1 (50%)                      0 (0%) Haemoglobin           1 (100%)                 2 (100%)                    1 (50%) Blood                      0 (0%)                     2 (100%)                    2 (100%)  Firbin                      1 (100%)                 1 (50%)                      1 (50%) Let me explain my result data: take each role separate: for eg, there is only one IT. For A, the IT answered Bone, thus the response rate among IT woule be 100%. Since IT didnt answer D, therefore the response rate is 0%. Similarly, take doctor as an example. There are two doctors and only one answered A, so the response rate would be 50%. Both doctors answered C, therefore the response would be 100%. I know its a bit complex but your suggestions would really help me. Thanks a ton!! ... View more

I have a data in sas like: Role                          Answer A                               100% B                                 20% When I import data in sas (using import statements) the percentages gets import as:: Role                          Answer A                               1 B                                2 Is there a way to import percentage as percentage? Thanks for your time. ... View more