About shivkr

shivkr · ‎10-20-2016

Hi All, In which senario we should use proc sql over data step while merging two dataset? If I have a dataset with 2 million records and other has only 200 records. which method should I use while joining these two tables? Thanks,

shivkr · ‎06-10-2014

Thanks all for your suggestion. Is it possible to get the same result using PROC SQL?

shivkr · ‎06-10-2014

Hello, How to get the running total of a variable upto n records group by some variable? I want to create a new variable by doing the sum of first 4 records order by date value and group by color. date color value 3/17/2014 white 3 3/18/2014 white 2 3/19/2014 white 1 3/20/2014 white 2 3/21/2014 white 0 3/24/2014 white 38 3/25/2014 white 38 3/26/2014 white 38 3/17/2014 black 1 3/18/2014 black 3 3/19/2014 black 2 3/20/2014 black 1 3/21/2014 black 0 3/24/2014 black 6 3/25/2014 black 7 3/26/2014 black 6

shivkr · ‎05-30-2014

Thanks all for your suggestions. Variable (column) labeled as VALUE is numeric. I didn't wanted to use round function because SAY A=0.696 B=0.7 if A=B then color=RED if A <B then color=GREEN I am exporting these values to a dashboard where variable A value should appear as one decimal precision. now if I use ROUND(A,0.1) THEN A value would be 0.7, In the dashboard value of A AND B would appear as 0.7 and COLOR value as GREEN. Thanks Shiv

shivkr · ‎05-30-2014

Hi Guys, I want to apply different precision to the same variable depending on other variable value without using round function. TABLE Value Decimal place 1 1 2.3 3 0 4 3.5678 2 0.0002 5 4.4034 1.703 0 DESIRABLE OUTPUT Value Decimal place Final value 1 1 1.0 2.3 3 2.300 0 4 0.0000 3.5678 2 3.56 0.0002 5 0.00020 4.4034 4.4034 1.703 0 1

Online Status	Offline
Date Last Visited	‎10-12-2017 01:27 PM

merging datasets

Re: Running total

Running total

Re: DECIMAL PRECISION ON THE RUN TIME

DECIMAL PRECISION ON THE RUN TIME

merging datasets

Re: Running total

Running total

Re: DECIMAL PRECISION ON THE RUN TIME

DECIMAL PRECISION ON THE RUN TIME