Comments by Member 14124697

Member 14124697 1-May-24 11:31am View

this formula wouldn't work since I have bunch of data. around 20000 records and many identifiers so i can't every time change formula for =100+30.

Any other solution?

Member 14124697 24-May-23 6:04am View

thanks....let me try this way

Member 14124697 20-Dec-21 6:40am View

Thank you so much.

Member 14124697 26-Sep-19 5:13am View

Apologies....Please do not get me wrong by my words but this is not the answer of my questions.
I have kept all my data sets at C:/SASUniversityedition/Myfolder path..... so my question is how could i create a library my giving this path and access the data set....

I have done SAS training back in 2017 and that time i could able to create permanent library by writing program from keyword libname.

Since there are several updates in SAS i am not sure if i am writing a query correctly.

Member 14124697 22-Jan-19 7:43am View

Thanks santosh...

I got the answer

Member 14124697 22-Jan-19 7:36am View

Great.....understood clearly...

Thanks ur help every time

Member 14124697 22-Jan-19 7:19am View

Thanks.

Results looks good now with NVL command.

Can you describe me in below query why we used (Column_Name,0) for better understanding.

NVL(M1,0)+NVL(M2,0)

Member 14124697 22-Jan-19 4:28am View

Solution 1 answer not worked in Oracle.

Member 14124697 21-Jan-19 14:02pm View

Thanks.....now this helps me to get my answer...

Many thanks..

Member 14124697 21-Jan-19 12:30pm View

Can you please give me solution for oracle.?

Member 14124697 21-Jan-19 8:42am View

above syntax is not working on ORACLE SQL.

Comments by Member 14124697 (Top 11 by date)