About LaurieF

LaurieF · ‎02-26-2017

I've just dropped my session and restarted SAS. The first reference to SharedFolders host service was at 00:00:01.41 seconds in - so pretty early on. It's just after the CPUID dump, if that helps.

LaurieF · ‎02-26-2017

In the VirtualBox log (Machine*Show Log), can you find something like this: Host path '/Users/username/Documents/SAS/SASUniversityEdition/myfolders', map name 'myfolders', writable, automount=true, create_symlinks=false, missing=false and this: 00:00:37.194416 VMMDev: Guest Log: 00:00:00.008954 automount VBoxServiceAutoMountWorker: Shared folder "myfolders" was mounted to "/mnt/hgfs/myfolders"

LaurieF · ‎02-26-2017

Hmm. Puzzling. Have you tried dropping the session and restarting? I'm sure you have - just having to check everything.

LaurieF · ‎02-26-2017

Make sure that you have the folder's definition as Auto-mount and Make Permanent. That's what works for me.

LaurieF · ‎02-25-2017

De Morgan's laws: The negation of a conjunction is the disjunction of the negations; and the negation of a disjunction is the conjunction of the negations or: The nots of the ands is the ors of the nots; the nots of the ors is the ands of the nots. I found that in an old SAS manual!

LaurieF · ‎02-25-2017

Additionally, if you want to simulate the data step leave: %macro comp; %local i j; %do I=1 %to 100; %do j=1 %to 100; %IF &I=5 AND J=3 %THEN %goto leave; %lotsOfOtherStuff; %continue: %end; %leave: %Lotsmorestuff; %end; %mend comp; %comp;

LaurieF · ‎02-25-2017

First off, you want and not %and! There's no equivalent of the continue and leave commands within macro code. But you can simulate it by: %macro comp; %local i j; %do i=1 %to 100; %do j=1 %to 100; %IF &I=5 AND J=3 %THEN %goto continue; %lotsOfOtherStuff; %continue: %end; %end; %mend comp; %comp;

LaurieF · ‎02-24-2017

That's exactly the technique I use in my toolkit macros. I often do the reverse as well: a debug option for setting all the mlogicing and symbolgening on, then turning them off at the end.

LaurieF · ‎02-24-2017

@Reeza You can get the current value of course from: %let mprint = %sysfunc(getoption(mprint)); @ShaneRosanbalm If you don't the option text to appear from the execution of the macro, set the option within autoexec. Otherwise, if mprint is already set on, turning it off within the macro will always appear. If you want to get really geeky, though, you can redirect the log output to a work library catalogue entry, then throw it away. But you'll still get at least a hint somewhere that you've done this.

LaurieF · ‎02-23-2017

Here you go: data schedule; input firmid startdate mmddyy10. unit times amount; attrib startdate length=4 format=date9.; datalines; 1 01/15/2012 12 3 1000 1 03/15/2013 12 1 2000 1 01/30/2011 3 4 500 2 02/05/2015 6 2 1000 ; run; data want; set schedule; output; do i = 1 to times - 1; startdate = intnx('month', startdate, unit, 's'); output; end; keep firmid startdate amount; run;

LaurieF · ‎02-23-2017

I don't completely understand what you're trying to do, but if the letter values A-Z contain 1-26, and always will, this should work (since we don't have access to your train_ datasets. (Assuming you're using ASCII - different values for EBCDIC!) %macro test; %do _j = 1 %to 1; data test_&_j; set train_&_j; do i = 65 to 90; if not find(variable, byte(i)) then continue; target = i - 64; leave; end; run; %mend test; %test; 65 to 90 are the ASCII values for A-Z; byte(65) returns A. indexc will work as well as find, here.

LaurieF · ‎02-23-2017

@rogerjdeangelis I think it depends on what the specification is, and what the results are being used for, and whether it has to be reversible If it's just for a few hundred or thousand, it should be fine. But if there are more than that, that's why I suggested md5. I know it is possible to create collisions, but it's not easy (and it's good enough for SAS/DI's SCD-2 generator…) But a proper spec would be nice.

LaurieF · ‎02-23-2017

You didn't say that was what you wanted! But it's easy: id2 = int(ranuni(0) * 9e5) + 1e5 + 1; If you want to reproduce the results, replace 0 with any number. I often use a very old phone number. This won't work consistently though: if you were to insert a new ID 3.5 (for example), the results would break down from that point. If you always want an ID to turn into the same random number, all the time, you need a hashing algorithm. I would start looking at the MD5 function.

LaurieF · ‎02-22-2017

When all else fails, ask WWACD? (What would Art Carpenter do?>

LaurieF · ‎02-22-2017

By George, I've got it - and it was, as it so often is, macro quoting, as hinted at by @Reeza. If you replace the macro comparison with %if %nrquote(&id) = %nrquote(EQ) %then %do; which effectively does the same thing as @Reeza's suggestion, it all falls into place. Without the quoting, it's interpreted logically along the lines of %if EQ EQ EQ %then %do; which will parse at execution time, after a fashion, but it's meaningless. Because eq is a reserved operand in macro code, it has to be quoted so that it isn't interpreted as an operand.

Online Status	Offline
Date Last Visited	‎09-02-2025 04:43 PM