For a specific example of this in action, see this tip about working with the Stored Process Web Application. In that case, you can use the reserved fileref _WEBOUT instead of the OUT fileref. ![]() Or, going the other way, perhaps you have a SAS stored process that creates a file that you want to position as a "download" file when the user runs the stored process in a web browser. MIXED=NO /* not supported for EXCELCS */ RUN GETNAMES=YES /* not supported for EXCELCS */ * Works on 32-bit Windows */ /* If using 64-bit SAS, you must use DBMS=EXCELCS */ PROC IMPORT OUT= WORK.test Here's an example that grabs an Excel file from the Web and imports it into SAS:įilename in url "" /* PROXY= is important for going outside firewall, if you have one */ /* proxy="" */ Simply use FILENAME URL to define the IN fileref. For example, imagine that there is a file on the Web that you want to bring into SAS for analysis. But the cool thing about the above program is that it can copy files to/from other places as well - any location that you can access with a FILENAME statement, including URLs. ![]() It's true that you can copy disk-based files from one place to another by using operating system shell commands ( via SYSTASK, for example). * copy the file byte-for-byte */ data _null_ * these IN and OUT filerefs can point to anything */ filename in "c: \dataIn \input.xlsx"
0 Comments
Leave a Reply. |