topic Re: Proc Sql Sample datasets in SAS Procedures

Proc Sql Sample datasets

AbhishekTyagi — Mon, 19 Jan 2015 11:46:21 GMT

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 !

Re: Proc Sql Sample datasets

Ksharp — Mon, 19 Jan 2015 13:37:24 GMT

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

Re: Proc Sql Sample datasets

AbhishekTyagi — Mon, 19 Jan 2015 14:32:10 GMT

Thanks Xia Keshan.