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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.