About Ronein

Ronein · ‎05-09-2025

One option no work! get error! Any other solution to have 2 reports in Sheet1 and 2 reports in sheet2??

Ronein · ‎05-09-2025

using NOW options - I get an error /*I want to export 2 table into sheet1 and 2 tables into sheet 2*/ /*I want to export 2 table into sheet1 and 2 tables into sheet 2*/ /*I want to export 2 table into sheet1 and 2 tables into sheet 2*/ ods excel file="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/q6.xlsx" options(sheet_name="Sh1" sheet_interval="none" embedded_titles='yes' ); title 'Table1'; proc print data=sashelp.class(obs=3) noobs; run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel options(sheet_name="Sh2" sheet_interval="now"); /*This tells SAS to start a new sheet for next PROCs*/ proc print data=sashelp.cars(obs=5); run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel close; Error Log- 1 The SAS System 08:38 Wednesday, May 7, 2025 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program 2'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported NOTE: The ACCESSIBLE_GRAPH option is pre-production for this release. 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 /*I want to export 2 table into sheet1 and 2 tables into sheet 2*/ 29 ods excel file="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/q6.xlsx" 30 options(sheet_name="Sh1" sheet_interval="none" embedded_titles='yes' ); WARNING: Unsupported device 'SVG' for EXCEL destination. Using default device 'PNG'. 31 title 'Table1'; 32 proc print data=sashelp.class(obs=3) noobs; 33 run; NOTE: There were 3 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 2481.03k OS Memory 49432.00k Timestamp 05/09/2025 01:33:07 PM Step Count 8349 Switch Count 0 Page Faults 0 Page Reclaims 113 Page Swaps 0 Voluntary Context Switches 8 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 34 title 'Table2'; 35 proc print data=sashelp.shoes(obs=3) noobs; 36 run; 2 The SAS System 08:38 Wednesday, May 7, 2025 NOTE: There were 3 observations read from the data set SASHELP.SHOES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 605.25k OS Memory 49688.00k Timestamp 05/09/2025 01:33:07 PM Step Count 8350 Switch Count 0 Page Faults 0 Page Reclaims 54 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 1 The SAS System 13:33 Friday, May 9, 2025 ERROR: Argument now for word option sheet_interval not recognized. Expecting one of these keywords output, table, page, bygroup, bygroups, proc, none or none. 37 ods excel options(sheet_name="Sh2" sheet_interval="now"); /*This tells SAS to start a new sheet for next PROCs*/ 38 proc print data=sashelp.cars(obs=5); 39 run; NOTE: There were 5 observations read from the data set SASHELP.CARS. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds user cpu time 0.06 seconds system cpu time 0.00 seconds memory 851.84k OS Memory 50200.00k Timestamp 05/09/2025 01:33:07 PM Step Count 8351 Switch Count 0 Page Faults 0 Page Reclaims 127 Page Swaps 0 Voluntary Context Switches 13 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 40 title 'Table2'; 41 proc print data=sashelp.shoes(obs=3) noobs; 42 run; NOTE: There were 3 observations read from the data set SASHELP.SHOES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 411.90k OS Memory 50456.00k Timestamp 05/09/2025 01:33:07 PM Step Count 8352 Switch Count 0 Page Faults 0 Page Reclaims 28 Page Swaps 0 Voluntary Context Switches 11 3 The SAS System 08:38 Wednesday, May 7, 2025 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 43 ods excel close; NOTE: Writing EXCEL file: /usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/q6.xlsx 44 45 %LET _CLIENTTASKLABEL=; 46 %LET _CLIENTPROCESSFLOWNAME=; 47 %LET _CLIENTPROJECTPATH=; 48 %LET _CLIENTPROJECTPATHHOST=; 49 %LET _CLIENTPROJECTNAME=; 50 %LET _SASPROGRAMFILE=; 51 %LET _SASPROGRAMFILEHOST=; 52 53 ;*';*";*/;quit;run; 54 ODS _ALL_ CLOSE; 55 56 57 QUIT; RUN; 58

Ronein · ‎05-08-2025

Hello I want to create proc report that just display columns and color cells in following rule: If column x=1 then value in cell under column x get color background If column w=1 then value in cell under column w get color background and so on Why I don't see any color in my results?? data have; input custId branchId x w z r t q ; cards; 123456 111 0 0 1 0 0 1 ; Run; proc report data=have; column custId branchId x w z r t q ; define custId/display; define branchId/display; define x/display; define w/display; define z/display; define r/display; define t/display; define q/display; COMPUTE x; IF _COL_=1 then do; CALL DEFINE(x, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; COMPUTE w; IF _COL_=1 then do; CALL DEFINE(w, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; COMPUTE z; IF _COL_=1 then do; CALL DEFINE(z, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; COMPUTE r; IF _COL_=1 then do; CALL DEFINE(r, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; COMPUTE t; IF _COL_=1 then do; CALL DEFINE(t, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; COMPUTE q; IF _COL_=1 then do; CALL DEFINE(q, "style", "STYLE=[BACKGROUND=MISTYROSE]"); end; ENDCOMP; Run;

