About SunilJ

SunilJ · ‎08-24-2016

Hi, Can you please share, how did you solved it, as i m looking for same thing. Thanks, Sunil

SunilJ · ‎07-28-2015

Hi, Following is oracle query and I am trying to do it in SAS. I did not find any alternative. Can someone please help me in this, I really appreciate. SELECT APPS.*, DENSE_RANK() OVER (PARTITION BY APPS.APP_NBR ORDER BY APPS.V_RANK_DAYS2APP, ABS(V_RANK_DAYS2APP), DECODE(MATCHED_ON,7,1, 5,2, 3,3, 6,4, 1,5, 4,6, 2,7, 9), ROWNUM) AS V_DAYS2APP_RANK FROM APPS Thanks, Sunny

SunilJ · ‎11-21-2014

Perfect, I got it resolved. Thanks for your help. Sunil

SunilJ · ‎11-21-2014

Oh great, but what sas job do i need to write.

SunilJ · ‎11-21-2014

Hi, Code is running on PC server and no batch is involved. I want for entier job. I have only copy of SAS code and log, but i am not authorised to run the code or make any changes in the code to uput option "FILLSTIMER". Thanks

SunilJ · ‎11-21-2014

Hi, I have a model in sas and wondering is there any way we can find Average run time for any sas code/model? Can you please let me know. Thanks, Sunil Jadhav

SunilJ · ‎09-10-2014

Files are created through SAS DI

SunilJ · ‎09-10-2014

Hi Reeza, But all sas code are on servers. Will this search find the file on server as well. Thanks, Sunil

SunilJ · ‎09-10-2014

Hi Ballardw, I am sorry I guess i am not able to frame my question correctly. Data set has associated library. I am able to see that data set in that library. But looking for SAS code where that data set is created. Thanks, Sunil

SunilJ · ‎09-10-2014

Hi Ballarws, I am using windows OS. Regards, Sunil

SunilJ · ‎09-10-2014

Hi Reeza, Actually, I am looking for data set which is created somewhere but dont know how to do backtrack. like where or in which sas code/program it was created. I am sure it was not created by macro. Regards, Sunil

SunilJ · ‎09-10-2014

Hi, I am looking for a table originally created in sas code. I can find out where it is used but not able to find where it is created. Can someone let me know is there any way i can find out where this data set originally created. Thanks Sunil

SunilJ · ‎09-10-2014

Actually, The above code from Nishunk it works. Thanks a lot Sunil Jadhav

SunilJ · ‎09-10-2014

Hi Nishunk, I have one same issue like i am looking for path for a dataset. I dont know where it is located. Even I dont know the library name. Your comment will be very helpful. Thanks, Sunil

Online Status	Offline
Date Last Visited	‎08-31-2016 02:40 PM

Re: Extract filename from path string

dense_rank over (partitioning

Re: How to find run time of any sas code

Re: How to find run time of any sas code

Re: How to find run time of any sas code

How to find run time of any sas code

Re: SAS DataSet

Re: SAS DataSet

Re: SAS DataSet

Re: SAS DataSet

Re: Extract filename from path string

Re: Extract filename from path string

dense_rank over (partitioning

Re: How to find run time of any sas code

Re: How to find run time of any sas code

Re: How to find run time of any sas code

How to find run time of any sas code

Re: SAS DataSet

Re: SAS DataSet

Re: SAS DataSet

Re: SAS DataSet

Re: SAS DataSet

SAS DataSet

Re: How to find dataset path?

Re: How to find dataset path?