About bollurajkumar

Kurt_Bremser · ‎05-22-2021

Try renaming: proc datasets library=yourlib; modify yourdata; rename ab=ac ac=ab ; quit;

ScottBass · ‎07-04-2019

I'll bite...why are you storing numeric data as character text? I suspect that's how your data is now, or how it is provided to you. But IMO if you stored or converted your text data to numeric, then used formats for display, reporting, etc., life would be easier.

novinosrin · ‎12-05-2018

And more fun: data have; input A $ B; datalines; World 25 India 30 USA 40 Pak 70 ; proc sql; create table want as select a, ifn(monotonic()=1,sum(b),b) as b from have order by monotonic(); quit;

kiranv_ · ‎12-02-2018

you can use dictionary.tables as suggested by @Reeza. crdate is create date. use your libname instead of sashelp proc sql; select memname, crdate from dictionary.tables where upcase(libname) ='SASHELP' order by crdate desc;

Kurt_Bremser · ‎09-29-2018

Read separately, and concatenate: data abc; infile datalines dlm='@'; input name :$10. mail :$64. _mail :$32. age; mail = catx('@',mail,_mail); drop _mail; datalines; abc@mas@gmail.com@12 Absh@auuaa@gmail.com@17 asaks@ajhsjk@gmail.com@18 ; run; Note that using formats without a colon overrides the delimiters. PS use proper subjects. "base sas" is much too unspecific.

LinusH · ‎11-20-2017

DI Studio specifics: temporarily change from views to tables as output in transformations, otherwise it's hard to understand what step(s) causes the high resource consumption.

bollurajkumar · ‎04-28-2017

@RW9 I got correct answer for your code thanks for spending your time on this question thanx Rajkumar

Astounding · ‎04-25-2017

It's the logic of DO WHILE. After the first time through the loop a single zero has been added: 0123 The DO WHILE condition is still true, since the length is now 4. So the loop executes a second time, adding another zero: 00123 Now the DO WHILE condition is false, so the loop ends.

bollurajkumar · ‎04-28-2017

@RW9 I got correct answer for your code thanks for spending your time on this question thanx Rajkumar

bollurajkumar · ‎04-21-2017

Hi I want exclude holidays from a holidays list(dataset) if it is possible Kindly explain

Online Status	Offline
Date Last Visited	‎05-22-2021 08:01 AM

How to swap two variables

Re: Removing decimals places in SAS

Add total to first row

Find number of datasets in sas

Reading email addresses with @ as delimiter

Re: Performance tuning techniques

Performance tuning techniques

Re: sas eg

Re: sas eg

Re: Date difference in days excluding holidays

Re: Date difference in days excluding holidays

Re: How to swap two variables

Re: Removing decimals places in SAS

Re: Add total to first row

Re: Find number of datasets in sas

Re: Reading email addresses with @ as delimiter

Re: Performance tuning techniques

Re: sas eg

Re: Adding zeros in front of values

Re: sas eg

Re: Date difference in days excluding holidays and sundays..