Hello.
I am trying to download a file from the Census.gov site and export it to my desktop. The log shows that it reads the file and list the record count - but the file does not export out to my folder location.
Here is what I have for code.:
filename ifile ftp "de00014_uf1.zip" host='ftp2.census.gov' user='anonymous'
pass='myemail@corp.com' cd="/census_2000/datasets/Summary_File_1/Delaware/"
lrecl=1 recfm=f;
filename ofile 'C:\Users\myname\Desktop\de00014_uf1.zip' recfm=f lrecl=1;
data _null_;
infile ifile;
file ofile;
input;
put _infile_;
run;
It created the file that you asked it to create, but that is NOT a file on the H: drive that your PC can see. It is instead a really strangely named file in the one of the folders where SAS was installed.
NOTE: The file 'H:\TobyF\Files\de00014_uf1.zip' is: Filename=/sas/config/Lev1/SASApp/H:\TobyF\Files\de00014_uf1.zip, Owner Name=tobyF,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=30May2017:14:26:55
You need to make sure to use a filename that the SAS server can see.
And the log...?
Your code doesn't look complete...?
My log looks like:
1 The SAS System 08:03 Tuesday, May 30, 2017
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Request_Work';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='H:\TobyF\REPORTING\SAS\Request_Work.sas';
9 %LET _SASPROGRAMFILEHOST='2UA54714WN';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGHTML TEMP;
15 ODS HTML(ID=EGHTML) FILE=EGHTML
16 ENCODING='utf-8'
17 STYLE=HtmlBlue
18 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
19 NOGTITLE
20 NOGFOOTNOTE
21 GPATH=&sasworklocation
22 ;
NOTE: Writing HTML(EGHTML) Body file: EGHTML
23
24 GOPTIONS ACCESSIBLE;
25
26 filename ifile ftp "de00014_uf1.zip"
27 host=/*'www2.census.gov' */'ftp2.census.gov'
28 user='anonymous'
29 pass=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
30 cd = "/census_2000/datasets/Summary_File_1/Delaware/"
31 lrecl=5
32 recfm=f;
33 filename ofile 'H:\TobyF\Files\de00014_uf1.zip'
34 recfm=f
35 lrecl=5;
36
37 data _null_; infile ifile; /*input; */file 'H:\TobyF\Files\de00014_uf1.zip'/*ofile*/; input; put _infile_; run;
NOTE: 220- **WARNING**WARNING**WARNING**WARNING**WARNING****WARNING**WARNING**
NOTE: User anonymous has connected to FTP server on Host ftp2.census.gov .
NOTE: The infile IFILE is:
Filename=de00014_uf1.zip,
Pathname= "/census_2000/datasets/Summary_File_1/Delaware,
Local Host Name=alpha,
Local Host IP addr=138.39.27.115,
Service Hostname Name=ftp2.census.gov,
Service IP addr=148.129.75.35,Service Name=FTP,
Service Portno=21,Lrecl=5,Recfm=Fixed
NOTE: The file 'H:\TobyF\Files\de00014_uf1.zip' is:
Filename=/sas/config/Lev1/SASApp/H:\TobyF\Files\de00014_uf1.zip,
Owner Name=tobyF,Group Name=sas,
Access Permission=-rw-rw-r--,
Last Modified=30May2017:14:26:55
NOTE: 44860 records were read from the infile IFILE.
NOTE: 44860 records were written to the file 'H:\TobyF\Files\de00014_uf1.zip'.
2 The SAS System 08:03 Tuesday, May 30, 2017
The minimum record length was 4.
The maximum record length was 5.
NOTE: DATA statement used (Total process time):
real time 0.56 seconds
cpu time 0.03 seconds
38
39
40 data work.TEST;
41 infile 'H:\TobyF\Files\de00014_uf1.zip' truncover firstobs=30 obs=70;
42 input; put _infile_; ;
43
44 run;
NOTE: The infile 'H:\TobyF\Files\de00014_uf1.zip' is:
Filename=/sas/config/Lev1/SASApp/H:\TobyF\Files\de00014_uf1.zip,
Owner Name=tobyF,Group Name=sas,
Access Permission=-rw-rw-r--,
Last Modified=30May2017:14:26:55,
File Size (bytes)=269159
OâZ
íjmík
__ÇœW
Ï6¯¶Ì
ö×bøu
ßR\
絿N\
Ë_oûÚ
.új3í
'Fßo¥
ï[òHW
_©âí
«Î²+*
O”ŽÚ
vQ__k
Gå%_=
íB{Ùm
îµµý–
'>õݪ
9®n}_
ËÃðþ
/Ý‚9
Q__im
Wn»Íu
Õ]rš»
_kwu×
»‹Omß
œwQ6k
Ýo»«5
ÙþŠ®Z
Û%›Õy
YÉûZ^
x+í*s
¬1¯Òw
3 The SAS System 08:03 Tuesday, May 30, 2017
me_~H
ã*cìO
}?±{µ
®‚æ–Ò
÷Íy_º
NOTE: 41 records were read from the infile 'H:\TobyF\Files\de00014_uf1.zip'.
The minimum record length was 5.
The maximum record length was 5.
NOTE: The data set WORK.TEST has 41 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
45
46
47 GOPTIONS NOACCESSIBLE;
48 %LET _CLIENTTASKLABEL=;
49 %LET _CLIENTPROCESSFLOWNAME=;
50 %LET _CLIENTPROJECTPATH=;
51 %LET _CLIENTPROJECTPATHHOST=;
52 %LET _CLIENTPROJECTNAME=;
53 %LET _SASPROGRAMFILE=;
54 %LET _SASPROGRAMFILEHOST=;
55
56 ;*';*";*/;quit;run;
57 ODS _ALL_ CLOSE;
58
59
60 QUIT; RUN;
61
It created the file that you asked it to create, but that is NOT a file on the H: drive that your PC can see. It is instead a really strangely named file in the one of the folders where SAS was installed.
NOTE: The file 'H:\TobyF\Files\de00014_uf1.zip' is: Filename=/sas/config/Lev1/SASApp/H:\TobyF\Files\de00014_uf1.zip, Owner Name=tobyF,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=30May2017:14:26:55
You need to make sure to use a filename that the SAS server can see.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.