cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Jaheuk
‎11-27-2021
  • 98 Posts
  • 4 Likes Given
  • 0 Solutions
  • 11 Likes Received

copy/paste transformation in DI job

by Obsidian | Level 7 in SAS Data Management
‎04-06-2021 07:39 AM
‎04-06-2021 07:39 AM
copy/paste of a large and complicated transformation: 1/ copy is only visible after saving the job = ok https://support.sas.com/kb/58/092.html 2/ when changing properties of the copy: "old" transformation also changes connection lost with output . . .    suggestions to do it properly ??     Herman ... View more

proc compare, ony output unequal obs

by Obsidian | Level 7 in SAS Procedures
‎03-11-2021 11:42 AM
‎03-11-2021 11:42 AM
when I use proc compare to compare 2 data sets AND everything is 100% the same, I still get output because I use the ID statement  how can I avoid this??       ... View more

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

by Obsidian | Level 7 in SAS Enterprise Guide
‎05-12-2020 05:45 AM
‎05-12-2020 05:45 AM
hi, when using "grouped colored vertical bar" chart there is no possibility to check the legend option like in other graphs. (however it can be done in the html output, but when you re-create the graph the legend is gone).   Can somebody give me a coded example to I can do it hard coded ? Even this works not with me 😞   Gr, Herman   ... View more

Re: LEGEND with Enterprise Guide proc gchart

by Obsidian | Level 7 in SAS Enterprise Guide
‎05-12-2020 05:39 AM
‎05-12-2020 05:39 AM
hi, I have the same problem . . . do you have a solution? Herman ... View more

INTNX function with datetime vars

by Obsidian | Level 7 in SAS Programming
‎02-26-2020 09:40 AM
‎02-26-2020 09:40 AM
dear all,   using INTNX('dtmonth' , var1 , 0 , 'e' )   gives me the last day of the month of var1 ==> 31JAN2020:23:59:59   however I want 31JAN2020:00:00:00,   Of course I can subtract (24h*60m*60s) - 1:  intnx('dtmonth', var1 , 0 ,'e' ) - 86399   but is there a nicer way ??   H. ... View more

sub query

by Obsidian | Level 7 in SAS Enterprise Guide
‎02-03-2020 02:10 PM
‎02-03-2020 02:10 PM
dear all, I have a small dataset with 10 accounts which I try to use in the query builder in eGuide 5.1 in the where section as a subquery. The result I get is only data of the last account of this small dataset.   What can be the problem that my query does not give data of all 10 accounts ??   ... View more

Re: PROC TABULATE

by Obsidian | Level 7 in SAS Procedures
‎01-02-2020 06:04 AM
‎01-02-2020 06:04 AM
55,8 %  of amount 984.555 = 549.283 euro, so an extra column with this value   I googled a lot, but I think it is not possible to add a calculated column           ... View more

PROC TABULATE

by Obsidian | Level 7 in SAS Procedures
‎01-02-2020 03:47 AM
‎01-02-2020 03:47 AM
dear all, using <colpctsum> I get the percentage of a column with amounts. great but HOW do I get tha value itself   ( amount * colpctsum )  ??   H.     ... View more

in query builder select all columns with *

by Obsidian | Level 7 in SAS Enterprise Guide
‎08-03-2018 05:24 AM
‎08-03-2018 05:24 AM
dear all, I am doing a proc transpose. the number of columns is based on the data. If I put a query afterwards I would fetch all transposed columns:   select *.T1 from . . . .   HOW do I do this with query builder ??   Kr, Herman ... View more

GRAPHS on z/OS mainframe

by Obsidian | Level 7 in ODS and Base Reporting
‎08-04-2017 10:45 AM
‎08-04-2017 10:45 AM
Dear all, we only have SAS BASE9.2  on our z/OS mainframe. I want to create a simple graph with PROC GCHART I tested on pc but this procedure is not included with base on the mainframe.   Which graph procedures are in SAS BASE9.2 ??   GreetZ, Herman ... View more

Re: PCT in PROC TABULATE

by Obsidian | Level 7 in SAS Programming
‎08-03-2017 10:21 AM
‎08-03-2017 10:21 AM
　 dear all, sorry for all confusions,   below table like it should be and code to create the datasets in two ways: numeric in one or multiple columns. green cells are related and orange cells are related.           I tried to use either PROC TABULATE or REPORT but without good result. Below the PROC REPORT I was strungeling with:   proc report data=vert missing nowd out=REPORT; column vkpnt groep mnd,(aantal perct) ; define vkpnt / group ; define groep / group order=data ; define mnd / across ' '; define aantal / SUM '#'; define perct / COMPUTED 'PCT'; compute perct; perct = perct / aantal.sum ; endcomp; run;               /***********************************************************************/     data VERT; mnd='1708'; div='ANTW/LIM'; mang='MARC'; aorg='1006'; vkpnt='LESSELIERS'; groep='totaal'; aantal=100; OUTPUT; groep='TOTNOK'; aantal=50; OUTPUT; groep='eid'; aantal=10; OUTPUT; groep='fisc'; aantal=20; OUTPUT; groep='tele'; aantal=20; OUTPUT;   mnd='1709'; div='ANTW/LIM'; mang='MARC'; aorg='1006'; vkpnt='LESSELIERS'; groep='totaal'; aantal=105; OUTPUT; groep='TOTNOK'; aantal=45; OUTPUT; groep='eid'; aantal=5; OUTPUT; groep='fisc'; aantal=20; OUTPUT; groep='tele'; aantal=15; OUTPUT; groep='fatca'; aantal=5; OUTPUT; RUN; 　 　 data HORZ; mnd='1708'; div='ANTW/LIM'; mang='MARC'; aorg='1006'; vkpnt='LESSELIERS'; totaal=100; tot_mis=50; eid=10; fisc=20; tele=20; OUTPUT; mnd='1709'; div='ANTW/LIM'; mang='MARC'; aorg='1006'; vkpnt='LESSELIERS'; totaal=105; tot_mis=45; eid=5; fisc=20; fatca=5; tele=15; OUTPUT; RUN;         REGARDS,   Herman ... View more

PCT in PROC TABULATE: part 2

by Obsidian | Level 7 in SAS Programming
‎08-02-2017 10:10 AM
‎08-02-2017 10:10 AM
as an extra to my first questions the real output should be like this (i have no data yet): if you give me sas syntax you may call the variabels A, B, C, . . . .   like the column names   ... View more

PCT in PROC TABULATE

by Obsidian | Level 7 in SAS Programming
‎08-02-2017 09:43 AM
‎08-02-2017 09:43 AM
dear all, this is an fictive example . . . . I want a total (ALL) per region (actual+predict) and the spread IN percent in the year, but my code below fails . . . can someone help me out please?   %LET dev=CANADA; proc tabulate data=sashelp.prdsale missing; where country="&dev."; by region ; class region division year; var actual predict ; table region*(actual predict all ) , year *(sum=''*f=commax7. colpctsum='%'*f=6.2) /rts=60 box="&dev." ; RUN;   OUT SHOULD BE:     ... View more

z/OS: imbed jpeg in pdf (proc report and ods)

by Obsidian | Level 7 in ODS and Base Reporting
‎10-14-2016 02:05 AM
‎10-14-2016 02:05 AM
when I create a pdf on sas pc I use this syntax:   ODS escapechar='^'; title j=R "^S={preimage='z:\reports\pics\AXA_HEAD.jpeg'} " ;   I want to move this to mainframe: * how to transfer jpeg file * what is the syntax of the title statement then   GreetZ, Herman ... View more

PROC REPORT: line statement and bold

by Obsidian | Level 7 in ODS and Base Reporting
‎10-11-2016 11:19 AM
‎10-11-2016 11:19 AM
what's wrong in this code?? I want to print label in bold, variables as normal . . . For _C1_ I already tried _COL_  or _ROW_   COMPUTE before _page_  ;                                   call define(_C1_,'style','style={font_weight=bold   }');      %if &VARI4. EQ 02 %THEN  line @1 'Nom:'   ;                                  %ELSE  line @1 'Naam:'  ;;            call define(_C1_,'style','style={font_weight=normal }');                  line @1      naam    $50.   ;               call define(_C1_,'style','style={font_weight=bold   }');      %if &VARI4. EQ 02 %THEN  line @1 'Agence:' ;                                 %ELSE  line @1 'Agentschap:' ;;       call define(_C1_,'style','style={font_weight=normal }');                  line @1      aorg_cd $5.  ;                 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-27-2021 04:06 AM
Likes given to
Likes from
View All
Quick links