Ronein · ‎05-07-2025

Hello I want to color cells in specific column based on values in other column. I have tried this code but in output result i dont see colors data LONG1; Input WD EXPD RCVD RCVD_ALL _NEWC_ $; cards; -1 49 49 56 Y 01 26 26 77 Y 02 77 45 0 N 03 71 0 0 N 04 44 0 0 N ; RUN; proc report data=LONG1 missing nowd; column (WD, ( EXPD RCVD RCVD_ALL)); define WD / 'Working Day' across /*NOZERO*/ ORDER=DATA; define EXPD / analysis 'Expd' missing; define RCVD / analysis 'Rcvd' missing; define RCVD_ALL / analysis 'Rcvd all' missing; compute RCVD; if _NEWC_ = "Y" then do; call define (_col_,"style", "style={background=green}"); end; else if _NEWC_ = "N" then do; call define (_col_,"style", "style={background=red}"); end; endcomp; run; quit;

Ronein · ‎05-01-2025

I see, It remove the title (using ' ')

Ronein · ‎05-01-2025

Perfect!!! Thank you so much. 2 questions please: I removed the code : define ind/mean; Is this code essential? I see there is no difference in the result. Why didnt you also add the code :define wealth/mean; ? I removed ' ' after order=internal and I see same results. Is this code essenstail? What is the purpose of ' ' after order=internal? proc report data=long; columns custid wealth,yrmonth ind,yrmonth; define custid/group; define yrmonth/across format=monyy. order=internal; compute ind; call define(_col_,"Style","style={background=redf.}"); endcompute; run;

Ronein · ‎05-01-2025

Hello I want to use proc report to do the following- 1- Display all columns (I dont want to write the columsn names and I just want to tell SAS to dispaly all columns in data set) 2-COLOR COLUMNS with initial name "Ind" to red if the value is 1 Please note that the code should be flexible,which means that number of columns in data set can be different . data have1; input CustID Wealth2501 wealth2502 wealth2503 Ind2501 ind2502 ind2503; cards; 1 10 20 30 0 0 0 2 30 20 10 0 1 1 3 50 40 20 0 1 1 ; Run; data have2; input CustID Wealth2403 wealth2403 Ind2403 ind2403 ; cards; 1 70 80 0 0 2 60 80 0 0 3 80 40 0 1 ; Run; proc report data=have1; column _All_; run; proc report data=have2; column _All_; run;

Ronein · ‎04-28-2025

Hello I run long sas program. In Log I see a message: :Maximum Log size has been exceeded" My question- I still want to see in Log the step of running and if there is any error or warning. What should I write (code) in order to see the Log but in short?

Ronein · ‎04-23-2025

