About emrahbagci82

emrahbagci82 · ‎04-30-2019

i have already talked that i changed the name and tested. deal is that, same data but when the name is "CUST.xlsx" it shows output but when its "CUSTNUMBERLIST.xlsx" there is no output. no other changes inside our outside the excel. There must be an easy reason for it without seeing the codes, logs or sth other. I mean, lets say when the length of the name of excel is higher then 5 characters, SAS EG cant Show output. Its not making sense, i wait a this type of answer.

emrahbagci82 · ‎04-30-2019

Your questions shows me that you didnt read what i wrote before. I say, I JUST CHANGE THE NAME OF EXCEL, all other things are the same. with CUST. xlsx it shows result, but with CUSTNUMBERLIST.xlsx no result. We dont need any other information i think.

emrahbagci82 · ‎04-29-2019

it reads many same lines for sport named version too. i dont use proc contents, so dont have any idea what you say about proc contens. only thing i know, same data but different results.

emrahbagci82 · ‎04-29-2019

it doesnt Show any errors, in the 4th ss of no result Word, below you can see, there are no errors, but 4 notes. as i said, only difference is the name of the document. when 4 characters like MUST.xlsx, its imported, but when named as CUSTMUSTLIST.xlsx, its not imported. So i guess its becuase of the character length of documents name but it doesnt make sense.

emrahbagci82 · ‎04-29-2019

I am sending ss of the steps i follow. one for with result and one for no result. I dont use codes, just choose from lists, click and go.

emrahbagci82 · ‎04-29-2019

Dear Tom, I am not talking about both of them. My point is about the the name of the document. The excel and the data are the same, i just change the name of the document. I mean, like "CUST.xls"

emrahbagci82 · ‎04-29-2019

Hello Dear SAS users, I have found out something about excel import.and wanted to confirm it. I have data excel including customer numbers and have 300.000 lines. When i name that excel as lets say TEST.xlsx (which is 4 characters), i be able to import, but when i name as lets say "CUSTNUMBERLIST.xlsx" (wihch is 14 charcters) i am not able to import. Data is the same, only difference is the label character length. So is there a character length limit to succesfully import? Icould find in any document. Best regards.

emrahbagci82 · ‎12-03-2018

Unfortunately, remote connetcion is forbidden in my company. I will have a look at the university editions you all mentioned. Thanks a lot.

emrahbagci82 · ‎12-02-2018

Hello, I am a user of SAS in the company i work for. I use enterprise guide at work and also i had a course for EG but i want to improve my self. However i dont have enough time to do more at work to improve. So if there is way, i want to use EG at home in my personal PC with stumilated or created data, not the real time data of my company. Is it possible? Or i can only use at work? Thanks in advance.

emrahbagci82 · ‎08-13-2018

Thanks for comments. Finally, i had a solution in that way: i got the related columns for two dates in 2 different data. then in a 3. data, i just summarized customer no s. then, join 3 tables based with comstomer ids and had a data by customer id and columns for two dates. maybe i coludnt explain well, but i got what i need. Again thanks for comments. Best regards.

emrahbagci82 · ‎08-07-2018

If i exclude customers have one record, i wont see the change of them. i mean, maybe in first date it has a record, but next date it closed, but there is a change for that customer between 2 dates. I must see this.

emrahbagci82 · ‎08-06-2018

Is at ok attached?

emrahbagci82 · ‎08-06-2018

Hello, I use Enterprise Guide and I have an input data attached. my goal is to provide a report that shows only customers that the risk amounts varied between two dates. I use "Summary Tables" in "Describe" part, but i couldnt find how to exclude the customers that do not have any change of amounts. I dont wanna see them in my report. How can i do it? as i guess, i have to use formulas but which one and how? Or any other solutions for my problem. Best regards.

Online Status	Offline
Date Last Visited	‎04-30-2019 11:14 AM

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Import of Excel - Excel Label Character Length

Re: Can I use my business SAS Enterprise Guide at home by some way?

Can I use my business SAS Enterprise Guide at home by some way?

Re: How to excluding customers which do not have any change?

Re: Import of Excel - Excel Label Character Length

Re: Can I use my business SAS Enterprise Guide at home by some way?

Re: Can I use my business SAS Enterprise Guide at home by some way?

Re: Can I use my business SAS Enterprise Guide at home by some way?

Re: How to define a value in "Between" statement by using PROC SQL?

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Re: Import of Excel - Excel Label Character Length

Import of Excel - Excel Label Character Length

Re: Can I use my business SAS Enterprise Guide at home by some way?

Can I use my business SAS Enterprise Guide at home by some way?

Re: How to excluding customers which do not have any change?

Re: How to excluding customers which do not have any change?

Re: How to excluding customers which do not have any change?

How to excluding customers which do not have any change?