I know how to export data from SAS using code and from the file menu but I want to know how to give a client the data with the formats. We use a .dat and .sas file to create the data. Now this dataset has to be converted to a .csv file with supporting documentation for formats.
I notice that the formats don't export.
Thanks!
One always available option is to fall back on a data step and write the file manually. Something like this:
data _null_;
set have;
file fn (...not sure what other parameters to put here in your specific case);
ln=catx(',',put(col1,col1fmt),put(col2,col2fmt).....);
put ln;
run;
AS supporting documentation for formats, you could join a file created like this :
data _null_;
set sashelp.vcolumn(where=(libname="SASHELP" and memname="CARS"));
file "carsMetaFile.csv" dsd;
put name label format;
run;
PG
Send them three files. The CSV file with the data. The variable definitions (you can get it from PROC CONTENTS for example) with NAME, TYPE, LENGTH, FORMAT, LABEL. The format definitions (you can get it from PROC FORMAT CNTLOUT=...) you will want at the minimum FMTNAME, FMTTYPE, START, LABEL.
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.