topic Re: need to make datasets? in SAS Procedures

How to get SQl sample data sets?

sassharp — Mon, 18 Jun 2012 00:45:59 GMT

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.

________________________________________________

Re: need to make datasets?

sassharp — Mon, 18 Jun 2012 18:21:23 GMT

Pr.

would you help me to get the above SAS sample data sets?

Re: need to make datasets?

art297 — Mon, 18 Jun 2012 19:54:50 GMT

Show the code you ran and the log that resulted from that run.

Re: need to make datasets?

Linlin — Mon, 18 Jun 2012 20:17:17 GMT

It is so nice to see you on the forum!!!

Re: need to make datasets?

sassharp — Tue, 19 Jun 2012 04:18:53 GMT

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=;

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

14 GOPTIONS ACCESSIBLE;

15 filename trans 'C:\Users\sharper\Desktop\B56936.txt';

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

21 GOPTIONS NOACCESSIBLE;

22 %LET _CLIENTTASKLABEL=;

23 %LET _CLIENTPROJECTPATH=;

24 %LET _CLIENTPROJECTNAME=;

25 %LET _SASPROGRAMFILE=;

27 ;*';*";*/;quit;run;

28 ODS _ALL_ CLOSE;

31 QUIT; RUN;

Re: need to make datasets?

Ksharp — Wed, 20 Jun 2012 02:05:50 GMT

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

Re: need to make datasets?

sassharp — Wed, 20 Jun 2012 02:26:09 GMT

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

Re: need to make datasets?

Ksharp — Wed, 20 Jun 2012 02:40:53 GMT

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;

Re: How to get SQl sample data sets?

AbhishekTyagi — Mon, 19 Jan 2015 13:06:28 GMT

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 .

Re: How to get SQl sample data sets?

jakarman — Mon, 19 Jan 2015 14:45:33 GMT

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)