/* Time series plot using Broad River data */ libname broad '/home/grego1/STAT 540/'; run; data Broadalstonrd; set broad.Broadalstonrd; format date datetime7.; label date="Date" heightMax="Maximum Stage" heightMin="Minimum Stage" heightmean="Mean Stage" flowMax="Maximum Flow" flowMin="Minimum Flow" flowMean="Minimum Flow"; rename date=Date heightMax=MaxStage heightMin=MinStage heightMean=MeanStage flowMax=MaxFlow flowMin=MinFlow flowMean=MeanFlow; run; *Tab-delimited data set. Open in both Excel and Wordpad to inspect; proc export data=Work.Broadalstonrd outfile='/home/grego1/STAT 540/broadalston.txt' replace; run; *A single blank space is the default when using dbms=dlm; proc export data=Work.Broadalstonrd outfile='/home/grego1/STAT 540/broadalston.txt' replace dbms=dlm; run; *PROC EXPORT with DBMS=XLSX. This may not work on some systems that support both 32-bit and 64-bit processing--use dbms=xlsx instead; proc export data=Work.Broadalstonrd outfile='/home/grego1/STAT 540/broadalston.xlsx' replace dbms=xlsx; run; *Multiple worksheets; data Flow; set broadalstonrd; keep Date MaxFlow MeanFlow MinFlow; run; data Stage; set broadalstonrd; keep Date MaxStage MeanStage MinStage; run; proc export data=Work.Flow outfile='/home/grego1/STAT 540/broad.xlsx' dbms=xlsx replace; sheet="Flow"; run; proc export data=Work.Stage outfile='/home/grego1/STAT 540/broad.xlsx' dbms=xlsx replace; sheet="Stage"; run; ods csv file="/home/grego1/STAT 540/broad.csv"; proc print data=broadalstonrd label noobs; run; ods csv close; ods csv file="/home/grego1/STAT 540/broad.txt" options(delimiter='09'x); proc print data=broadalstonrd label noobs; run; ods csv close;