Hello I have 12 data sets ,each data set has 10,000 rows and 20 columns. I want to export it into XLSX file. I wanted to do it via defining 12 proc reports ( and define rules to color cells) but since the data sets are "big" then this idea is not good. My question- In such situation , what is the recommended way to export to XLSX file? 1- proc exports 2-ODS EXCEL (with 12 proc reports)- as i saw it is not good idea here but maybe i am wrong 3-XLSX engine 4-Any other way     ... View more

Hello I want to export two data sets into XLSX file. In real word I must use proc export (and not ODS excel) because the data sets are big . I want that sheets layout be right to left and not left to right. I used  options bidi=yes; but still layout is left to right.   %let path="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/CARS_CLASS.xlsx"; options bidi=yes; proc export data=sashelp.cars outfile=&path. DBMS=xlsx replace; sheet='POP'; run; proc export data=sashelp.class outfile=&path. DBMS=xlsx replace; sheet='PART1_A'; run; ... View more

Hello I am running ods excel and also send it to email. The XLSX sheets layout  is from left to right and i want to change to right to left. What is the way to do it? %let Reportpath="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/MYCARS.xlsx"; ods excel file=&Reportpath. options (sheet_name='REPORT1' embedded_titles='yes' embedded_footnotes='yes' sheet_interval="proc" /***One table in sheet**/ gridlines = 'yes' tab_color="YELLOW" ); proc report data=sashelp.cars contents="Honda Cars"; where Make="Honda"; column ("Car" make model) ("Cost" msrp invoice) ("Fuel Efficiency" mpg_city mpg_highway); run; ods excel options (sheet_name='REPORTS2' sheet_interval="proc" /**One table in sheet***/ gridlines = 'yes' tab_color="YELLOW" ); proc report data=sashelp.cars contents="All Cars" spanrows; /* 2 */ define Make / order; define Model / order; column Make Model MSRP MPG_City Horsepower; run; ods excel close; /****SEND EMAIL****/ /****SEND EMAIL****/ FILENAME mail EMAIL from="Ron.Dave@gmail.com" TO=("Ron.Dave@gmail.com") SUBJECT="CAR REPORTS" encoding='utf-8' /**To show Hebrew!!!**/ CONTENT_TYPE="text/plain" attach=(&Reportpath. content_type="excel"); ODS LISTING CLOSE; /*ODS HTML BODY=mail;*/ data _null_; file mail; put 'HELLO'; put 'ATTACH FILE'; put ' '; put ' '; put ' '; put 'REGARDS'; run;   ... View more

Hello I want to send an email from sas . I want that one sentence (text) be in red color FILENAME mail EMAIL from="Ron.Dave@gmail.com" TO=("Ron.Dave@gmail.com") SUBJECT=" UPDATE" encoding='utf-8' CONTENT_TYPE="text/plain" ; ODS LISTING CLOSE; data _null_; file mail; put 'HELLO'; put style(header)={background=Red color=blue} "Here is my report"; put ' '; put ' '; put ' '; put 'Dave'; run;   ... View more

Hello I want to create a binary variable that check if char var contain only numbers. I saw this code in google search  isnumber = not missing(input(X_Char,?? 32.)); and I want to understand it please. What is the meaning of ??  I see that also this code work well isnumber = not missing(input(X_Char,best.)); data have; input X_Char $; isnumber = not missing(input(X_Char,?? 32.)); datalines; 3.22 4..2 N/A 1.23e7 (a1) 1234 (a2) 2000 8000 Good ; Run; ... View more

Hello I want to do freq on multiple vars. What is the reason that for var sex (the var that i defined) I dont see values in resulted data set??? DATA CLASS(drop=sex rename=(_sex=sex)); SET sashelp.class; IF SEX='F' THEN _SEX='(a1) F'; else _Sex='(a2) M'; Run; ods output onewayfreqs=work.owf; proc freq data=CLASS ; tables _all_/nocum nopercent ; run; data work.owf(drop=frequency) ; set work.owf ; count=frequency; run; data work.owf; length v_name v_value $ 200; set work.owf; v_name=scan(table,2); v_value=scan(catx(' ',of name--weight),1); *name is the first variable,weight is the last variable in sashelp.class table; keep v_name v_value count; run; ... View more

Hello I want to ask about percent format. The format  PCT1 show .0574%  but I want it to show  0.0574% The format PCT2 show (.0574%)  but I want it to show (0.0574%) Data have; x1=1276; x2=-1276; total=2222151; pct1=x1/total; pct2=x2/total; format pct1 pct2 percent8.5; Run; ... View more