libname x excel 'c:\temp\temp.xlsx' SCAN_TEXT=NO;
/*first run*/
data x.sheet1;
set sashelp.class;
run;
/*second run*/
proc sql;
insert into x.sheet1
select * from sashelp.class;
quit;
/*third run*/
proc sql;
insert into x.sheet1
select * from sashelp.class;
quit;
libname x clear;
the format is messed up!
libname x excel 'c:\temp\temp.xlsx' SCAN_TEXT=NO;
/*first run*/
data x.sheet1;
set sashelp.class;
run;
/*second run*/
proc sql;
insert into x.sheet1
select * from sashelp.class;
quit;
/*third run*/
proc sql;
insert into x.sheet1
select * from sashelp.class;
quit;
libname x clear;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.