Help using Base SAS procedures

Proc Sql Sample datasets

New Contributor
Posts: 4

Proc Sql Sample datasets

Can any one please convert the this transport file into notepad .

/* DOWNLOADING AND SETTING UP THE SAMPLES  1. In a web browser, go to  2. In the SAS Procedure Guides section, scroll to the SAS 9.3 SQL Procedure User's Guide.  3. Right click the ZIP file, select Save target as, and save the file to a local directory.  4. Unzip the file in the local directory. The transport file name is SQLDatasetV9. 

I want this SQLDatasetV9 file sample dataset into txt file . I am able to convert this SQLDatasetV9 file into txt format in SAS Logon Manager .

Thanks in advance !

Super User
Posts: 10,784

Re: Proc Sql Sample datasets

Posted in reply to AbhishekTyagi

Here is :

filename trans 'c:\temp\SQLDatasetsV9';

      proc cimport library=work infile=trans;


data _null_;

set sashelp.vmember(where=(libname='WORK'));

call execute(catt('proc export data=',memname,' outfile="c:\temp\',memname,'.txt" dbms=tab replace;run;'));


Xia Keshan

New Contributor
Posts: 4

Re: Proc Sql Sample datasets

Thanks Xia Keshan.

Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation