About danimian

danimian · ‎06-20-2014

Yes Its working fine now. Thanks a lot. Best Regards

danimian · ‎06-18-2014

I need text '15.04.2014 10:15' from old in new as date in format DD.MM.YYY HH:MM

danimian · ‎06-18-2014

Hello, i have a field date_in with data type character with value for example '15.04.2014 10:15' (DD.MM.YYY HH:MM) Target field date_out has numeric type. Is there any SAS date format which match with this format? or how i can deliver the date in above format? I just tried some formats with input(date_in, format) but cannot find the wanted format result. Thanks for your support in advance

danimian · ‎06-18-2014

I tried all options but it seems like a sas problem/limitation. Just solved the problem with temporary solution (removing the formula and reading all the values as text without formula). Working well but not a fine solution. Thanks a lot to all for your response and quick support.

danimian · ‎06-10-2014

Using the wizard is not a solution for us. I am using the code in SAS DI Studio 4.6 in a User Written Transformation. Is it Bug which has to be fix or there is any other solution? Did you try the scenaio of proc import which i provided in early emails and which result you are getting?

danimian · ‎06-10-2014

Excel 2010 SAS Enterprise Guide, Version 5.1 Hot fix 16 (32-Bit)

danimian · ‎06-10-2014

Yes. DBMS = EXCEL don't work for XLSX files.

danimian · ‎06-10-2014

As I mentioned I am reading XLSX file (myfile.xlsx). DBMS = XLSX is right.

danimian · ‎06-10-2014

Excel file name is myfile.xlsx and sheet name is firstsheet. This runs fine and return the correct values from sheet=firstsheet. proc import datafile="myfile.xlsx" out=work.myreport dbms=XLSX replace; sheet=firstsheet; getnames=no; mixed=yes; run; Excel file name is same myfile.xlsx and sheet name is secondsheet. Now if you create another sheet=secondsheet; change the excel entries in this sheet and run the following for secondsheet. you will not get the result of secondsheet. It will still show you the result of firstsheet. proc import datafile="myfile.xlsx" out=work.myreport dbms=XLSX replace; sheet=secondsheet; getnames=no; mixed=yes; run; I hope you will understand the problem now.

danimian · ‎06-10-2014

Thanks for quick responses. Please apply it with different excel sheets. It means if you execute same proc import again for another excel sheet with different values then you will not get the new values for new sheet. It returns only the value which read first time.

danimian · ‎06-10-2014

I just tried it with mixed=yes option in proc import but unfortunately its not helping.

danimian · ‎06-10-2014

Hello, We are using PROC IMPORT for Excel and reading excel formulas as cell value. As far as we have a numeric return value as a result of this formula then getting right results in our data set. But the problem is when we have text value as a result of this formula then not recieving the result text. It seams Proc Import for excel formula function only if the return value is numeric. How to solve this problem for getting the text values as a result of excel formula? or it is not possible? For example: A1 has formula =F2 A2 has formula =F3 Cell Values F2 has value 1234 F3 has value ABC When we run proc import then getting the following results: Correct: A1 = 1234 Wrong: A2 = here come nothing or some strange text??? Any help would be greatly appreciated. Dani

danimian · ‎05-13-2014

I think there is no direct / good option in DI Studio to do this like Load Time Column in Table Loader Transformation. Just managed it with User Written Code Transformation. Thanks for reply.

danimian · ‎05-13-2014

Hi, is there any standard option in SAS DI Studio to create or assign auto increment numbers column in the target table. I am merging two tables using Append Transformation and need After or In Append Trans. Please guide me if there is any possibility. Best Regards Dani

danimian · ‎02-12-2014

I am using user written transformation where i save my folder name in a var1 and then giving the whole path in another var2 concat with this var1. At the end with a boolean value of var2 0 or 1 i can identify exist or not. Thanks for answer.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Char to Numeric with Date Format

Re: Char to Numeric with Date Format

Char to Numeric with Date Format

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Char to Numeric with Date Format

Re: Char to Numeric with Date Format

Char to Numeric with Date Format

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Re: Proc Import Excel - Reading Formula Problem

Proc Import Excel - Reading Formula Problem

Re: Auto increment option

Auto increment option

Re: Store and compare values (parameter/variable)