topic Re: Text Import only pulling in header row in SAS Data Science

Text Import only pulling in header row

bkcagg — Fri, 06 Dec 2019 17:15:16 GMT

I have twitter data that is in an XLSX format. I have added a text import in enterprise miner and connected to the folder the file is in. I have expanded the text size to 32000 and run the node. when I go the the Exported Data and explore it, the only thing that was consumed is the header row. It isn't consuming all the rows beneath that.

All other properties are set to the default.

Any idea how to get the node to consume all of the rows of data? Here is a sample of the excel document

Re: Text Import only pulling in header row

tomrvincent — Fri, 06 Dec 2019 17:17:30 GMT

Try specifying a range.

Re: Text Import only pulling in header row

bkcagg — Fri, 06 Dec 2019 17:27:09 GMT

New student user, so can you give more texture to how to do that?

Re: Text Import only pulling in header row

tomrvincent — Fri, 06 Dec 2019 17:29:37 GMT

Review the syntax of 'proc import' and the range option.

Re: Text Import only pulling in header row

bkcagg — Fri, 06 Dec 2019 17:36:17 GMT

Sorry, need more specific instructions. I see the Proc Freq results, but not where I can modify.

Re: Text Import only pulling in header row

tomrvincent — Fri, 06 Dec 2019 18:08:53 GMT

that's the wrong proc.

Re: Text Import only pulling in header row

bkcagg — Fri, 06 Dec 2019 18:40:42 GMT

Thanks for the help. Professor replied back he wants us to use the file import node instead of the text import and that is working.

Re: Text Import only pulling in header row

tomrvincent — Fri, 06 Dec 2019 19:46:37 GMT

Glad I could help.