I think you didn't understand my question, first prepare an Excel file with the data given and import it into SAS then try to find out the solution. Actually if I'm importing such file it's automatically taking some different variable name like F3, F4... Or give me your mail id will send data file, so it'll be easy for you to find solution.
... View more
Hi, I need help to read an Excel file that have Emp_id, Joining_date and columns 01/04/2016, 01/05/2016, 01/06/2016.... till 01/07/2018. Please find data given below. Emp_id Joining_date 01/04/2016 01/05/2016 01/06/2016.. 101 05/04/2016 .15 .40 .28 102 21/04/2016 .56 .34 .67 103 13/05/2016 .39 .61 .84 ..... Now import that Excel file into SAS and want data for next 3 months from date of joining. So like first observation date of joining is April 2016 then we need the data for this employee from April 2016 to June 2016. Similar for all employees. Desired output : Emp_id Joining_date M1 M2 M3 101 05/04/2016 .15 .40 .28 102 21/04/2016 .56 .34 .67 103 13/05/2016 .84 ....... Thanks Nikhil Jain
... View more
Hi, I've a csv data file that have a salary column. Salary is stored from globally so having dollar, euro, pond... etc symbol. Need help to read such type data into sas. Example : Salary $30,000 €25,000 €40,000 ¥80,000 ... Please help me to read this data in sas. Thanks Nikhil Jain
... View more