similar to post below. is there any setting for sas 9.4? i can't find the option for sas to default to LOG view after running a program   Solved: SAS Studio: default to LOG view instead of RESULTS after running a pro... - SAS Support Communities ... View more

i found an old post in link below : my code:   data set1; set sashelp.baseball ; run; proc sort; by team ; run; ods excel file="C:\Users\test.xlsx" options(sheet_interval='BYGROUP' sheet_interval='BYGROUP' sheet_name= '#byval1' ); proc print data=set1; by team; run; ods excel close;   Solved: export multiple data sets into multiple sheets in excel - SAS Support Communities     the problem is that row 1 has title and row 2 is empty. how to remove row 1 and 2 to make it looks like excel , not report. also for column Obs, is there any possible to delete or use other variable to instead? thanks.         ... View more

  i have similar situation in link below. my question is this is individual plot with many lines. but for legend, i just want to specify the color by group. for example, in FreelanceReinh Jade's post:  series x=avisit y=aval / group=usubjid attrid=myid;  for legend, instead of list usubjids, just want to list legend as blue for trta='A' and red for trta='B'. how do i do that? thanks.   Solved: How Can I Specify Line Colors per Group in SG Plot? - SAS Support Communities     ... View more

i set up some missing value as below.  in my excel output, i want the non missing numbers still the numbers, but for missing values , i want it show as NA. is there any way to do it? thanks     data Have; Set sashelp.class; if age=11 then age=.; run; proc export data=Have outfile="/usr/local/SAS/SASUsers/LabRet.excel" dbms=tab label replace; run; ... View more