About Jaheuk

Jaheuk · ‎07-19-2013

dear all, code below gives the name of the oldest person per group. but for F we have 2 with the same age! HOW to get the equal values? proc summary data=sashelp.class nway missing ; class sex; output out=WORK(drop=_:) idgroup(max(age) out(age name)=mage name ); run; proc print; run; i.e. we can get top 3 with this code, but that is not what i mean :smileyblush: proc summary data=sashelp.class nway missing ; class sex; output out=WORK(drop=_:) idgroup(max(age) out[3](age name)=mage name ); run; proc print; run; GreetZ, Herman

Jaheuk · ‎12-04-2012

dear all, I am trying to define my own name for generated graphs (instead of gchartx) but it seems not to work with GSFNAME: any idea ?? THX!! PS. how to copy/paste sas code into this page ??

Jaheuk · ‎09-21-2012

using &#91 and &#93 in the footnote statement did it !!! H.

Jaheuk · ‎09-21-2012

dear all, on mainframe my jobs sends an email. now I create a footnote with square brackets [ - - - ] but in my email something else appears! how to know which hexcode to use on mainframe to have square brackets in my mail in outlook?? GreetZ, Herman

Jaheuk · ‎08-30-2012

dear all, on SAS PC 9.2 I create an XLS with ODS LISTING close; ods html file="\\....\HU.xls" rs=none style=seasideprinter; ..... ODS HTML3 close ; ODS LISTING; However, at the end of the program I always get the POPUP box (with <open> <save>) after creation? HOW to avoid this popup? GreetZ, Herman

Jaheuk · ‎07-25-2012

dear all, program belows runs for months with the expected result! NOW, I suddenly have NO style anymore (i.e. yellow in the background). In fact if I choose another style, there is not much changing!! Is there something wrong with my installation or settings?? Regards, Herman

Jaheuk · ‎06-28-2012

hi data _null_; nearly perfect on screen sas organizes all vars so they can been seen on one screen. (in order from top to bottom and left to right). with your example, on paper, sas puts all vars below each other so we can have an overflow :smileycry: do you have a solution for this too? GreetZ, Herman

Jaheuk · ‎06-28-2012

hi folks, is there some kind of PROC or options for PROC PRINT/REPORT to have a FSEDIT like ouput (this is 1 obs per page) ? so you have a quick look on all vars of one obs on one page!! GreetZ, Hermie

Jaheuk · ‎02-21-2012

indeed it will go into a loop UNTIL the file is present in the folder, I'd hoped !!

Jaheuk · ‎02-21-2012

DATA _NULL_ ; fex= 0 ; DO UNTIL(fex=1 ) ; if %sysfunc(fileexist("C:\temp\fix.txt")) then fex=1 ; else x=sleep(5 ); END ; RUN ; hi guys, when file exist at start, it works! why does this NOT work when the file does not exist and is created during the sleep loop? it looks to me that fileexist is only executed once?? Regards, Herman

Jaheuk · ‎12-01-2011

Using commax15.2 did the job!! H.

Jaheuk · ‎11-29-2011

Dear all, I am using PROC PRINT with ODS TAGSETS.EXCELXP on mainframe to create an XLS. On SAS mainframe I always use format commax15. for printing amounts in European way. However when I download the created XLS to PC, all my amounts have comma's as thousand seperator ??!! How to resolve this? I tried with STYLE like I saw in some examples but without succes? Regards, Herman (BELGIUM)

Jaheuk · ‎11-09-2011

indeed, this seems to be the only solution and it works!! however, the reporting total also skips to a new page ??? that's the only issue I have so far quick example: title; ODS LISTING CLOSE; ODS PDF NOTOC FILE='c:\temp\mypdf.pdf' STYLE=SASWEB NOTOC; proc sort data=sashelp.class; by age; run; data WORK; set sashelp.class; if age < 13 then skip=0; else skip=1; gr_age=put(age,z4.) ; run; proc report data=WORK nowd; column skip name sex gr_age age ; define skip / noprint group; define name / display; define sex / display; define gr_age / noprint group; define age / analysis ; BREAK AFTER gr_age / SUMMARIZE ; break after skip / page ; RBREAK AFTER / SUMMARIZE ; quit; ODS PDF CLOSE ; ODS LISTING ;

Jaheuk · ‎11-08-2011

Hi all, how/can we force a page break in a COMPUTE BLOCK based on a variable like in DATA STEP programming using PUT _PAGE_ ?? I do NOT mean : compute before xxxx _page_; endcomp; Regards, Herman

Jaheuk · ‎10-18-2011

how to copy a MDDB from UNIX platform to Windows?? GreetZ, 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...

IDGROUP in proc summary

grapghname with gchart ??

Re: codepage z/OS and windows platform

codepage z/OS and windows platform

XLS via ODS statements

NO style anymore with simple ODS

Re: a simple PRINT proc with one obs/page

a simple PRINT proc with one obs/page

FILEEXIST vs SLEEP

FILEEXIST vs SLEEP

Point as thousand seperator in (NL) excel (and comma for decimals)?

Point as thousand seperator in (NL) excel (and comma for decimals)?

Re: PROC REPORT: force page break

PROC REPORT: force page break

copy MDDB from Unix-->Win