About FriedEgg

Peter_C · ‎08-31-2011

FriedEgg wrote: I have never experienced a behavior like you described with PROC FORMAT, do you have any links to provide me with some refernece to read on the issue? nope sorry FriedEgg, I have no link nor current evidence. But some releases-ago, an error popped up from a mixture of cntlin, cntlout and select statements that were unable to find the target member. I ran it several times to be sure. It may be a defect that has been removed since then, but I am cautious with that PROC (while it is still one of my favourites)

FriedEgg · ‎11-29-2011

I finally had a chance to go back and test this. I was downloading a very large dataset (10 billion rows, 500GB) across a slow WAN connection from an Oracle database I knew it would take many hours to complete (12 to be exact) and I wanted to have an additional way to make sure observations were getting written other than logging into the file system and checking file sizes and network traffic etc... data das.segment_broadcast_fact; if not mod(_n_,500000000) then put _n_=; set oradb2.web_session_fact ( keep = dt client_nbr user_session_id broadcast_seg_type_cd dbsliceparm = (ALL,10) where=(month(dt)=10) ); run; with this code I get a note immeditaely to my log every 500 millionth iteration in the datastep.

FriedEgg · ‎08-26-2011

using the ''dt will convert your text date to a sas numeric date value which may not correctly represent the same date in your oracle machine. %let startdate=01jan2010; %let enddate=31dec2010; data _null_; call symput('start', "'" || "&startdate.:00:00:00" || "'"); call symput('end', "'" || "&enddate.:00:00:00" || "'"); run; proc sql; /* stuff */ &start <= t3.file_date_of_report <= &end /* otherstuff */ quit;

Ksharp · ‎08-29-2011

Art'T Why not use & modify to neglect the first delimiter in comment? data want (drop=deleteme); infile 'C:\Art\fetext.txt' delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2 ; informat deleteme $1. ; informat list_name best32. ; informat original_filename $24. ; informat email_addr $26. ; informat member $4. ; informat jobno $4. ; informat name $19. ; informat ae $9. ; informat content $87. ; informat choice best32. ; format list_name best12. ; format original_filename $24. ; format email_addr $26. ; format member $4. ; format jobno $4. ; format name $19. ; format ae $9. ; format content $87. ; format choice best12. ; input deleteme $ list_name original_filename $ email_addr $ member $ jobno $ name $ ae $ content $ choice comment & $330. ; if not missing(list_name); run; Ksharp

Ksharp · ‎08-23-2011

Yes.But they are all missing value for numeric type, just like dot. Ksharp

FriedEgg · ‎08-18-2011

If you are looking to collect a variable list for a given table you can also use the sashelp.vcolumns table instead of proc contents and upcase the name as part of the extract.

checkno · ‎08-25-2011

after checking, my NLS_LANGUAGE under Oracle is : American, And both this proposed solutions are working, i'll stay on the NLS_DATE_LANGUAGE parameter of TO_DATE for convenience. Thanks, The issue seems to be with TOAD, he accept 01Aou and not 01aug whith American as language!

ari14 · ‎08-24-2011

Thanks Ksharp!

Ksharp · ‎08-18-2011

Almost like _null_'s code: data test; input q1-q48; cards; 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ; run; ods output onewayfreqs=freq; proc freq data=test ; tables q: /nofreq nocum nocol ; run; data temp(keep=tname level percent); set freq(drop=f_: ); tname=scan(table,2); level=coalesce(of q:); run; proc sort data=temp;by tname;run; proc transpose data=temp out=want(drop=_name_) prefix=x ; by tname; id level; var percent; run; data want; set want; flag=input(scan(tname,1,,'kd'),best8.); run; proc sort data=want;by flag;run; Ksharp

paulsparrow · ‎08-17-2011

THANKS! Worked like a charm. Sorry just not that good at White Papers.

FriedEgg · ‎08-17-2011

data temp; input id upc_code year ; cards; 2000351 1230070413 2004 2000351 . 2004 2000351 1230000018 2004 2000351 1230070499 2004 2000351 . 2004 2000351 . 2005 2000351 1230011813 2005 2000351 . 2005 2000351 . 2005 2000351 . 2005 2000351 1230070413 2005 2000351 . 2005 2000351 . 2005 2000351 . 2005 2000351 . 2005 2000351 1230011813 2005 ; run; proc format; value upcfmt 0-high='1' other='0'; run; proc freq data=temp; tables upc_code /out=want(drop=upc_code percent) noprint; by id year; where upc_code > 0; format upc_code upcfmt; run; or proc means data=temp n noprint; var upc_code; by id year; output out=want(drop=_type_ _freq_) n=count; run;

FriedEgg · ‎08-15-2011

Ah, that's right, thank you for the clarification.

FriedEgg · ‎08-31-2011

All of my dates show in the format: %b %d , %Y %I:%M %p Aug 11, 2011 11:27 PM

2much2learn · ‎01-12-2012

Just to follow up the thread. Well, after having tried many ways in vain, I end up with a portable web browser 'opera usb'. Basically you don't need to install it,just run it from anywhere. It seems to be one of a dozen those so called'portable browsers' .It serves my purpose. Now I can 'copy and paste' using mycompany computer. Thanks, Haikuo

FriedEgg · ‎03-24-2011

Linus, thanks, this is exactly what I was looking for! I do use the Oracle bulk loading on large data sets (typically several million rows or more) but for smaller tables was looking for this alternative.

Online Status	Offline
Date Last Visited	‎03-31-2025 06:28 PM