data work.homework; infile datalines dsd; input name $ age height; datalines; John McCloskey 35 71 June Rosesette 10 43 TinekeJones 9 37 ; proc print data = work.homework; run; ... View more

ods html file='C:\Users\liaodong\Documents\My SAS Files\red big book\chapter 19\BB.html'; title "Listing of TEST_SCORES"; proc print data=learn.test_scores; title2 "Sample of HTML Output - all defaults"; id ID; var Score1-Score3; run; ods html close; information from log: 678 *libname learn 'C:\Users\liaodong\Documents\My SAS Files\red big book\data in big red SAS'; 679 ods html file='C:\Users\liaodong\Documents\My SAS Files\red big book\chapter 19\BB.html'; NOTE: Writing HTML Body file: C:\Users\liaodong\Documents\My SAS Files\red big book\chapter 19\BB.html ERROR: A component of C:\Users\liaodong\AppData\Local\Temp\SAS Temporary Files\_TD13804_LIAODONGHUANG_\C:\Users\liaodong\Documents\My SAS Files\red big book\chapter 19\BB.html is not a directory. ERROR: No body file. HTML output will not be created. 680 title "Listing of TEST_SCORES"; 681 proc print data=learn.test_scores; 682 title2 "Sample of HTML Output - all defaults"; 683 id ID; 684 var Score1-Score3; 685 run; WARNING: No output destinations active. NOTE: There were 3 observations read from the data set LEARN.TEST_SCORES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 686 /*title "Descriptive Statistics"; 687 proc means data=learn.test_scores n mean min max; 688 var Score1-Score3; 689 run;*/ 690 ods html close; ... View more

I have a xlsx file , and there are 3 sheet in the xlsx file , the first sheet is SheetA ,the second is SheetBB, the third is SheetC. like this ： libname apple xlsx 'C:\practice everyday\input\input01.xlsx'; proc contents data = apple._all_; run; the output : how to display the sheets in actual order that they are in xlsx file?   ... View more

libname cert xlsx 'C:\practice everyday\input\input08.xlsx'; libname results 'c:\cert'; data results.output08 (drop=province); set cert.state; province = scan(location,2,' '); Location = tranwrd(Location,scan(location,2,' '),upcase(province)); run; proc print data = results.output08; run; /* This program is replace in the same variable */ I want to place the province variable instead of the second argument of tranwrd function, but it doesn't work , why ? ... View more