http://ftp.sas.com/samples/A56936
I would like to make data sets. I am using SAS EG. would anybody help to make these? I followed the below steps. But I was not able to.
Thanks in advance.
/********************************************************************
SAS SQL Procedure User's Guide, Version 8
Publication book code: 56936
This file contains the source code from every example in the book
for which output is shown. The examples are keyed to the
output number.
Unless specified otherwise, all examples assume
the following settings:
libname sql 'SAS-data-library';
options ls=80 ps=60 nodate nonumber;
where the SAS-data-library refers to the location of the example
data files.
Each example can be run independently, unless otherwise noted.
Some of the data sets can be downloaded as a transport file. The name
of the transport file is B56936. Any necessary data sets that are not
in the transport file are recreated for each example.
********************************************************************/
/* DOWNLOADING AND SETTING UP THE SAMPLES
1. In the Run box, type ftp.sas.com/pub/publications.
2. Right mouse click on B56936 and select Copy to folder.
3. Save the file to a local directory.
4. Start a SAS session.
5. Restore the SAS binary transport file. You can use Program
Editor to submit the code:
*/
/* Substitute the path name of your SASUSER
directory for 'your-SASUSER-directory-path'
and the appropriate path name and filename
for 'your-downloaded-file-location' */
libname new 'your-SASUSER-directory-path';
filename trans 'your-downloaded-file-location';
proc cimport library=new infile=trans;
run;
/*
6. Assign a libref named SQL to provide access to some
of the sample data sets.
libname sql 'your-SASUSER-directory-path';
7. Refer to the book for additional information on working
with the samples.
________________________________________________
Show the code you ran and the log that resulted from that run.
It is so nice to see you on the forum!!!
filename trans 'C:\Users\sharper\Desktop\B56936.txt';
proc cimport library=work infile=trans;
run;
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROJECTPATH='';
5 %LET _CLIENTPROJECTNAME='';
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
9 OPTIONS DEV=ACTIVEX;
NOTE: Procedures may not support all options or statements for all devices. For details, see the documentation for each procedure.
10 GOPTIONS XPIXELS=0 YPIXELS=0;
11 FILENAME EGSR TEMP;
12 ODS tagsets.sasreport12(ID=EGSR) FILE=EGSR STYLE=Analysis
12 ! STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SAS/EnterpriseGuideAcademics/4.3/Styles/Analysis.css") NOGTITLE
12 ! NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT12(EGSR) Body file: EGSR
13
14 GOPTIONS ACCESSIBLE;
15 filename trans 'C:\Users\sharper\Desktop\B56936.txt';
16
17 proc cimport library=work infile=trans;
18 run;
ERROR: Physical file does not exist, /local/sso/biconfig/Lev1/SASApp/C:\Users\sharper\Desktop\B56936.txt.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CIMPORT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
Memory 20k
OS Memory 11048k
Timestamp 6/19/2012 12:14:33 AM
Page Faults 0
Page Reclaims 0
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
19
20
21 GOPTIONS NOACCESSIBLE;
22 %LET _CLIENTTASKLABEL=;
23 %LET _CLIENTPROJECTPATH=;
24 %LET _CLIENTPROJECTNAME=;
25 %LET _SASPROGRAMFILE=;
26
27 ;*';*";*/;quit;run;
28 ODS _ALL_ CLOSE;
29
30
31 QUIT; RUN;
32
You can't do that. Because B56936.txt doesn't upload to your SAS Server , it is in your local PC.
So you can't read it .
ERROR: Physical file does not exist, /local/sso/biconfig/Lev1/SASApp/C:\Users\sharper\Desktop\B56936.txt
/local/sso/biconfig/Lev1/SASApp/
is the directory under your SAS Server .
C:\Users\sharper\Desktop\
is the directory under you local PC (SAS/EG).
Ksharp
I know that I can't read that. why because there two paths one unix, local one windows.
But here problem is even I load to the server its not taking.
I am using SAS on demand for academics EG
Once you upload the txt file into SAS Server . and you also have right to read ,then you can import it successfully.
filename trans '/local/sso/biconfig/Lev1/SASApp/B56936.txt';
proc import datafile=trans out= .............;
run;
Or actually your file is a transport file created by proc cport .
filename trans '/local/sso/biconfig/Lev1/SASApp/B56936.cpt';
proc cimport library=work infile=trans;
run;
If you are successful to convert the transport file into txt file . Please add that attached here or mail me abhi.sas.tyagi@gmail.com .
Thanks in Advance .
The import will fail when the original data was lantin-1 SBCS en the target destination is a DBCS - utf8 one.
This limitation is a known one. Still a bad one but known. Base SAS(R) 9.3 Procedures Guide, Second Edition (CIMPORT Problems: Importing Transport Files)
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: