About Jaheuk

Jaheuk · ‎04-15-2014

hi guys, untill jan 2014 I always worked on XP, sas9.2 and office2003. I have a sas pgm working on an excel that: * the first time it creates a named range with DATA step * from second time on it PROC APPENDs data to this namend range The PIVOT in this workbook keeps on working because the NEW data appended with the proc append did EXTEND the named range. So a (automatic) refresh of the pivot was just fine. But since we have SAS9.3 and Office 2010 on a WIN7 machine for excel things we have to use: LIBNAME XLS PCFILES path="\.... and now the PROC APPEND works fine(data is added in the sheet), but the named range is NOT extended. So I have to re-define it manual so I can refresh the pivot. Anyone an idea or workaround ???? GreetZ, Herman

Jaheuk · ‎04-15-2014

hi guys, it always worked (XP, 9.2, office2003) but since we have SAS9.3 and Office 2010 on a WIN7 machine: we have to use LIBNAME XLS PCFILES path="\.... I think things are changes with this way of working H.

Jaheuk · ‎04-10-2014

previous in sas9.2 doing two PROC exports with different SHEET names in the same physical xls did work . . . now in WIN7, sas9.3 the second proc export totally overrides the first one ??!! H.

Jaheuk · ‎04-09-2014

proc export does not work on mainframe, indeed now I am using %DS2CSV but I am strugling with sepchar: on pc I have 3B for ; (is perfect) but can't find the value to use on mainframe H.

Jaheuk · ‎04-09-2014

indeed . . . an quote around CHAR vars and no quote's around NUM vars (and using the format of it) the 3 lines I have is the output csv file where you see that although a column is defined as char, sas something use no quotes H.

Jaheuk · ‎04-09-2014

I use proc print (as a standard sas tool) below to create a csv file (on mainframe): ODS CSV FILE='c:\temp\test.csv' OPTIONS(DELIMITER=';') RS=NONE; PROC PRINT DATA=F.COPBAL(obs=10) NOOBS; where c002_account_nbr like '571%E%' ; FORMAT C008_Non_Gaap $CHAR2.; RUN; ODS CSV CLOSE; Although the second column is charachter some records are not with " " (when it does not start with a letter)!! "BE01";"V443000000";"Cha... "BE01";1200000000;"Net ... "BE03";5710000E05;"Ban..... Has anyone a solution ?? GreetZ, Herman

Jaheuk · ‎02-06-2014

can someone give me the perl expression to always capture the code between BE and XX instead of substr function ? it start always at pos 6 but length can vary, ending is also always with XXX to complete total length of 11 data a; length c023 $11. ; c023='400BE88XX'; ba=substr(c023,6,-6+index(c023,'X')); run; GreetZ, Herman

Jaheuk · ‎01-21-2014

always concatinate to one, if numeric use put format: sql; table A_list as * from A ID1!!ID2 in (select ID1!!ID2 from list); /* select according to a variable tuple */; GreetZ, Herman

Jaheuk · ‎01-03-2014

data EEN; input var1 $ var2:$10. ; datalines; 100.66 100.255,77 ; run; data TWEE; set EEN; V1=input(var1,15.); V2=input(var2,commax15.2); format V1-V2 commax10. ; run; proc print; run;

Jaheuk · ‎12-31-2013

you can't run a query against an OLAP cube, read this: OLAP cube - Wikipedia, the free encyclopedia or if you are a nerd you can user MDX: MultiDimensional eXpressions - Wikipedia, the free encyclopedia for reading SAS cubes just use Entreprise Guide Herman

Jaheuk · ‎11-04-2013

>>> all code is submittted on SAS PC, because of large datasets i do a remote submit on mainframe, afterwards i read in the created subset on pc and process it so from pc view this rwork libname works BUT, now if have a dataset on pc and i want, from mainframe, read it in directly (without doing a proc upload) H.

Jaheuk · ‎11-04-2013

dear all, after a remote submit I frequently use code below to view the remote data: . . . . code . . . %sysrput pad=%SYSFUNC(PATHNAME(WORK)); ENDRSUBMIT; libname rwork "&pad." server=prdsys; HOW do I code the opposite? something like this . . . but what servername to use . . . ?? %syslput pad=%bquote(%SYSFUNC(PATHNAME(WORK))); RSUBMIT; %put &pad. ; libname rwork "&pad." server=XXXXXX ; . . . code . . . GreetZ, Herman

Jaheuk · ‎08-28-2013

Jaheuk · ‎08-28-2013

dear all, i have a file with NO delimiters. I can read it in by using input @001 xxx @010 yyyy .......... but when there is a column added i need to re-calculate the positions :smileyconfused: anyone an idea how to avoid this? i start testing by using LENGTH or ATTRIB, informat, ... before the input statement (possible with delimited data) . . . without any luck. data have; attrib v1 lengt=$4 .... v2 ....; input v1 v2; run; GreetZ, Herman

Jaheuk · ‎07-23-2013

when there is a RR in reason_code_10 in will work, else it will always be 0 test this: data year2012; set sashelp.class; array R_indicator(2) $ name sex; array Flag(2) ; do i = 1 to 2 ; if R_indicator =: 'M' then flag=1 ; else flag=.; end; test=nmiss(of flag(*)) ; drop i ; run; when nothing is found all flag are missing JAHEUK

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

<named range> in excel(2010) NOT extended with PROC APPEND

Re: WIN7, SAS9.3: proc export with dbms=XLSX

WIN7, SAS9.3: proc export with dbms=XLSX

Re: unexpected result using PROC PRINT with ODS CSV

Re: unexpected result using PROC PRINT with ODS CSV

unexpected result using PROC PRINT with ODS CSV

PERL expression

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

Re: Problem using Input to convert char with missing values to num

Re: MDDS

Re: PC vs MAINFRAME

PC vs MAINFRAME

Re: reading NO Delimited Data

reading NO Delimited Data

Re: Creating new variable from array