About the_yeti

the_yeti · ‎10-14-2018

I ended up building a faux API layer on top of Selenium using Headless Chrome, and it does the job well. AFAIK currently there are no documented REST APIs that we can call *into* SAS / SSOD to execute commands or read data. All the documentation I found on REST APIs are about calling *out* of SAS/SSOD to send/get data to/from external sources. In other words - AFAIK - SAS/SSOD only provides a REST API **client** not a REST API **server**.

the_yeti · ‎07-11-2018

Thank you @Kurt_Bremser ! Adding the member name does the trick!

the_yeti · ‎07-11-2018

Thank you Chris. I think my environment might not support GZIP for some reason... I get the following error message: ERROR: Error in the FILENAME statement. ERROR 23-2: Invalid option name GZIP. ERROR: Insufficient authorization to access /sso/biconfig/940/Lev1/SASApp/_DATAOUT. The code I'm running: filename _dataout zip "/path/that/I/know/I/can/write/to/cars.csv.gz" GZIP; proc export data=sashelp.cars outfile=_dataout dbms=csv replace; run;

the_yeti · ‎05-12-2018

Hmm I think something odd is happening. The file cannot be opened by Windows. It shows an empty folder.

the_yeti · ‎05-12-2018

Thank you Kurt. That would work well if I was trying to tailor to one specific file format, but the reality is that I need a generic SAS script that can export any kind of SAS dataset to CSV (without knowing which fields it contains)... The script above works very well for what I need, with the exception of date fields, which is exported as integers - and therefore requires the receiving application of the CSV to "know" which fields are date/time coming from SAS, and convert them appropriately. Is it possible to have more control over the export process, so that I can have something like (pseudo-code): if (field is date) then format="yyyy-MM-dd";

the_yeti · ‎05-12-2018

Thank you Kurt! I'll give that a try. I receive CSV files from an external party / system that exists for many years (running Windows) and the files come with all sorts of file names that I cannot control (nor it is feasible to change such an old system), so I need to read them however they are named.

the_yeti · ‎05-12-2018

Thank you Kurt. That code seems to generate some sort of compressed file, instead of the plain text CSV, however it doesn't seem to be in the ZIP format... It's some other compression I'm afraid. Is there any hint I can use in the `filename` instruction to tell it o use LZMA, etc? This is the beginning of the file:

the_yeti · ‎05-12-2018

That works! Thank you

the_yeti · ‎05-12-2018

Thank you Kurt. Could you point me to an example? I tried a few different combinations, but no luck... proc export data=sashelp.cars outfile=test.zip zip dbms=csv replace; run; proc export data=sashelp.cars outfile=test zip dbms=csv replace; run; proc export data=sashelp.cars outfile='test.zip' zip dbms=csv replace; run;

the_yeti · ‎05-12-2018

I'm generating a CSV file from a SAS dataset, and I'd like to compress it to zip before downloading it. proc export data=sashelp.cars outfile=_dataout dbms=csv replace; run; %let _DATAOUT_MIME_TYPE=text/csv; %let _DATAOUT_NAME=cars.csv; How can I do that?

the_yeti · ‎05-12-2018

Hello, I'm following the steps in How to Export SAS Datasets as a .CSV File in SAS University Edition to export a CSV file from a SAS dataset, with something like this: libname example "/folders/myfolders"; run; proc export data=example.Example-Data outfile='/folders/myfolders/ExampleCSV.csv' dbms=csv replace; run; However, my input file has a dash in it e.g. the file is called `Example-Data.sas7bdat`. SAS give me an error because "-" (dash) is not allowed in variable names. I'm not able to rename the file, so I need a way to tell SAS to get the file name from a string, instead of a variable name. How can I do that?

the_yeti · ‎05-12-2018

I'm trying to export a SAS dataset (.sas7bdat) to CSV via SAS, and I came up the code below: libname xpto '/project/input/'; data My_Data; set xpto.myinputfile; format _ALL_; run; proc export data=My_Data outfile='/project/output/output.csv' dbms=csv replace; run; This works and the CSV file is generated. I'm using `format _ALL_` on purpose because I want to remove all formats. However, on the case of date fields, I'd like to specify an output format, such as `yyyy-MM-dd HH:mm:ss` for example, because with the code above it exports the date fields as integers.

the_yeti · ‎05-12-2018

I'm trying to decompress a file in the zip format using pure SAS code, that I can integrate as one of the steps of a SAS script. I'm running SAS via the web version of SAS Studio on the cloud hosted version (SSOD). Reading the documentation, I was able to come up with this, which attempts to expand all files in the zip to the same directory: data _null_; infile "unzip /project/input/file.zip" pipe ; input ; put _infile_; run; But I couldn't find how to tell it a specific directory to write the files, and I couldn't find how I extract a specific file from the zip file.

the_yeti · ‎01-26-2018

Hi ballardw, No, I just need a way to tell the SAS engine that is running behind SAS Studio, to execute SAS code that I will give to it. Imagine that I have a MyProgram.sas file on my local machine at my company. I want to give this file to the OnDemand SAS Server (remotely), tell it to run it, and get results back.

the_yeti · ‎01-26-2018

Correct. This is a regular production licensed on demand instance licensed by the company I work for. I considered Selenium and similar tools, but it's 2018 so it's hard to imagine that there's not an API that I can use to execute the same actions I can do on SAS Studio. Any ideas?

Online Status	Offline
Date Last Visited	‎10-14-2018 04:15 PM

Re: Execute steps I do in SAS Studio programmatically

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: Specify format for date fields exporting to CSV

Re: Export SAS Datasets as a .CSV File with a dash in the input file n...

Re: How to compres a generated CSV file?

Re: How to unzip a file via SAS (via SAS Studio / SSOD)

Re: How to compres a generated CSV file?

How to compress a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to unzip a file via SAS (via SAS Studio / SSOD)

Re: Execute steps I do in SAS Studio programmatically

Re: Execute steps I do in SAS Studio programmatically

Execute steps I do in SAS Studio programmatically

Re: Execute steps I do in SAS Studio programmatically

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: How to compres a generated CSV file?

Re: Specify format for date fields exporting to CSV

Re: Export SAS Datasets as a .CSV File with a dash in the input file n...

Re: How to compres a generated CSV file?

Re: How to unzip a file via SAS (via SAS Studio / SSOD)

Re: How to compres a generated CSV file?

How to compress a generated CSV file?

Export SAS Datasets as a .CSV File with a dash in the input file name

Specify format for date fields exporting to CSV

How to unzip a file via SAS (via SAS Studio / SSOD)

Re: Execute steps I do in SAS Studio programmatically

Re: Execute steps I do in SAS Studio programmatically