Hello I want to run macro for different macro values that are taken from data set. Way3 is not working (error) what is the way to fix it please???     data t2410; input CustID x; cards; 1 10 2 20 ; Run; data t2411; input CustID w; cards; 1 15 2 25 ; Run; data t2412; input CustID z; cards; 1 30 2 50 ; Run; data t2501; input CustID y; cards; 1 1 2 0 ; Run; data today_tbl; input CustID x_today w_today z_today y_today; cards; 1 10 20 30 1 2 20 30 40 0 ; Run; /**Way1 to run---type manual the run code***/ /**Way1 to run---type manual the run code***/ /**Way1 to run---type manual the run code***/ %macro RRR(mon); data want&mon.; merge t&mon. today_tbl; by CustID; Run; %mend RRR; %RRR(2410) %RRR(2411) %RRR(2412) %RRR(2501) /**Way2 to run***/ /**Way2 to run***/ /**Way2 to run***/ %let start_YYMM=2410; %let end_YYMM=2501; %let date_start=%sysfunc(inputn(&start_YYMM.,yymmn4.)); %let date_end=%sysfunc(inputn(&end_YYMM.,yymmn4.)); %let nr_months=%SYSFUNC(intck(month,&date_start,&date_end)); %put date_start=&date_start. ; %put date_end=&date_end. ; %put nr_months=&nr_months. ; %macro months; %do j=0 %to &nr_months; YYMM=input(put(intnx('month',&date_start.,&j.),yymmn4.),best.); output; %end; %mend months; data series_YYMM_for_macro_tbl; %months; run; proc sql; create table Run_macro_code_tbl as select cats('%RRR(',YYMM,')') as Run_code from series_YYMM_for_macro_tbl ; quit; proc sql noprint; select Run_code into :code separated by ' ' from Run_macro_code_tbl ; quit; &code /**Way3 to run***/ /**Way3 to run***/ /**Way3 to run***/ options mprint;/* turn on macro debugging**/ data _null_; Set Run_macro_code_tbl; call execute(cats('%nrstr(Run_code')); Run;       Log of way3 that have error 1 The SAS System 11:26 Wednesday, April 23, 2025 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program 1'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported NOTE: The ACCESSIBLE_GRAPH option is pre-production for this release. 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 data _null_; 29 call execute(cats('%nrstr(Run_code')); 30 Run; ERROR: Expected close parenthesis after macro function invocation not found. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 347.71k OS Memory 26524.00k Timestamp 04/23/2025 06:34:58 PM Step Count 231 Switch Count 0 Page Faults 0 Page Reclaims 42 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: CALL EXECUTE generated line. 1 + Run_code 31 32 33 %LET _CLIENTTASKLABEL=; 34 %LET _CLIENTPROCESSFLOWNAME=; 2 The SAS System 11:26 Wednesday, April 23, 2025 35 %LET _CLIENTPROJECTPATH=; 36 %LET _CLIENTPROJECTPATHHOST=; 37 %LET _CLIENTPROJECTNAME=; 38 %LET _SASPROGRAMFILE=; 39 %LET _SASPROGRAMFILEHOST=; 40 41 ;*';*";*/;quit;run; NOTE: Line generated by the CALL EXECUTE routine. 1 + Run_code ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 42 ODS _ALL_ CLOSE; 43 44 45 QUIT; RUN; 46

Ronein · ‎04-17-2025

Hello I am using proc transpose to change from long to wide. The second proc transpose is not working well and I see only zeros... data have; infile datalines truncover; format PCT percent8.2; input mon prevmon category category_PrevMon nr PCT percent8.2 ; cards; 202503 202502 1 1 100 10% 202503 202502 1 2 200 20% 202503 202502 1 3 50 5% 202503 202502 2 1 50 4% 202503 202502 2 2 10 1% 202503 202502 2 3 300 30% 202503 202502 3 1 150 15% 202503 202502 3 2 70 7% 202503 202502 3 3 80 8% ; Run; proc sort data=have;by mon;Run; proc tabulate data=have format=8.2 ; BY mon ; class category_PrevMon category ; var nr; table category_PrevMon='' all, (category='' all)*(SUM=''*nr=''*f=8.) / rts=10 misstext='0' box=''; run; proc tabulate data=have format=8.2 ; BY mon ; class category_PrevMon category ; var PCT; table category_PrevMon='' all, (category='' all)*(SUM=''*PCT=''*f=8.) / rts=10 misstext='0' box=''; run;

Ronein · ‎04-12-2025

Hello Lets say that I run a SAS program that create multiple data sets . I want to know how long time it take to create each data set and have this information in a data sets. This data set will have following columns: A-Data set name (The data set that we create) B-date+time start execute the creation of the data set C-date+time finish execute the creation of the data set D-Time in minutes or seconds to create the data set(difference between C and B) Please note that id there are other procedures that dont create data set (such as proc print/proc means noprint and so on ) then no need to include them in this information

Ronein · ‎04-09-2025

Hello I want to define macro with 12 arguments (12 months in structure YYMM). Let's say that the macro is defined by: %Macro RRR(YYMM1,YYMM2,YYMM3,YYMM4,YYMM5,YYMM6,YYMM7,YYMM8,YYMM9,YYMM10,YYMM11,YYMM12); And I want to run the macro with following arguments: %RRR(2502,2501,2412,2411,2410,2409,2408,2407,2406,2405,2404,2403) %RRR(2501,2412,2411,2410,2409,2408,2407,2406,2405,2404,2403,2402) %RRR(2412,2411,2410,2409,2408,2407,2406,2405,2404,2403,2402,2401) %RRR(2411,2410,2409,2408,2407,2406,2405,2404,2403,2402,2401,2312) %RRR(2410,2409,2408,2407,2406,2405,2404,2403,2402,2401,2312,2311) %RRR(2409,2408,2407,2406,2405,2404,2403,2402,2401,2312,2311,2310) %RRR(2408,2407,2406,2405,2404,2403,2402,2401,2312,2311,2310,2309) %RRR(2407,2406,2405,2404,2403,2402,2401,2312,2311,2310,2309,2308) %RRR(2406,2405,2404,2403,2402,2401,2312,2311,2310,2309,2308,2307) %RRR(2405,2404,2403,2402,2401,2312,2311,2310,2309,2308,2307,2306) %RRR(2404,2403,2402,2401,2312,2311,2310,2309,2308,2307,2306,2305) %RRR(2403,2402,2401,2312,2311,2310,2309,2308,2307,2306,2305,2304) %RRR(2402,2401,2312,2311,2310,2309,2308,2307,2306,2305,2304,2303) %RRR(2401,2312,2311,2310,2309,2308,2307,2306,2305,2304,2303,2302) %RRR(2312,2311,2310,2309,2308,2307,2306,2305,2304,2303,2302,2301) %RRR(2311,2310,2309,2308,2307,2306,2305,2304,2303,2302,2301,2212) %RRR(2310,2309,2308,2307,2306,2305,2304,2303,2302,2301,2212,2211) %RRR(2309,2308,2307,2306,2305,2304,2303,2302,2301,2212,2211,2210) %RRR(2308,2307,2306,2305,2304,2303,2302,2301,2212,2211,2210,2209) %RRR(2307,2306,2305,2304,2303,2302,2301,2212,2211,2210,2209,2208) %RRR(2306,2305,2304,2303,2302,2301,2212,2211,2210,2209,2208,2207) %RRR(2305,2304,2303,2302,2301,2212,2211,2210,2209,2208,2207,2206) %RRR(2304,2303,2302,2301,2212,2211,2210,2209,2208,2207,2206,2205) %RRR(2303,2302,2301,2212,2211,2210,2209,2208,2207,2206,2205,2204) %RRR(2302,2301,2212,2211,2210,2209,2208,2207,2206,2205,2204,2203) %RRR(2301,2212,2211,2210,2209,2208,2207,2206,2205,2204,2203,2202) %RRR(2212,2211,2210,2209,2208,2207,2206,2205,2204,2203,2202,2201) %RRR(2211,2210,2209,2208,2207,2206,2205,2204,2203,2202,2201,2112) My question--- What is the way to run macro and write it via code and not manfully type it? I mean, what is the way to create these statements of %RRR(.........) via code and not type it manually??

Ronein · ‎04-07-2025

I tried none and after none or none and after porc but nothing provide desire results

Ronein · ‎04-07-2025

Hello I wan to export 2 table into sheet1 and 2 tables into sheet 2 What is the way please? /****I would like to have several tables on Sheet 1 and several more on Sheet 2***/ /****I would like to have several tables on Sheet 1 and several more on Sheet 2***/ /****I would like to have several tables on Sheet 1 and several more on Sheet 2***/ ods excel file="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/ABC12.xlsx" options(sheet_name="Sh1" sheet_interval="none"); title 'Table1'; proc print data=sashelp.class(obs=3) noobs; run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel options(sheet_name="Sh2" sheet_interval="none"); proc print data=sashelp.cars(obs=5); run; title 'Table2'; proc print data=sashelp.shoes(obs=3) noobs; run; ods excel close;

Ronein · ‎04-03-2025

Is it crontab via PuTTY environment? Should I install it?

Online Status	Offline
Date Last Visited	2 weeks ago

compress and upcase in Merge

send email +attach log file only in case of error or warning

Read Log

calculate seq number within group

check if string contain substring.

Re: apply labels of columns from other data set

apply labels of columns from other data set

wide or long structure

Re: order of data sets that appear in window

order of data sets that appear in window

Re: calculate seq number within group

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Full Merge

Re: Max per loan in last 7 days

Re: Max per loan in last 7 days

Max per loan in last 7 days

Long to wide

Re: export 2 table into sheet1 and 2 tables into sheet 2 in one XLSX ...

Re: export 2 table into sheet1 and 2 tables into sheet 2 in one XLSX ...

PROC REPORT COLOR CELL IF

PROC REPORT-Color cells in specific column based on values in other co...

Re: PROC REPORT-Display _ALL_ columns and color columns start with nam...

Re: PROC REPORT-Display _ALL_ columns and color columns start with nam...

PROC REPORT-Display _ALL_ columns and color columns start with name IN...

Maximum Log size has been exceeded

Run macro on data set values

proc transpose of PCT data

check time for each data set creation

Run multiple macros---write via code and not manually

Re: export 2 table into sheet1 and 2 tables into sheet 2 in one XLSX ...

export 2 table into sheet1 and 2 tables into sheet 2 in one XLSX file

Re: Windows Task Scheduler

SAS Users Group in Israel