Desktop productivity for business analysts and programmers

filename statement with filevar - Error: physical file does not exist

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

filename statement with filevar - Error: physical file does not exist

Hello,

I'm trying to split and export one dataset into multiple excel files using the filevar option (name of file should correspont to the split criteria).

This is what my code looks like:

filename my_file "C:\temp\dummy.csv";

/*sort dataset*/

proc sort data=WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005 out=WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005;

     by KBA_Herst;

run;

data _Null_ ;

    set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005;

    length out_name $ 64;

    /*create name of output file */

    out_name = "C:\temp\"||compress(put(KBA_Herst,z.))||".csv";

    file my_file filevar=out_name;

    put _all_ ;

run ;


Pretty straight forward actually... The SAS log shows me, that the name and path of the output file is put together correctly.

Sure I checked if the path C:\temp\ is correct and available.

However I get an error saying the physical file does not exist.

Just for the sake of it, I created the first file manually and put it in C:\temp\. Still I get the same error message.


Running SAS EG 6.1 on WIN7 64 bit. MS Office 2010.

Any help on this would be greatly appreciated.


LOG:


1     ;*';*";*/;quit;run;
2     OPTIONS PAGENO=MIN;
3     %LET _CLIENTTASKLABEL='Code für Abfrage erstellen';
4     %LET _CLIENTPROJECTPATH='W:\CG\06_EnterpriseGuide\EG_Projekte\CG-GB_Lohndaten_Qualifizierung_CSC_20150513.egp';
5     %LET _CLIENTPROJECTNAME='CG-GB_Lohndaten_Qualifizierung_CSC_20150513.egp';
6     %LET _SASPROGRAMFILE=;
7   
8     ODS _ALL_ CLOSE;
9     OPTIONS DEV=ACTIVEX;
10    GOPTIONS XPIXELS=0 YPIXELS=0;
11    FILENAME EGSR TEMP;
12    ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
13        STYLE=HtmlBlue
14        STYLESHEET=(URL="file:///C:/Program%20Files/SASHome94/SASEnterpriseGuide/6.1/Styles/HtmlBlue.css")
15        NOGTITLE
16        NOGFOOTNOTE
17        GPATH=&sasworklocation
18        ENCODING=UTF8
19        options(rolap="on")
20    ;

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

21  
22    GOPTIONS ACCESSIBLE;
23    filename my_file "C:\temp\dummy.csv";
24  
25    /*sort dataset*/
26  
27    proc sort data=WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005 out=WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005;
28  
29         by KBA_Herst;
30  
31    run;

NOTE: Input data set is already sorted; it has been copied to the output data set.

NOTE: There were 450284 observations read from the data set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005.

NOTE: The data set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005 has 450284 observations and 14 variables.

NOTE: Compressing data set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005 decreased size by 97.01 percent.

Compressed is 337 pages; un-compressed would require 11258 pages.

NOTE: PROZEDUR SORT used (Total process time):

real time      3.90 seconds
cpu time       3.86 seconds

32  
33    data _Null_ ;
34  
35        set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005;
36  
37        length out_name $ 64;
38  
39        /*create name of output file */
40  
41        out_name = "C:\temp\"||compress(put(KBA_Herst,z.))||".csv";
42  
43        file my_file filevar=out_name;
44  
45        put _all_ ;
46  
2                                                     Das SAS System                         08:56 Wednesday, May 13, 2015

47    run ;

ERROR: Physische Datei existiert nicht, C:\temp\5.csv.

SYSTEM=EU KBA_Herst=5 KBA_Typ=AMH Modell=R 1200 GS R 1200 GS Kilowatt=77 Hubraum=1170 KZ_Baugruppe=EA KZ_Bauteil=74

Ersatzteil_Kombination=16 14 7 675 547 Anzahl=95 Datum_Erstzulassung_von=03.2007 Datum_Erstzulassung_bis=05.2010

Datum_Schadenseintritt_von=07.2011 Datum_Schadenseintritt_bis=10.2014 out_name=C:\temp\5.csv _ERROR_=1 _N_=1

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.QUERY_FOR_TRNSTRANSPOSEDQUE_0005.

NOTE: DATA statement used (Total process time):

real time      0.00 seconds
cpu time       0.01 seconds

48  
49    GOPTIONS NOACCESSIBLE;
50    %LET _CLIENTTASKLABEL=;
51    %LET _CLIENTPROJECTPATH=;
52    %LET _CLIENTPROJECTNAME=;
53    %LET _SASPROGRAMFILE=;
54  
55    ;*';*";*/;quit;run;
56    ODS _ALL_ CLOSE;
57  
58  
59    QUIT; RUN;
60  

Accepted Solutions
Solution
‎05-13-2015 11:22 AM
SAS Super FREQ
Posts: 676

Re: filename statement with filevar - Error: physical file does not exist

Are you running the code on the local SAS installation or on some SAS Server somewhere else. this might explain, why there is no c:\temp

View solution in original post


All Replies
Solution
‎05-13-2015 11:22 AM
SAS Super FREQ
Posts: 676

Re: filename statement with filevar - Error: physical file does not exist

Are you running the code on the local SAS installation or on some SAS Server somewhere else. this might explain, why there is no c:\temp

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 853 views
  • 0 likes
  • 2 in conversation