About Nikhiljain22740

Nikhiljain22740 · ‎06-28-2023

Thanks would like to know if we import back the same file in SAS will it be same as dataset we exported into excel.

Nikhiljain22740 · ‎07-21-2018

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.

Nikhiljain22740 · ‎07-21-2018

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

Nikhiljain22740 · ‎07-15-2018

Hi, Is there any way we can count number of errors or Warnings or Notes appears in log. Thanks, Nikhil Jain

Nikhiljain22740 · ‎07-15-2018

Thanks Patrick, It'll work but is there any generic solution like any format that we can apply on it.

Nikhiljain22740 · ‎07-15-2018

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

Online Status	Offline
Date Last Visited	‎07-04-2023 04:23 AM

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: Read Excel file with dates are as veriable name

Read Excel file with dates are as veriable name

Counts Errors, Warning and Notes appears in log

Re: How to read a column having different currency formatted data.

How to read a column having different currency formatted data.

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: Sum up - by category wise in a column

Re: Counts Errors, Warning and Notes appears in log

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: Read Excel file with dates are as veriable name

Read Excel file with dates are as veriable name

Counts Errors, Warning and Notes appears in log

Re: How to read a column having different currency formatted data.

How to read a column having different currency formatted data.

SAS Inner Circle Panel