Hi All, I would appreciate if anyone can tell me the code to draw a histogram from the following qualitative data. Thanks, Date Outcome 01-Mar-2014 Loss 27-Feb-2015 Profit 27-Feb-2014 Loss 24-Feb-2014 Profit 01-Mar-2015 Loss 26-Feb-2015 Loss 01-Mar-2015 Loss 01-Mar-2015 Loss 01-Mar-2015 Loss 01-Mar-2015 Profit 01-Mar-2014 Profit 01-Mar-2014 Profit 01-Mar-2014 Profit 25-Feb-2014 Profit OUTPUT: ... View more

Hi All, Can anyone tell me how do I remove everything including the first period (.) and space from the onservation?    ID        Description 101      1. My Name is John 202      10. I am a boy. I go to school 302      502. I work. I read.         My final output will be: ID        Description                                 Description2 101      1. My Name is John                    My Name is John 202      10. I am a boy. I go to school.      I am a boy. I go to school. 302      502. I work. I read.                      I work. I read.      I wrote the following code, but it does not help if period (.) and space occurs second time. data out; set have; Description2 = scan(Description,2,'.'); run; ... View more

Hi All, Can anyone tell me if I can use 'sort', 'rename' and 'where' command during the data import stage (in another word during data step)? I want to: sort them by Emp_ID; and rename as Name=Student_name; and import observations where Student_name<>''; Here is my initial code that I wrote without any of the above condition. proc import datafile="E:\data_nonsort.xlsx" dbms=xlsx replace out=data_sort (keep = Emp_ID Name); sheet='test'; run; Thanks and I much appreciate your help, ... View more

Hi All, can anyone tell me the code how to round a data to it's next integer value? I know how to round down (9.81 to 9), but I don't know how to round up (9.01 to 10)  here is the code I know for rounding except rounding to the next integer. data round; input no; datalines; 9.9 9.4 9.5 9.047 9.55 9.006 9.004 9.999 9.6 9.1 ; run; data newround; set round; value1 = round(no);      *rounding to the nearest integer; value2 = int(no);     *Keep the integer only; value3 = round(no,0.01); *rounding to the nearest second decimal; run; Thanks, ... View more