About Rahul_SAS

Rahul_SAS · ‎10-07-2016

Hi KurtBremser, Thank you for the help. I have one more point, if the first observation has a missing value then how will it work?? thnx rahul

Rahul_SAS · ‎10-07-2016

Hi Experts, I need to swap missing value with above value so please help me in the same. data abc; input sub $ score; datalines; 001 120 001 . 002 220 001 . 002 . 003 . 003 230 ; run; data abc1; set abc; score2=lag(score); if score = . then score=lag(score); run; WANT 001 120 001 120 002 220 001 220 002 220 003 220 003 230 thnx

Rahul_SAS · ‎09-07-2016

hi AncaTilea, why for i=3 var OUT has a valur 2???

Rahul_SAS · ‎09-07-2016

i simply want every second obs only.

Rahul_SAS · ‎09-07-2016

Hi Experts, I am using below mentioned code but getting repeated observation and for first observation OUT variable has missing value...WHY?? data new ; do i=1 to 10; if mod(i,2)=0 then out=i; output; end; run; OUTPUT: Obs i out 1 1 . 2 2 2 3 3 2 4 4 4 5 5 4 6 6 6 7 7 6 8 8 8 9 9 8 10 10 10

Rahul_SAS · ‎08-22-2016

hi pgstate, could you please explain it...why _n_ does not change do untill() loop. See, let me explain my prblem again... I have 100 obs n two variables Actual and predict. I have to group them in 10 groups each and take sum.of each of 10 groups will make an output dataset with 10 observation which are grouped n summed. as we can achieve using.. Proc Rank data=DSN groups=10; Var Actual; run; and then can get the cumulative sum using first. n last. And I want to replace proc rank with Do Until() loop.

Rahul_SAS · ‎08-22-2016

so what about the further iterations i.e. _n_=1,2,3...

Rahul_SAS · ‎08-22-2016

Hi Experts, I am trying to execute the folloing code but its going for the infinite looping. Can anyone help me to understand why its happening. data test; input Account Transaction; cumm=0; do until (mod(_n_,2)=0); cumm + Transaction; end; datalines; 1 0 0 1 1 1 0 0 ; run; ~Rahul

Rahul_SAS · ‎08-11-2016

hi could you please explain a bit how POINT options is working here?? -Rahul

Rahul_SAS · ‎08-10-2016

Hi Experts, Is there any way to swap two or more observations within a dataset like I want to swap 15th observation with 83rd. Please help. Regards

Rahul_SAS · ‎06-28-2016

Hi Experts, I am unable to understand how this program is giving output for 8 observation and repeating 1, 2 and 5??? data input; infile datalines; input Var1 $ Var2 $; datalines; A one A two B three C four A five ; RUN; data one two; set WORK.INPUT; count= _n_; if Var1='A' then output WORK.ONEs; output; run;

Rahul_SAS · ‎11-20-2015

Hi Peter, Sorry to say but didn't get anything helpful in the given link. Regards Rahul

Rahul_SAS · ‎11-20-2015

Hi Peter, Thanks for your prompt reply. I can't reload the data on daily basis as table size is to large it takes 10-12 hours for full load so I loading data on daily basis by incremental load using Append Tables. But here I need to delete last 3 days data from LASR Table and append updated last 3 days data. Regards Rahul

Rahul_SAS · ‎11-19-2015

Hi Experts, I am trying to delete some observations from a LASR tablel test but geting the ERROR: Update access is not supported for file LASRLIB.test. proc sql noprint; delete FROM LASRLIB.test where businessdate = today() - 3; quit; -Rahul

Rahul_SAS · ‎07-10-2015

so, suppose if we have a dataset with 5 dimensions and 4 measures and want to convert 1 dimension out of 5 to separate variables. how can we do the same. Cann't we achieve the same using Proc Transpose??? I am trying it but not able to do so... )-:

Online Status	Offline
Date Last Visited	‎01-28-2025 04:46 PM

Array with Nested Loops

Re: date difference between 0001-01-01 and 2023-01-01

date difference between 0001-01-01 and 2023-01-01

Join table with case when

Re: Getting exponential value

Re: Getting exponential value

Getting exponential value

LASR Vs CAS Vs Micro Analytics Services

Reading Multiple CSVs

Re: Automated Incremental Load

Re: Getting exponential value

Re: Reading multiple csv files

Re: Spliting a string with all upper case

Re: A New Date Field Required

Re: why repeated observations??

Re: Converting a category to a measure in VA (character to numeric)

Re: Converting a category to a measure in VA (character to numeric)

delete rows from a LASR table

Re: swaping missing values

swaping missing values

Re: why repeated observations??

Re: why repeated observations??

why repeated observations??

Re: infinite looping

Re: infinite looping

infinite looping

Re: Swaping observations

Swaping observations

repeated obs

Re: delete rows from a LASR table

Re: delete rows from a LASR table

delete rows from a LASR table

Re: transpose data