About MSK4

MSK4 · ‎09-17-2021

I'm having a dataset A contains 10 crores of records and dataset B contains 1crore records. Both datasets having same properties like variable name,format... I have written code like this proc append base=libname.A data=libname.B force; run; After executing above code getting error aftersome time ERROR ERROR ERROR: ORACLE EXECUTE ERROR :ORA-01653 unable to extend the table tablename by 8129 in table space with the occurence of above error, the error limit of 1 set by ERRLIMIT= option has been Rollback has been issued(AnyRows processed after the last COMMIT are lost) Please help me out. its bit urgent. Many many many thanks..

MSK4 · ‎07-29-2021

Yes, Im connecting to Oracle using pass thru query. Now I got it.

MSK4 · ‎07-29-2021

Is there any option to covert character number date into numeric in pass thru query?

MSK4 · ‎07-29-2021

Even i have used single code. but i'm getting zero records 63 columns For that i have used trim(tran_date)='&dayminus' if i hardcodes like tran_date='20210728' Im getting 3000 records

MSK4 · ‎07-29-2021

Thank you for your answer. But i want t-1 data means yesterday's Where i have created macro variable like %let dayminus =%sysfunc(intnx(day,%sysfunc(date() ),-1),yymmddn8.); It will resolve to 20210728 I have used in where trandate="&dayminus." But throwing error. Any help

MSK4 · ‎07-29-2021

Having columns name amount trandate(in char) sai 400 20210123 goy 500 20210524 .. .. But i want to fetch data for this date 20210524 Please help? Pass thru query only i have written like this where cast(trandate as date)='20210524' Plz help. Thankin advance

MSK4 · ‎07-13-2021

proc sql; connect to oracle as myconn(user=xx pass=xx path=xx); select * from connection to myconn ( select * from tranx where datepart(trandate)=intnx('month',trandate,-3) ); disconnect from myconn; quit; Throwing error invalid intnx identifier Please help me out. Many thanks;

MSK4 · ‎03-19-2021

data have; input name jan feb mar; cards; a 100 200 300 b 100 400 c 100 200 d 500 ; run; Output Required; name jan feb mar concat Total a 100 200 300 janfebmar 600 b 100 400 janmar 500 c 100 200 febmar 300 d 500 mar 500 I tried this i'm getting total. Unable to get concat. Please help me out. Many thanks.

MSK4 · ‎02-22-2021

Space line between span header and header? please check input and output . In output i want empty space line between span header and variable? Please , Thanks in advance.

MSK4 · ‎02-08-2021

"Merged cell" would means only show one cell with the content of Grand total. Please check picture above thank you.

MSK4 · ‎02-07-2021

Here is the image. Arrow 1 represent how to reduce row height by using proc report? Arrow 2 represent how merge three cells and get grand total in merged cell? Please help me . Thanks in advance.

MSK4 · ‎11-22-2020

Suppose I having a table it contains Lakhs of records. I have a variable called salary. I want 10th max and 10th min salary. Salary column having duplicate values. Should not sort the dataset twice.

MSK4 · ‎09-14-2020

yes 3,30,000

MSK4 · ‎09-14-2020

hi team, Here im having 3lakhs 30 k records in dataset i want to divide them equally into n number of datasets. Please looking for code many thanks

MSK4 · ‎09-11-2020

I have tried this but i donna whether it right or wrong. please correct me . data a; a='10dec2019'd; b='10:12:30't; format a date9. b time8.; run; data ab; set a; c=put(a,date9.); d=put(b,time8.); g=input(catx(':',put(a,date9.),put(b,time8.)),datetime20.); format g datetime20.; run;

Online Status	Offline
Date Last Visited	‎11-17-2021 01:22 PM

While appending Dataset I'm getting error.How toresolve that error?

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

How to convert number to date in pass thru query and fetch data partic...

How to get current month and last three months data using pass thru q...

How can i can concatnate Variable according to their values?

I want Empty space line between span header and variable like below ...

Re: How to merge multiple cells in proc report?and How to reduce row h...

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How can i can concatnate Variable according to their values?

Re: How can i can concatnate Variable according to their values?

Re: I want Empty space line between span header and variable like be...

Re: I'm having the value date and time variable but i want dateandtime...

While appending Dataset I'm getting error.How toresolve that error?

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

Re: How to convert number to date in pass thru query and fetch data pa...

How to convert number to date in pass thru query and fetch data partic...

How to get current month and last three months data using pass thru q...

How can i can concatnate Variable according to their values?

I want Empty space line between span header and variable like below ...

Re: How to merge multiple cells in proc report?and How to reduce row h...

How to merge multiple cells in proc report?and How to reduce row heigh...

How can fetch 10th max and 10min records in datastep?

Re: Dividing into number of dataset thatcontais equal number of record...

Dividing into number of dataset thatcontais equal number of records

Re: I'm having the value date and time variable but i want dateandtime...