About MINX

MINX · ‎01-31-2018

A little correction: 1. Add quotation marks into macro variable proc sql; select "'"||strip(analysis)||'#'||strip(Product)||"'" into : AnalysisGrouplist separated by ',' from test1 where analysis ne ' ' and product ne ' '; quit; 2. Remove quotation marks to call macro variable data test2match; set test2; where groupproduct in (&AnalysisGrouplist.); run;

MINX · ‎01-28-2018

You can try Proc Rank as: proc rank data=have descending ties=low /*ties=dense*/ out=want(where=(order<=2)); by sic2 notsorted; var sumauditorsale; ranks order; run;

MINX · ‎09-13-2017

There are a lot of ways to check empty dataset as discussed in previous post https://communities.sas.com/t5/SAS-in-Health-Care-Related/Check-if-the-table-is-empty/td-p/6439 Below is one macro solution %macro emptycheck(ds=); %global TOTAL_RECORD; %LET dsid=%SYSFUNC(OPEN(&ds.)); %LET TOTAL_RECORD=%SYSFUNC(ATTRN(&dsid.,NOBS)); %LET rc=%SYSFUNC(CLOSE(&dsid.)); %put dsid=&dsid. TOTAL_RECORD=&TOTAL_RECORD. rc=&rc.; %if &TOTAL_RECORD=0 %then %do; %put This dataset (&ds.) is empty and has &TOTAL_RECORD. obs; %end; %else %do; %put This dataset (&ds.) is not empty and has &TOTAL_RECORD. obs; %end; %mend emptycheck;

MINX · ‎09-12-2017

Proc transpose for HGB and Retic to determinate the status of Toxicity. Then merge back with lab data by id. Sample codes are below proc transpose data=lab out=Toxicity; by id; where event in('HGB' 'Retic'); var result; id event; run; data Toxicity; length Toxicity $10; set Toxicity; if HGB > 8 and Retic > 0.08 then Toxicity = "YES"; else Toxicity = "None"; keep id Toxicity; run; data want; merge lab Toxicity; by id; run;

MINX · ‎09-12-2017

I Recently got a project needs SAS 9.3 to generate figure with font COMPLEX font. The output is RTF with SASEMF graph. goptions device=sasemf works fine in SAS 9.2, but the re-solution of plot is terrible in SAS 9.3 as below. It seemed that COMPELX font was not suppoted well by SASEMF in SAS 9.3. What it is the best way to use SASEMF with COMPLEX font in SAS9.3. I know this is an old version issue. But I still hope I could get some clues about this. Thank you. Below is the code I used for this test ods graphics off; ods _all_ close; ods listing; proc sort data=sashelp.class out=class; by sex; run; title; footnote; options orientation=portrait; goptions reset=all device=sasemf xmax=6in ymax=4in htext=1 ftext=complex ftitle=complex noborder; symbol1 c=red v=circle i=none; symbol2 c=blue v=square i=none; proc gplot data=class; plot weight*height=sex; run; title; footnote; quit; goptions reset=all device=sasemf htext=1 ftext=complex ftitle=complex noborder ymax=4in xmax=6in; ods rtf file=".\test1.rtf" nogfootnote nogtitle; title1 'THIS IS TEST'; proc greplay igout=WORK.gseg gout=WORK.mtemp tc=WORK.tmplt template=sid1 nofs; tdef sid1 des='Side 1' 1/llx=0 lly=0 ulx=0 uly=100 urx=100 ury=100 lrx=100 lry=0 color=white; template sid1; treplay 1:gplot; run; quit; ods rtf close; title; footnote;

MINX · ‎09-12-2017

@JohnChen_TW, There are a lot of ways to page break tables. Below is one simple example to page break for 16 observations per page. data have; set have; p = ceil (_n_/16); run; options nodate nonumber papersize=A4 topmargin="0.75in" missing=' ' orientation=landscape; ods escapechar='^'; ods document name=work.testdoc(write); ods rtf file="&outpath\test.rtf"; PROC REPORT DATA=have NOWD center headskip split='|' ls=256; title1 j=r "Page ^{thispage} of ^{lastpage}"; title5 j=c "Example"; title6 j=c "Proc Report"; footnote1 j=l "footnote"; columns p sno group name sex res ans; define p /order noprint; define sno /center style=[cellwidth=20mm] 'Subject ID'; define group /center style=[cellwidth=45mm] 'Test Group'; define name /left style=[cellwidth=60mm] 'Test Name'; define sex /center style=[cellwidth=15mm] 'Gender'; define res /center style=[cellwidth=40mm] 'Result'; define ans /center style=[cellwidth=25mm] 'Yes/ No'; break after p/page; compute after _page_/style={just=l font_face='Arial' font_size=9pt borderbottomcolor=white}; line "Note:"; line "Why the note cannot be displayed on each page...?"; endcomp; RUN; ods rtf close; ods document close; ods rtf file="&outpath\test.rtf" sectiondata='\headery540\footery540' ; ods pdf file="&outpath\test.pdf" ; proc document name=work.testdoc; replay; run; quit; ods _all_ close;

