How to upload simple txt file to SAS Model Studio

MichalRa — Tue, 15 Feb 2022 12:19:07 GMT

I have a very trivial question - how can I upload simply .txt file as data to new project in SAS Model Studio?

Import as local file straight from .txt on my hard disk doesn't work. Viya tells to me that my file has too many colums. Anyway, I don't want to create new SAS table, I just want to test SAS Model Studio capabilities, but I can't do it without any data...

I read SAS Visual Analytics Programming Guide - Load and Convert Document Files into a CAS Table Using the loadTable Action

First question - is it proper to load files to analysis in SAS Model Studio? If not, what can I do?

I suppose that option from "Load and Convert..." is ok - I test this modyfied code, but it doesn't work. Name in table.addCaslib was the same as Caslib in table.loadTable. Path in table.addCaslib was path to folder, where my .txt file is stored. Since I added this path to allowlist table.addCaslib started to work.

But I don't understand path in table.Loadtable. What is "docconv" in example from documentation? What should I put here if I want process .txt file (or in future: files) from mypath? I receive ERROR: An access control check was detected to a full, rather than a partial path.

Finally, maybe there is another - simplier - option to analyse .txt file?

Regards,
Michał

Re: How to upload simple txt file to SAS Model Studio

sbxkoenk — Tue, 15 Feb 2022 13:23:25 GMT

I am in a hurry, so I haven't looked in the documentation.

I suppose "docconv" in example from documentation is referring to (is related to) the SAS Document Conversion Server.

For some document types you need Tika conversion (with the Tika converter that you have to install ... it's open-source).

But for .txt files , the Tika converter should not be needed.

Will have a 2nd look tonight.

Good luck,

Koen

topic Re: How to upload simple txt file to SAS Model Studio in SAS Data Science

How to upload simple txt file to SAS Model Studio

Re: How to upload simple txt file to SAS Model Studio