Hello, I have a very large dataset with multiple variables. Some of these variables have a value of zero, which I'd like to convert to 'NULL'. How would I go about doing this? Eg: Desciprtion, VariableA#, VariableB#.......VariableZ# Thanks!
... View more
Hello, I have one column in a dataset with 5M Rows of data. I'm trying to understand the range of values and figure out the general distribution. How would I select a percentage of the highest amounts and a percentage of the lowest amounts? Thanks!
... View more
Hi, I have one dataset with 2 columns. I would like to subtract the two columns and output this difference to a new SAS dataset. How would I go about doing this? Original Table: ID, A2017, B2018 Desired Table: B2018 - A2017
... View more
No, the same ID doesn't have to have the top value for all variables..I just want a list of all the IDS that have the top variables for each of the different columns.
... View more
Okay, so for example: Here's what I have right now: Description, ID #, A, B Cars, X123, 500, 1000 Cars, X124, 600, 2000 Cars, X125, 200, 500 Cars, X126, 800, 6000 I'd like this in return, Highest 3 values from each variable A and B: Description, ID #, A Cars, X126, 800 Cars, X124, 600 Cars, X123, 500 Description, ID #, B Cars, X126, 6000 Cars, X124, 2000 Cars, X123, 1000 But Ideally, combined together into one Table. Thanks!
... View more
Hi, I did a PROC COMPARE between two datasets. However, I would like the results to only show me the highest value differences for each variable and limit them each to about 10. How would I go about doing this? This is what I currently have. proc compare base=DATA.Base compare=DATA.Compare out= data.Result out=result outnoequal outbase outcomp outdif ; title ' Using an Output Dataset'; run;
... View more
Hi, I have the following table: Description, ID #, A, B, C, D, E, F, G. I would like one table back with the top 10 highest values of each individual column arranged the same way, ie. Description, ID #, Top 10 in A, Top 10 in B....Top 10 in G. How would I go about doing this? The values in A, B, C, D, E, F, G are all integers. Regards, JayCompany
... View more