I can't think of a way to use a sas data set without first extracting it from the zip file. Which you can do using SAS of course: filename IN zip 'C:\temp\data.zip' member='mydata.sas7bdat' recfm=n; filename OUT "%sysfunc(pathname(work))/mydata.sas7bdat" recfm=n; data _null_; RC=fcopy('IN','OUT'); run;   ... View more

The SAS ESP Suite and other technologies available in the SAS platform were used with the Muse as a demo, but that does not limit the input to just input from the Muse device. Other eeg input sources could be pre-processed and then analyzed by the SAS suite to look for insights into the data. Here is a paper on this very topic that may be useful, but my apologies if you've already seen this work presented at SAS Global Forum.    Link to paper here: https://support.sas.com/resources/papers/proceedings14/1545-2014.pdf ... View more

@arunrami wrote: HI All,    Here is my scenario - I am using proc import , which will set the datatype based on its content , hence I have taken a copy of dataset using 'set' and tried to convert the datatype using only if it satisfies my 'if logic', but it seems still goes in to the if condition even though it doesn't satisfy my condition .   Reliance on Proc import, especially if reading data sources that are text such as CSV, is a poor practice. If you know you are going  be reading same structured data, which is sort of implied by fixing specific named variables, then better is to read them correctly in the first place using a data step. Then you control the value types at the beginning.   ... View more

You are not running a windows commad. You are using SAS's FTP engine.   What if you use your own Windows command to run an FTP command?  Then you can issue whatever FTP commands your want.   Note that the issue might be what the FTP server you are connecting to can actually produce.  Different FTP server implementations might offer different comamnds and options. Try connecting to the server using FTP and see what it supports. ... View more

SAS does have free offerings, especially for learning and research.   Check out SAS University Edition, free for any learner (not just those enrolled in university).   And if you don't want to install anything but run SAS in the cloud, we have SAS OnDemand for Academics.     ... View more

Yes, you can do this. ... View more

If you are trying to access a SFTP site then please read the documentation:   https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lestmtsglobal&docsetTarget=p0xln1fiwsr340n1xxf4mkmfxp6f.htm&locale=da    currently you have specified the FTP protocol which will not work with SFTP. ... View more

Do not use backslashes on UNIX commandlines. A backslash has a very special meaning for UNIX shells and must not be used for anything else.   But I repeat: log on to the UNIX server and run the sftp from the commandline until it works. Then start using it in SAS code. Start with logging on in interactive mode by simply doing sftp user@servername Then retrieve a file with the subcommand get (you can use most of the FTP subcommands in sftp). From that you should be able to create the commandline non-interactive version.   Disclaimer: I retrieve my data from a sane operating system (Linux), not from any Windows, so I have no idea how filenames need to be formulated so that the Dumb Operating System understands it. ... View more

@JosvanderVelden: Yup.  ... View more

The key to this is "oracle function in SAS". No software fully support another vendors software. If you you are using SAS, use SAS functions. To use Oracle functions, use Oracle. From SAS this can be done using SQL explicit pass through. ... View more