Help using Base SAS procedures

Proc Sql Sample datasets

Reply
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 http://support.sas.com/documentation/onlinedoc/base/#base93.  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: 9,687

Re: Proc Sql Sample datasets

Here is :

filename trans 'c:\temp\SQLDatasetsV9';

      proc cimport library=work infile=trans;

      run;

data _null_;

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

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

run;

Xia Keshan

Attachment
New Contributor
Posts: 4

Re: Proc Sql Sample datasets

Thanks Xia Keshan.

Ask a Question
Discussion stats
  • 2 replies
  • 337 views
  • 0 likes
  • 2 in conversation