About Jaheuk

Jaheuk · ‎10-04-2016

dear all, does someone has the correct syntax in using STYLE attributes when programming in DATA _NULL_ ? a piece I already have 😉 ODS LISTING CLOSE; ODS PDF NOTOC FILE=mypdf STYLE=sasweb ; ods escapechar='^'; data _NULL_ ; SET verder END=LAST; file PRINT ; put @01 "^S={foreground=red textdecoration=underline}" @01 "^S={foreground=red textdecoration=underline}" haorgcd 5. '/' volg 2. "^S={}"; put @01 taal $LA. @01 taal $LA. crtn_dttm $26.; put @01 taal $LB. @01 taal $LB. tran_amt commax17.2 ' ' ; run; I want to color, bold, . . . some text

Jaheuk · ‎03-18-2015

see SAS HELP Retrieving Data from Multiple Tables : Combining Queries with Set Operators H.

Jaheuk · ‎02-19-2015

%MACRO check_dir(dir=) ; OPTIONS NOXWAIT ; %LOCAL rc fileref ; %LET rc = %SYSFUNC(FILENAME(fileref,&dir)) ; %IF %SYSFUNC(FEXIST(&fileref)) %THEN %PUT NOTE: Directory &dir does already exist. ; %ELSE %DO ; %SYSEXEC MD &dir ; %PUT %SYSFUNC(SYSMSG()) Directory is created. ; %END ; %LET rc=%SYSFUNC(FILENAME(fileref)) ; %mend check_dir ; %check_dir(dir = c:\temp\DATA );

Jaheuk · ‎01-22-2015

hi folks, code below works, but is it possible to do it in one line :smileyconfused: %LET dt =%sysfunc(putn(&s_date.,yymmddd10.)); %LET sd1=%bquote(')&dt%bquote('); GreetZ, Herman

Jaheuk · ‎01-22-2015

please mark this as "answered" so I receive "points"

Jaheuk · ‎01-12-2015

why not use HOUR as a classification ?? it is by date and hour! data step . . . . hhour=hour(time); . . . . proc summary data=have missing nway; class date hhour; var var1 var2; output out=want (drop=_:) max=; ;

Jaheuk · ‎01-12-2015

COUNTC function ?? can you give some examples or your test data step ?? Herman

Jaheuk · ‎12-16-2014

Dear all, I finally discovered that using a tilde put quotes around the values. Perfect!! Now I still what quotes around the headers. I can use the quote function in the query quote(trim(name)) . . and yes quotes are added but the PUT statement still fails in the data _null_ step. Suggestions??? proc sql noprint; select trim(name) into :vars separated by ';' from dictionary.columns where libname="SASHELP" & memname="CLASS" order by varnum ; quit; filename temp 'c:\temp\test.txt' ; data _null_; file temp dlm=";" dsd lrecl=3000; put "&vars." ; do until (eof); set SASHELP.CLASS end=eof; put (_all_)(~); end; stop; run; GreetZ, Herman

Jaheuk · ‎08-29-2014

dear all, proc report is very nice: a few lines of code and you have a simple report with subsubtotals, subtotals, totals, . . . However, when a group(s) has only one value the report does not look very nice because the detailed, subtotals & total lines are equal. is there a trick to suppress all these things so when the output has only one line ?? GreetZ, herman

Jaheuk · ‎08-22-2014

this "delete point", I have never seen that ;-( use: data test; set sashelp.class(firstobs=4); run;

Jaheuk · ‎08-22-2014

try to run it in a macro, so you can build TITLE statement %MACRO DO_IT; %LET A=05; %LET B=02; filename MAILBOX EMAIL TO=("herman.jacobs@axa.be") TYPE='text/html' SUBJECT='test test' ; %if &a GE &b %then %let text=' A >= B'; %else %let text=' A <= B'; title; title ">>>> &text"; ODS HTML BODY=MAILBOX RS=NONE ; proc FREQ DATA=sashelp.class ; TABLES sex; RUN; ODS HTML CLOSE; %MEND; %DO_IT; HERMAN

Jaheuk · ‎08-21-2014

euuh, this code is doing the job . . . no? proc sql; select * from sashelp.class having age=max(age) and weight=max(weight); quit;

Jaheuk · ‎08-21-2014

Hi all, this week I was updating an old sas program. Several times the developer was MERGING several data sets AND at the same time using xxx.FIRST and yyy.LAST statements. I never do these things together. I think unexpected results can come up? AGREE?? GreetZ, Herman

Jaheuk · ‎08-21-2014

when using dbms=xlsx, the result only has ONE sheet? how to do this with office >2010 ?? Herman

Jaheuk · ‎08-13-2014

Hi Chris, is there already a "place" created on the sas support website with all links to possible add-ins (dll) for EG 5.1 and higher?? are do we still need to ask this to sas support personel?? Herman

Online Status	Offline
Date Last Visited	‎11-27-2021 04:06 AM

copy/paste transformation in DI job

proc compare, ony output unequal obs

HOW to create a LEGEND in sas eguide5.1 with the "grouped colored ve...

Re: LEGEND with Enterprise Guide proc gchart

INTNX function with datetime vars

sub query

Re: PROC TABULATE

PROC TABULATE

in query builder select all columns with *

GRAPHS on z/OS mainframe

Re: INTNX function with datetime vars

Re: INTNX function with datetime vars

Re: GRAPHS on z/OS mainframe

Re: a simple PRINT proc with one obs/page

Weighted average

Re: proc sql select on a variable pair(tuple)

Re: Emailing results of frequency procedure and text

Re: Calculating Maximum within one hour for a Variable...

ODS and data _null_ (on z/OS)

Re: Merging data with full outer join

Re: Create Folders in SAS

passing quoted date to DB2

Re: Calculating Maximum within one hour for a Variable...

Re: Calculating Maximum within one hour for a Variable...

Re: Counting positions in a table

Create quoted flat file headers

PROC REPORT: suppress 'double lines' (detail-total) when group has one...

Re: Delete certain records.

Re: Emailing results of frequency procedure and text

Re: Proc SQL Having Clause

MERGE and using .FIRST and/or .LAST notation

Re: Export Multi Sheets to excel

Re: ConditionalHighlighting.dll