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 !
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
Thanks Xia Keshan.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.