MINX · ‎09-11-2017

Thank you. combination of ODS document and proc document work.

MINX · ‎09-11-2017

Thank you for your quick response. I update my post to clarify my question. Basically it there any simple way as GREPLAY to re-order the display in SGPLOT? Thank you

MINX · ‎09-11-2017

Hi @valli If you want to overlay scatter, median line and regression line on one plot. There are two options: 1. PROC GPLOT, use PLOT, PLOT2 statements and ANNOTATION for three tasks. ex. you can use ANNOTATION for scatter, PLOT for median line and PLOT2 for regression line with SYMBOL statement to define INTERPOL=R<type><0><CLM | CLI<50...99>>. (http://www.okstate.edu/sas/v8/sashtml/gref/zbolchap.htm) 2. SGPLOT or SGSCATTER depend on the output you want to display. Hope it will help.

MINX · ‎09-11-2017

Does anyone have a good idea to use SGPLOT to generate a serial of graphs (two graphs per page) and re-order the display sequence? For example, graph 1 and 5 for the 1st page, 2 and 6 for 2nd page, etc. I always have to make a macro loop to do that for SGPLOT. It used to be done by PLOT + GREPLAY. I hope there is any simple solution. Thank you

MINX · ‎09-11-2017

Hi @JohnChen_TW I think you did not page break your table. Although table is displayed in multiples pages, SAS consider this is still one page if you did not use 'break after pagebreak_variable/page' or BY statement in PROC REPORT. That is why you only see the note is only displayed at the last page.

MINX · ‎09-08-2017

@aliyahh IF statement can not be used in CONTENTS procedure. The CONTENTS procedure shows the contents of a SAS data set and prints the directory of the SAS library. If you want to do conditional derivation for agegroup, @SASKiwi gave you the best approach in DATA step.

MINX · ‎09-08-2017

You can find the solution for similar post at https://communities.sas.com/t5/SAS-Data-Management/PROC-SQL-Joins-on-3-Tables/td-p/196808

MINX · ‎09-08-2017

Thank you for your input. I learned a lot.

MINX · ‎09-08-2017

You can just simply use libname to refer excel file as a library. Then do multiple DATA step to different excel spreadsheet. libname myxls "\\path\filename.xls"; DATA myxls.sheetname1; SET sasdataset1; DATA myxls.sheetname2; SET sasdataset2; RUN; proc datasets lib=myxls; quit; libname myxls CLEAR;

Re: Remove unbalanced parentheses in a string

Re: Counting from multiple columns

Re: Putting complex text in a macro

Re: GTL: DRAWRECTANGLE wrong position on Log scale

Re: Sample program to create derived ADSL dataset using ADaM Specifica...

Re: GTL: DRAWRECTANGLE wrong position on Log scale

Re: How to write an if/else statement based on a conditional event

GTL: DRAWRECTANGLE wrong position on Log scale

Re: Table transformation

Re: A Retain Statement or can be solved by Proc SQL

Re: How to check one variables value in another variable in same datas...

Re: How to create a flag for each month lying between 2 dates. (Interp...

Re: Exporting to CSV and Adding a line with labels

Re: Where statement?

Re: Picking the largest two observations in sales within the same indu...

Re: Where statement?

Re: Picking the largest two observations in sales within the same indu...

Re: How do I read empty dataset

Re: if with multiple conditions

Problem of device 'SASEMF' for COMPLEX font on DOS RTF in SAS 9.3

Re: PROC REPORT continued page

Re: How to generate a serial of graphs by SGPLOT as we use BY statemen...

Re: How to generate a serial of graphs by SGPLOT as we use BY statemen...

Re: Regression,Median and scatter points in one plot using gplot

How to generate a serial of graphs by SGPLOT as we use BY statement in...

Re: PROC REPORT continued page

Re: Why isn't my if then statement working?

Re: Key for several tables in Proc SQL

Re: how to compare the value of macro variable with normal variable's

Re: Multiple tables export to one excel spreadsheet

SAS Analytics Explorers