Good day all, i have the dataset of emp data. its having different formats for salary variable. comma and percent format. so i  apply proc format for that. PROC FORMAT; VALUE FMT   LOW-0,1-HIGH=[COMMA32.]   OTHER=[PERCENT8.1]   ; RUN; empno     salary aaa          1,52,133 bbb          2,50,111 aaa          25% bbb          50%. in proc report its showing as it is. but while exporting it into excel only percentages format is applying. the comma format is missing. after export into excel the output like this. empno      salary aaa     152133 bbb     250111 aaa     25% bbb     50% how to get the required output with applying comma and percentage format. your valid comments are helps me a lot. Thanks. ... View more

Good day all, i have two datasets for example sashelp.class1 sashelp.class2; now i want to export these two datasets into excel within single work sheet. sheet1 contains first sashelp.class1 data and under sashelp.class2 data. your valid comments are welcome. ... View more

Good morning all, while importing excel there is a problem. if the excel data contains some data and some title statement. I know how to import it into sas, But is there any possible chance to import title also while importing. the data is like this                ABC company ltd           Employee details on 11/03/2015      under the data is as follows in cell DATE EMP_ID ENAME SALARY so these kind of data how we import it into sas. Through proc print it is possible. But through data step is there any possible to import with title also. Thanks in advance. ... View more

Good day all. I am importing excel file. it includes information of employee and student. I know how to import this data into sas. But what my requirement is that along with  heading also there in dataset. Here the variable eno is numeric. and std_id is numeric.  I mention resultant output in sheet1. Is there like this output is possible in sas. Your valid comments are welcome. Thanks in advance. The data is like this. Employee Details on 10/03/2015 eno ename salary 1 aaa 1000 2 bbb 2000 3 ccc 3000 4 ddd 4000 5 eee 5000 6 aaa 6000 7 bbb 7000 8 ccc 8000 9 ddd 9000 10 eee 10000 Student Details on 10/03/2015 std_id std_name marks 101 aaa 50 102 bbb 60 103 ccc 95 104 ddd 82 105 eee 96 106 aaa 74 107 bbb 52 108 ccc 38 109 ddd 40 110 eee 64 the output is like this. Employee Details on 10/03/2015 eno ename salary 1 aaa 1000 2 bbb 2000 3 ccc 3000 4 ddd 4000 5 eee 5000 6 aaa 6000 7 bbb 7000 8 ccc 8000 9 ddd 9000 10 eee 10000 Student Details on 10/03/2015 101 aaa 50 102 bbb 60 103 ccc 95 104 ddd 82 105 eee 96 106 aaa 74 107 bbb 52 108 ccc 38 109 ddd 40 110 eee 64 ... View more

Hi all the data is below. Assume this is excel file sheet1 data. Employee Details on 10/03/2015 eno ename salary 1 aaa 1000 2 bbb 2000 3 ccc 3000 4 ddd 4000 5 eee 5000 6 aaa 6000 7 bbb 7000 8 ccc 8000 9 ddd 9000 10 eee 10000 next day 10 records are added next day 10 records are added Student Details on 10/03/2015 std_id std_name marks 101 aaa 50 102 bbb 60 103 ccc 95 104 ddd 82 105 eee 96 106 aaa 74 107 bbb 52 108 ccc 38 109 ddd 40 110 eee 64 next day 10 records are added next day 10 records are added Here two types of data is available. employee and student. we read this data into sas with two different datasets emp and std; the code of reading these is as follows. PROC IMPORT DATAFILE="C:\Users\SYSTEM1\Desktop\Book2.XLS" OUT=EMP DBMS=EXCEL REPLACE; SHEET='SHEET1'; RANGE='SHEET1$A2:C12' GETNAMES=YES; RUN; PROC IMPORT DATAFILE="C:\Users\SYSTEM1\Desktop\Book2.XLS" OUT=STD DBMS=EXCEL REPLACE; SHEET='SHEET1'; RANGE='SHEET1$A20:C30' GETNAMES=YES; RUN; So now by next day employee data 10 records added to existing one. and also student details are added. What my question if we know the range then simply mention in range option. But if we don't know the range then how the total data is added to the existing one. how to automate this. The variables are same but rows are added day by day. If i am running the code next day then automatically the new are added to existing one. i.e. we need total data of employee including new records. and same type of student. All your valid comments are welcome. Thanks in advance. ... View more

Hi all, if the dates are in the format mmddyy10. but i want the output like mon-year format. ex: jan-2000 feb-2000 mar-1989 in this format. how this is done in sas. Thanks in advance all ... View more