About skcussas

ChrisNZ · ‎03-18-2021

I agree that option NODUPREC must be used carefully, as @Reeza show us is outlined in the documentation. The issues of option KEEP= not working as expected, as @data_null__ demonstrates, seems at odds with what this option is supposed to mean. Shouldn't this be seen as a defect? @skcussas You should start by reading the documentation before asking a question. This behaviour of option NODUPREC is nothing new.

ballardw · ‎02-12-2019

@Andygray wrote: I tested your code with a very very large dataset at my insurance company where we deal with humongous amounts of data and it's much slower than the array based solution I am afraid. It might help to clarify this comment by including the example code as it may not be obvious which you mean. Quite often Proc Transpose is not a rapid solution for processes involving "humongous" data. So I am guessing that this refers to the transpose approach.

PGStats · ‎01-10-2019

You can approximate the same operation with: data ds1; input var var1 $; datalines; 1 x 2 y ; data ds2; input var var2 $; datalines; 2 J 3 N ; proc sql; select *, not missing(ds1.var) as inDs1, not missing(ds2.var) as inDs2 from ds1 natural full join ds2 quit; sort of...

ballardw · ‎01-10-2019

@Tom wrote: You could just hard code a number of them. clear log; clear output; next viewtable; end; next viewtable; end; pgm ; submit; You might have to experiment with a command macro to see if you could get it to figure how many need to close. Also might need to change the PGM command if you are using PC-SAS and the Enhanced (sic) Editor. I needed to use log; clear; output; clear; next viewtable; end; to clear the log and output. And yes WPGM instead of PGM for enhanced editor.

Online Status	Offline
Date Last Visited	‎02-15-2019 09:06 AM

Re: Use value of one variable to directly refer another variable

Use value of one variable to directly refer another variable

Check source of data merging

Clear log, clear output, close all viewtables and then submit the scri...

Re: proc sort with nonduprecs does not work with data = ds(keep=)

I still get duplicated rows with the modification you sug...

proc sort with nonduprecs does not work with data = ds(keep=)

proc sort with nonduprecs does not work with data = ds(keep=)

Re: proc sort with nonduprecs does not work with data = ds(keep=)

Re: Use value of one variable to directly refer another variable

Re: Check source of data merging

Re: Clear log, clear output, close all viewtables and then submit the ...