Help using Base SAS procedures

How to get SQl sample data sets?

Reply
Frequent Contributor
Posts: 110

How to get SQl sample data sets?

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.

________________________________________________

Frequent Contributor
Posts: 110

Re: need to make datasets?

Pr.

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

PROC Star
Posts: 7,468

Re: need to make datasets?

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

Super Contributor
Posts: 1,636

Re: need to make datasets?

It is so nice to see you on the forumSmiley HappySmiley HappySmiley Happy!!!

Frequent Contributor
Posts: 110

Re: need to make datasets?

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        

Super User
Posts: 10,020

Re: need to make datasets?

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

Frequent Contributor
Posts: 110

Re: need to make datasets?

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

Super User
Posts: 10,020

Re: need to make datasets?

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;

New Contributor
Posts: 4

Re: How to get SQl sample data sets?

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 .

Trusted Advisor
Posts: 3,212

Re: How to get SQl sample data sets?

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)

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 9 replies
  • 592 views
  • 0 likes
  • 6 in conversation