I want to redirect output of the proc tree output (decision tree) to Excel or HTML . I tried below code for HTML output . The issue I face is , HTML output is nice when seen in output window in SAS Enterprise guide but when file is open from the location where it is saved I get 'cross' mark . Any solutions to this ? sample code is taken from sas support web of proc tree. attached is output as seen. data teeth;       title 'Mammals'' Teeth';       input mammal $ 1-16 @21 (v1-v8) (1.);       label V1='Right Top Incisors'             V2='Right Bottom Incisors'             V3='Right Top Canines'             V4='Right Bottom Canines'             V5='Right Top Premolars'             V6='Right Bottom Premolars'             V7='Right Top Molars'             V8='Right Bottom Molars';       datalines; Brown Bat          23113333 Mole                32103333 Silver Hair Bat    23112333 Pigmy Bat          23112233 House Bat          23111233 Red Bat            13112233 Pika                21002233 Rabbit              21003233 Beaver              11002133 Groundhog          11002133 Gray Squirrel      11001133 House Mouse        11000033 Porcupine          11001133 Wolf                33114423 Bear                33114423 Raccoon            33114432 Marten              33114412 Weasel              33113312 Wolverine          33114412 Badger              33113312 River Otter        33114312 Sea Otter          32113312 Jaguar              33113211 Cougar              33113211 Fur Seal            32114411 Sea Lion            32114411 Grey Seal          32113322 Elephant Seal      21114411 Reindeer            04103333 Elk                04103333 Deer                04003333 Moose              04003333 ; run;       proc cluster method=average std pseudo noeigen outtree=tree;       id mammal;       var v1-v8;   run; ods html path='path-of-the-file' file='testme.html' ;   proc tree horizontal;   run; ods _all_ close; ... View more

Dear All I have xls file and one of column has value like this 'some text1','some text2','some text3' (with quotes)  ,While reading this xls file using proc import SAS  misses first " ' " from the value in dataset .and I get value in dataset as some text1','some text2','some text3' (note 1st quote is missing) Can anyone let me know reason or fix for this ? ... View more

Dear SAS users, I have reasonable experience using SAS softwares and its products like SAS Drug development , SAS management consol , Base SAS Macros , SAS enterprise guide . I am quite comfortable in programming as well. But I do not have much knowledge on statistics or Analytics . I want to grow in this area using SAS software. Can any one suggest any menthod, book or any self learning tool which can be used to build competency in this area. Does SAS has something for me ? ... View more

Hi I have a decison tree from proc tree . I need to print it on very big paper say paper length 100cm . i.e paper size biger than A0. I have output in pdf but it prints really bad on that size of paper and texts are not readable . Apprantly I can not print image using the printer but any help in this regard is good. Also I do not want to spilt output in multiple pages becaus then i will have to glue them . Any one know any method generate graphs so that quality does not go down on bigger paper ? ... View more

Hi I have outputs from proc summary procedure . I want to output them in single excel file with multiple sheets in it ; is there any way we can do this except ODS TAGSETS ? if please give references as well. The reason I do not want to use ODS TAGSET is the warning "file is in a different file format than its extension indicates "it gives while opening the file with office 2010. and I do not want to create .xml files to get rid of the warning. ... View more

Hello, I have SAS 9 installed on unix . I use SAS EG for coding . I want to know if there is anyway (except Import taks in SAS EG) to transfer files from windows to unix using SAS code . ... View more

My requirement is to execute tasks or program in parallel using SAS EG 4.3 ; I know one way i.e by using or creating logical workspace servers but somehow I do not like it as it requires manually creating them in SMC and then changing the servers in tasks manually. Is there any way where we can write small code which can execute tasks or/and program from the same SAS EG project by launching multiple SAS sessions? I read on SAS web that there are some exciting feature in this regard in SAS EG 5.1 but for now I do not plan for upgrade. so any solution for 4.3. ... View more