About user24feb

user24feb · ‎11-07-2014

KurtBremser raises an important topic. 🙂 .. but if you increase loops to 7 (not sure if you should actually do this) Data A (Drop=i) B (Drop=i) ; Do i=1 To 26; C=Byte(i+64); Output; End; Do i=1 To 26; C=Byte(i+96); Output; End; Do i=1 To 26; C=Byte(i+96); Output; End; C="_"; Output; C="."; Output; C="@"; Output; Run; %Macro L(Loops=); %Do i=1 %To &Loops.; Data B (Drop=i); Retain dummy; %If &i.=1 %Then %Do; Set B ; %End; %Else %Do; Set B (Drop=C Rename=(D=C)); %End; By C NotSorted; If First.C Then Do; Do i=1 To 26; D=C!!Byte(i+64); Output; End; Do i=1 To 26; D=C!!Byte(i+96); Output; End; Do i=1 To 26; D=C!!Byte(i+96); Output; End; D=C!!"_"; Output; D=C!!"."; Output; D=C!!"@"; Output; End; %If &i.=&Loops. %Then %Do; Drop C; %End; Run; %End; %Mend; %L(Loops=3)

user24feb · ‎11-07-2014

If your file is a SAS-dataset, try: %Macro Del_F(File=,Lib=); Data _NULL_; MyFile=Open("&File."); EmptyFlag=Attrn(MyFile,"ANY"); Call SymputX("Empty",EmptyFlag); Run; %If &Empty^=1 %Then %Do; Proc Datasets Lib=&Lib. NoList MemType=Data; Delete &File.; Run; %End; %Mend; %Del_F(File=<SASFile>,Lib=<Work>)

user24feb · ‎11-04-2014

