About Ronein

Ronein · ‎04-09-2018

I have 3 macros. Each macro create mutiple output tables. I want that all output tables will go to same excel file and same sheet. I want that tables created by macro1 will be down each other. I want that tables created by macro2 will be down each other but on side of tables created by macro1 I want that tables created by macro3 will be down each other but on side of tables created by macro2 Can anyone send please an example to code for that request?

Ronein · ‎04-09-2018

Hello i have a macro that i run . The macro creates multiple tables with different names and print them. Before proc print statement i have titles ststement. The problem is that for each table that printed out there are titles. I want that the titles will appear only above first printed table. Any solution to this request?

Ronein · ‎04-09-2018

i have a macro that i run . The macro creates multiple tables with different names and print them. Before proc print statement i have titles ststements The problem is that for each tqble that printed out there are titles. I want that the titles will appear only appove first printed table. Any solution to this request?

Ronein · ‎04-09-2018

Hello. I have different macros that i run . In each macro i create multiple tables with different names and print them. The problem is that when i run all together then in output window i only see prints of last macro. What is the solution to see all printed tables in the output window ?

Ronein · ‎04-08-2018

I am at home so dont have SAS but i will write an example to simple code and what I need. In the code you can see a statement Title “&param1.”; I want that instead of written ’a’ to be written '0-20' I want that instead of written ’b’ to be written '20-40' I want that instead of written ’b’ to be written '40+' data tbl; input x y; cards; 1 10 2 15 3 30 4 40 5 50 ; Run; Data tbl2; Set tbl1; IF y<=20 then Ind=’a’; Else If y>20 and y<=40 then Ind=’b’; Else If y>40 then Ind=’c’; Run; %let vector=a+b+c; %macro test; %do i=1 %to 3; %let param1 = %scan(&vector,i,+); PROC SQL; Create table Summarry_&param1. AS SELECT count(*) as NoObs FROM tbl2 WHERE Ind=&param1. QUIT; Title “&param1.”; Proc print data= Summarry_&param1. Noobs; Run; %end; %mend test;

Ronein · ‎04-08-2018

Hello I have a parameter that get values : a,b,c,d,e I have proc print that run on tables: tbl_a , tbl_b ,tbl_c, tbl_d, tbl_e And in each report there is a title statement (Title "&Param.") My request : Each time that value "a" is on title of proc print I want to write "Group1". Each time that value "b" is on title of proc print I want to write "Group2". Each time that value "c" is on title of proc print I want to write "Group3". Each time that value "d" is on title of proc print I want to write "Group4". Each time that value "e" is on title of proc print I want to write "Group5". How can I do it please

Ronein · ‎04-05-2018

please look at this example the file name is .xls and not .xml as you said ODS tagsets.excelXP options (sheet_name='disease by sex') file= "C:\Temp\SASSI\examp10a.xls"; PROC TABULATE data=sassi.examp10a; CLASS disease sex; TABLES disease, sex*n; RUN; ODS tagsets.excelxp close;

Ronein · ‎04-05-2018

Hello I need to export SAS formatted tables and SAS graphs to excel file (multiple sheets). I need to export for example a table and a chart to same sheet . What is best way to do it? ODS excel or ODS TAGSETS.EXCELXP or another method? My friend told me that she didn't succeed to export the charts by using ODS TAGSETS.EXCELXP. Is it true? thanks Ronein

Ronein · ‎04-05-2018

Hello I have some questions: 1-Using TAGSETS.EXCELXP to export data from sas to excel. What is the different between .XLS file and .XML file? Is it recommended to use .XLS file or .XML file? n 2-What is the best way to export formatted tables created in sas to excel? thanks Ronein

Ronein · ‎04-04-2018

Perfect and thank you so much. Just one issue need to add to your code. When max(y) is null then we need to import the repair file because this file is not in SAS. As you see it is Conditionally Import because it is done only if max(y) is null. Can you please add it to the code you sent? thanks

Ronein · ‎04-04-2018

Hello I have the following issue. I run a monthly report based on a monthly input file. IF there is a problem with field Y input file then there is an extra table that we use in order to fix the input file. How can I tell SAS that IF field Y is Null in all rows then need to import an extra file and then merge input file with repair file in order to fix the field. For example: Data Input_tbl; input ID X Y; cards; 1 10 . 2 20 . 3 30 . ; run; Data Reapir_tbl; input ID Y; cards; 1 100 2 200 3 300 ; run; The import of the repair file is done by proc import proc import datafile="D:/Reapir_tbl.csv" out=Reapir_tbl dbms=csv replace; getnames=yes; run;

Ronein · ‎03-20-2018

Thanks a lot for your reply. I am not sure how conditional formatting--Color Scales--Red Yellow Green color scales is working in excel . My target is to get same colors formats in SAS like in Excel. Do you know how to do it please?

Ronein · ‎03-19-2018

Hello I am using proc report I want that top header "ID info" and top header "measurement info" will be in yellow background color with big font size. I want that low header "x" "w" "y" will be with blue background color with small font size. Can anyone help ? data tbl; input x w y; cards; 1 2 3 4 5 6 7 8 9 ; run; proc report data=tbl nowd headline headskip STYLE(Header)={background=lightblue foreground=black } STYLE(column)={background=lightgray foreground=black} STYLE(report)=[rules=rows bordercolor=black]; /*Title 'גליון 1';*/ column ("ID info" x w) ("measurement info" y) ; define x / display ; define w / display ; define y / display ; run;

Ronein · ‎03-19-2018

Hello I have SAS that was created by export from SAS to excel and then use Excel formats. In my work I have a task to create formats in SAS (Proc Report) and then export the fornmatted report to excel. In excel I have one column with conditional formatting of color scales (red-yellow-green colors). Does anyone know how to create conditional formatting of color scales (red-yellow-green colors) in SAS? Thanks Ronein

Ronein · ‎03-08-2018

Hello I want to add background lightgrey color to only to 2 rows: Total . 66 20 and a1 Total 60 30 I want also that two titles "groupCategory" and "Information" will in red color I want also that column z1 will be bold Can anyone help please? Data tbl; Input Z1 $ Z2 $ X Y; Cards; a1 b1 10 5 a1 b2 20 10 a1 b3 30 15 a1 Total 60 30 a2 b1 1 2 a2 b2 2 4 a3 b3 3 6 a3 Total 6 8 Total . 66 20 ; Run; PROC REPORT DATA=tbl nowd SPANROWS style(header)={background=white}; Column ("groupCategory" z1 z2 ) ("Information" X Y ); DEFINE z1 /Display 'Department' style(header)={background=lightblue}; DEFINE z2 /Display 'Team' style(header)={background=lightblue}; DEFINE x /Display "לקוחות" style(header)={background=lightblue}; DEFINE y /Display "אובליגו " style(header)={background=lightblue}; Run;

Online Status	Offline
Date Last Visited	Sunday

Re: Find client number

Find client number

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: 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

Export tables down each other and side by side to same excel file and ...

Re: Mutiple proc prints with title statement within macro-want to see ...

Mutiple proc prints with title statement within macro-want to see titl...

Print multille tables in diffetent macros-results in output window

Re: Macro-change value of paraemter in title to another value

Macro-change value of paraemter in title to another value

Re: TAGSETS.EXCELXP

export SAS formatted tables and SAS graphs to excel file

TAGSETS.EXCELXP

Re: Conditionally Import

Conditionally Import

Re: conditional formatting of color scales (red-yellow-green colors) i...

Proc report -Heading colors

conditional formatting of color scales (red-yellow-green colors) in SA...

Proc report -Help

SAS Users Group in Israel