About Elliott

Elliott · ‎04-01-2021

The report output is .xls, I changed to xml and received same issue. I have narrowed it down to one field in the chat transcript and if I just comment that field out in the ODS proc print the report works, unfortunately the important part of that data is the chat content. I have also used a compress on that variable to eliminate all un writable characters and still would not work if I left that variable in the ODS output.

Elliott · ‎04-01-2021

I am having this problem and I think it comes down to some unseen invalid data that causes ODS to give this error. The report has been running fine for several months, I read in chat data and output into a report for review. The chat data is in a csv file. Last week I started having an issue where the excel only gives an error message when trying to open. There are no errors in the log. The box that pops up when trying to open the excel report . I have attached a pdf of the box. When I click ok the excel closes so no report output. I have tried to strip any unprintable characters out of the field that contains the chat data but still having the same problem. The tables look fine, I cannot see any issue or strange data. I need to figure out how to resolve this. Has anyone else have experience with this? I tried to upload the image of the box I get, but the image failed to upload. Any assistance to resolve this issue will be greatly appreciated. Thanks, Elliott

Elliott · ‎11-11-2020

Hello, I need some help with transactional data and I am not sure where to begin. I need to search transaction data in a comments field for a numeric string (Account Number). I have a data set with multiple rows with a unique id and time stamp to group all records together a chat transcript. I need to pull the account number from the comments field without knowing what it is. I only know it will be 16 digits. The client may have entered it all in one string or it could be like xxxx xxxx xxxx xxxx. Hopefully there is no other way. Can anyone assist me with this? Thanks in Advance. Elliott

Elliott · ‎07-16-2019

I used anydigit to get what I needed. Thank you Reeza

Elliott · ‎07-16-2019

ballardw, Thank you

Elliott · ‎07-16-2019

Paige, I have reached out to the requester to explain the issue for all numeric values. So now she wants to look for any business name where the first position is a numeric. In this case "716 Cigars" would be pulled in, but I think that may be the best we can do. currently in my code I have a long list of if index(lowercase(name),"???") > 0 or .....index(lowercase(name),"???") > 0.. then flag=1; logic. what would the compress logic look like? Thanks, Elliott

Elliott · ‎07-16-2019

Paige, This name field has business names.. I don't want to flag a name like A1 Cleaning as junk, that is why I need to evaluate the entire name field for all numeric values. Not some character and some numeric. does that make sense? I am trying to keep this data to a workable level. flagging names like that as junk would greatly increase the number of records I pull into the report. Elliott

Elliott · ‎07-16-2019

Reeza, I have researched all these options including the compress with d or dk options.... I need to evaluate the entire name field for all numeric values. Not the first numeric within character data. an example would be if someone put a phone number in the name field by mistake, I need to flag that with a 1. Then when I just pull out all the values that were considered junk (flag=1) any all numeric value will be included. are there any other options? Thanks, Elliott

Elliott · ‎07-15-2019

I have to scrub a name field for anything considered junk and I am using index for character junk data but I also need to look for any all numeric values, like if someone put a phone number in the name field. how do I evaluate for all numeric values in a character field? Thanks, Elliott

Elliott · ‎07-02-2019

I need to create an output file and the user wants the name, address, city, state, zip info all concatenated into one field separated by a semicolon. Is there an easy way to do that? Thanks, Elliott

Elliott · ‎07-02-2019

no, I need to identify if the business name is only a single word, no matter how many characters. The user feels this may be an invalid name and wants to review the information. They feel a single name with no spaces is an invalid business name and should be flagged. Thanks,

Elliott · ‎07-02-2019

I need to query a name variable and the user wants to know if the name is only a single word. The variable contains business names so should have multiple words. How do I do that.. for the specific words I am using index(lowercase(name), "Corp")>0 but I do not know how to query for a singer word, no matter what it is. The name field is Char 26. Any assistance you can offer will be greatly appreciated. Thanks, Elliott

Elliott · ‎01-04-2019

Sorry just getting back after the holidays... the users have come back after testing with the data I provided and now they want double quotes around each field so if it is a lastname, firstname issue then it can be accounted for. does that make sense? my current code is: proc export data=myfile outfile="mypath/myfile.csv" dbms=csv replace; putnames=yes; run; Thanks,

Elliott · ‎12-19-2018

the requested specifically wants a .csv file, they will be reading it into hadoop

Elliott · ‎12-19-2018

Hi Tom, The data _null_ did not work when I tried to pull in the variable names, it did not pick up all of them. I went back the the proc export and when I read the log it does pull all the records, I had tried to download and that is where I thought it did not pull all the records. The proc export log does show the correct formats but when I look at the excel with the data it is not displaying correctly. Not sure what to do with that. Can a put stmt be used in proc export? Thanks,

Online Status	Offline
Date Last Visited	‎01-29-2024 05:13 PM

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

ODS tagattr for credit value

Re: proc export tab delimited txt file missing last row

Re: proc export tab delimited txt file missing last row

Re: proc export tab delimited txt file missing last row

proc export tab delimited txt file missing last row

Re: how to summarize transactional data for report

Re: Appending daily datasets into a monthly dataset

Re: Use RETAIN to re-order variables

Re: Compare values within records of same group

Re: How do I eliminate the remerging summary data note?

Re: scrub character field for all numeric value

Re: ODS creating and excel output but table error on opening and no re...

ODS creating and excel output but table error on opening and no report...

searching for numeric string in character data

Re: scrub character field for all numeric value

Re: scrub character field for all numeric value

Re: scrub character field for all numeric value

Re: scrub character field for all numeric value

Re: scrub character field for all numeric value

scrub character field for all numeric value

creating 1 variable from multiple variables and separating the values ...

Re: Need to query for a variable value that only contains a single wor...

Need to query for a variable value that only contains a single word

Re: Creating a .csv of large dataset data

Re: Creating a .csv of large dataset data

Re: Creating a .csv of large dataset data