Hello, I would like to scale up the SAS-program in the attachment. The program itsself works o.k., but gives an out-of-memory error if I use it for a (very) large dataset. The critical steps are 2 hash-look-ups. My questions are: 1) Are there any obvious mistakes in the 2 look-ups which are likely to use too much memory if used for a very large dataset (I am new to hash's)? (actual error message: ERROR: Hash object added 212976 items when memory failure occurred. FATAL: Insufficient memory to execute DATA step program. Aborted during the EXECUTION phase. ERROR: The SAS System stopped processing this step because of insufficient memory. ) 2) My memory options are: memsize 4G, realmemsize 2G, sortsize 1G, msymtabmax 200M. Is there anything wrong about that (in hash-context)? 3) I could do this task with merging without hash. Could it be that merging is more "foregiving" then using a hash-object? Thanks&kind regards

user24feb · ‎11-03-2014

I can't offer a perfect fix, but you might either use the trim-function in excel (depends on your data), or export as csv and open with excel or use proc export, or in excel: "data" > "text to columns" > text qualifier = none.

user24feb · ‎11-03-2014

I have never tried this, but in principle it is possible to do something similar in SAS Base - but uglier 🙂 - like with the EG: 39007 - How to create a simple prompt for user input

user24feb · ‎11-03-2014

If I understood you correctly; 1) include any SAS-code including macros: Filename MyFile "C:\Users\Username\Desktop\Test.sas"; %Include MyFile; 2) If you would like to user-friendly replace %let-statements, you might be looking for prompts in the enterprise guide (if you#re using one); right-klick on the code in the EG, then "properties", then "prompts".

user24feb · ‎11-03-2014

I really think the sql-version is an option here. But this might work as well, if the number of observations to fill out is fixed: Data A; Input Letter $ @@; Call Missing (Num); Datalines; a b c ; Run; Data B; Input Num @@; Datalines; 1 2 3 ; Run; Data Want; Set A; By Letter; If First.Letter Then Do; i=0; Set B Nobs=MaxNum; Do Until (i=MaxNum); i=i+1; Set B Point=i; Output; End; End; Run;

user24feb · ‎10-28-2014

Depending on your actual data, this might work (kicks out ( and ) without replacement): Data A; Ex="xxxcd(1dfd32)"; Output; Ex="gegewx1d (322)"; Output; Run; Data B; Set A; Ex_new=PRXChange("s/[]//",-1,Ex); Run;

user24feb · ‎10-28-2014

I think most people start with this book: The little SAS book by Delwiche & Slaughter. 🙂

user24feb · ‎10-28-2014

Probably the key is, to find the position of the first digit/non-character. Perl-functions should be useful. This program probably needs some house-keeping, but in principle should work: Data Have; Input Address_Line_2 $50.; Datalines; MADISON WI 53714-1006 SUN PRAIRIE WI 53590-2585 MADISON WI 53716-2125 ; Run; Data Want; Set Have; Pos_of_first_digit=PRXMatch("/\d/",Address_line_2); Zip=Substr(Address_line_2,Pos_of_first_digit); * find Position of zip; State=(Substr(Address_line_2,Pos_of_first_digit-3,2)); * assumption: state is 2 characters long; Address_line_2=Substr(Address_line_2,1,Pos_of_first_digit-4); * drop zip and state; Run;

user24feb · ‎10-28-2014

Could it be that you simply need to add "ProdCode" to stat@sas's group by statement? Data Have; Input @1 ProdRunDateKey 8. @10 CustCode 6. @17 OrderNumber 7. @25 ProdCode 4. @30 LongDescription $50.; Datalines; 20140717 540150 3164650 4211 Ginkgo 2000 20140717 540150 3164650 4452 Healthy Joints 20140416 540150 3114334 4211 Ginkgo 2000 20140416 540150 3114334 4452 Healthy Joints 20140819 540258 3182987 1513 Super B 50 20140819 540258 3182987 1616 Super C 20140819 540258 3182987 2123 Zinc Plus 20140819 540258 3182987 2171 Magnesium Plus 20140522 540258 3132182 1513 Super B 50 20140522 540258 3132182 2123 Zinc Plus 20140522 540258 3132182 3324 Hair Skin & Nails Nutrition 20140522 540258 3132182 3533 Women's Daily Vitality Multi ; Run; Proc SQL NoPrint; Create Table Want As Select * From Have Group By CustCode, ProdCode Having OrderNumber = Max(OrderNumber); Quit;

user24feb · ‎10-24-2014

Hello! I need to create a dataset containing a single observation from a large dataset and create a macro-variable. Is the point option the quickest way to do this? Options Fullstimer; %Let Pos=1000; Data A (Drop=i); Do i=1 To 1000000; X=Ranuni(1); Output; End; Run; Data B; Obs=&Pos.; Set A Point=Obs; Call SymputX('MVB',X); Output; Stop; Run; %Put **&MVB.**; Data D; Set A (FirstObs=&Pos. Obs=&Pos.); Call SymputX('MVD',X); Run; %Put **&MVD.**; Thanks&kind regards

user24feb · ‎10-16-2014

Thanks Ksharp and Gergely Batho!! The Hash-idea is the key.

user24feb · ‎10-09-2014

Wow. You know a lot more than me and I am afraid I don't fully understand what the hash-part of the program does. Could you please explain? data want(drop=rc); if _n_ eq 1 then do; if 0 then set ProductStructure; * what is eqal to 0 ?; declare hash ha(dataset:'ProductStructure',multidata:'y'); * allow multiple observations; ha.definekey('Parent', 'Alternative'); * why 2 keys?; ha.definedata(all:'y'); * ?; ha.definedone(); end; set key; rc=ha.find(); do while(rc=0); * why if 0 - zero means nothing was found; output; rc=ha.find_next(); end; run;

user24feb · ‎10-09-2014

Hi! I'm afraid it's a bit more complicated. The desired dataset is: Product Component Quantity BoM_ID 2000000 4000000 0.4 2000000_01_4600000_01 2000000 4500000 0.6 2000000_01_4600000_01 2000000 4000000 0.4 2000000_01_4600000_02 2000000 4500000 0.48 2000000_01_4600000_02 2000000 4500001 0.12 2000000_01_4600000_02 2000000 4000000 0.4 2000000_01_4600000_03 2000000 4500001 0.3 2000000_01_4600000_03 2000000 4500004 0.3 2000000_01_4600000_03 2000000 4000009 0.4 2000000_02_4600000_01 2000000 4500000 0.6 2000000_02_4600000_01 2000000 4000009 0.4 2000000_02_4600000_02 2000000 4500000 0.48 2000000_02_4600000_02 2000000 4500001 0.12 2000000_02_4600000_02 2000000 4000009 0.4 2000000_02_4600000_03 2000000 4500001 0.3 2000000_02_4600000_03 2000000 4500004 0.3 2000000_02_4600000_03 2000000 4000000 0.3 2000000_03_4600000_01 2000000 4500000 0.7 2000000_03_4600000_01 2000000 4000000 0.3 2000000_03_4600000_02 2000000 4500000 0.56 2000000_03_4600000_02 2000000 4500001 0.14 2000000_03_4600000_02 2000000 4000000 0.3 2000000_03_4600000_03 2000000 4500001 0.35 2000000_03_4600000_03 2000000 4500004 0.35 2000000_03_4600000_03 The code - which unfortunately has its limitations - that gets me there is in the attached files.

Online Status	Offline
Date Last Visited	‎09-02-2022 10:58 AM

Re: Macros

Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

data set for "simulation models .." by Erdman

Re: Saving Excel-dataset after modifying

Saving Excel-dataset after modifying

Re: Create and slice a sparse set of parameters in proc optmodel

Create and slice a sparse set of parameters in proc optmodel

Re: Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

Re: PROC EXPORT to XLSX is creating a .bak file

Re: Saving Excel-dataset after modifying

Re: Passing a comma delimited variable to a Macro

Re: log summary is blank

Re: import excel from , skipping first 7 lines

Re: data set for "simulation models .." by Erdman

Re: Splitting a macro variable string into 2

Re: All possible password combinations!

Re: How to peform a check before an action

Scale up of hash look-up

Re: Export to excel: remove apostroph

Re: %include or some other procedure to call macro with conditions

Re: %include or some other procedure to call macro with conditions

Re: "fill out" or expand a dataset

Re: Intentional truncation of data

Re: Basics of SAS

Re: Need help on substr and scan function

Re: Retaining Last Transaction byProduct Id

Quickest way to get a single observation from a dataset

Re: Get a full list of possible combinations of an asymmetric tree

Re: Get a full list of possible combinations of an asymmetric tree

Re: Get a full list of possible combinations of an asymmetric tree