About MeganE

ballardw · ‎10-12-2016

It is very possible that the library the format is in does not match the library the data set using it is in. Some organizations have shared custom formats placed in a central library but the data using them could be scattered.

MeganE · ‎09-23-2016

I did end up getting this to work with a do/until and built in counter, but the code is too long to post here. If someone wants to send me a message with a question, feel free. But i don't know how to delete posts, so i'm going to use this one as the solution. 🙂

MeganE · ‎09-16-2016

Got it. Typical. Messed around with it for more than 30 minutes before posting out here, and then 5 minutes later i find it. 🙂 vvar(i)=cats("03 - ", vvalue(bvar(i))," > ", vvalue(avar(j))," next claim start date is earlier than current claim end date"); vvalue. It doesn't give me xclm_from##, it gives me the value for xclm_from##, which is just as good for what I was looking for. Thanks!

Astounding · ‎09-15-2016

You're right about that. I was picturing values of a variable. The variable names require the commas.

ballardw · ‎09-07-2016

If you have multiple variables that would have the same "low count" to suppress you may be better off using a custom format. Then you just print the data using that format. The example below will show any value of 10 or less as * and anything else formats as best10. You could specify any other format such as F10.2 or comma8. that you might want the varaibles displayed with. proc format library=work; Value belowten low - 10 = "*" other = [best10.]; run; data example; do x= 1 to 20; output; end; run; proc print data=example; var x; format x belowten.; run;

MeganE · ‎07-01-2016

Nevermind, i got it. nodupkey worked. In pretty much any order

Ksharp · ‎06-30-2016

you could try. But I don't know if it could work: proc datasets library=kcurr ; change &k4.=k4; run; copy out=knew; run; quit;

Prashant_Ph · ‎06-28-2016

Am really thank full @jklaverstijnJklaverstin you have solved my question, actually i tried in many ways but you have given me perfect solution. now i can continue my practice And thanks for others too who replayed

MeganE · ‎06-26-2016

Thanks! In the end i went back and ran the proc means individually prior to setting them together and after that, then did the proc append. Much faster! Thank you!

RW9 · ‎06-23-2016

Nope, you would compile all the original datasets into one dataset, with an aditional variable which identifies the year. That way you only need to program based on one dataset, and can still subset data based on the year variable. Its the way databases have worked for years.

MeganE · ‎06-17-2016

Thanks! Gave me the exact same numbers. Guess it was working, lol. 🙂

MeganE · ‎06-13-2016

Thanks! I ran this on a test case and my original way was 2 minutes, this one was 14 seconds. 🙂

Ksharp · ‎06-06-2016

In SQL range() compare the min value and max value in a variable/column. For Example: range( c4 )=0 first compare the min value and max value of C4 (e.g. |max-min| ) , if it =0 ,C4 should have all the same value. range( c4 )=0 is a condition statement in SQL , if true ,it will return 1 ,otherwise return 0 .

Ksharp · ‎04-07-2016

Also could try #byval1 + BY statement. You'd better post some test data to let someone code it for you .

MeganE · ‎04-06-2016

That did work too, thanks!

Online Status	Offline
Date Last Visited	‎04-29-2019 03:28 PM

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Re: Running multiple files concurrently instead of consecutively

Running multiple files concurrently instead of consecutively

Re: Unknown upper bound array in listing variables

Re: Importing Excel into SAS

Re: Return everything from the left of something

Re: Return everything from the left of something

Re: Countw within a macro

Re: put([var],[format]) not working ??

Re: Renaming a dataset during a proc copy

Renaming a dataset during a proc copy

Re: Forcing 2 graphs per page with SGPLOT

Re: Telling the diff between system and user formats

Re: Best way to repeat the same steps over and over until a value is r...

Re: ?Resolving? an array value to put it into a sentence

Re: Countw within a macro

Re: put([var],[format]) not working ??

Re: Proc sort nodup problem

Re: Renaming a dataset during a proc copy

Re: highest value

Re: Why does it tak 2 hours to set 6 datasets?

Re: macro var not resolving properly within %if/%then

Re: Recreate a sum(var)/sum(var) from proc sql into something else

Re: More efficient way to copy with a where statement

Re: Comparing a row in a dataset with the next row

Re: Text above columns in proc report

Re: Exporting a data _null_ to a pdf