About jaiganesh

jaiganesh · ‎03-08-2019

Hello, In one of the interview, I've been asked below question, I would appreciate if someone would dignify with Answer. "SAS has requested first 100 observations from Database using pass through , However only 90 has come out , Now from where we can begin the investigation" ? I think we can run the trace ? if yes what is the process for it ? Regards, Jai

jaiganesh · ‎03-04-2019

I'm looking for the best approach to nail this down, Can you suggest any other approach. Regards, Jai

jaiganesh · ‎03-04-2019

TAGSORT can't be use, As we have only 600GB of Space with 500GB of data, TAGSORT would also consume Disk, However less space than normal sort, though it is not efficient option to use when we have only 100 GB disk spare for 500 GB Table. We have to figure out other options. Regards, Jai

jaiganesh · ‎03-04-2019

Hello All, I've encountered with below question in one of the interview, Could anyone please help me to nail this down. "What is the preferred way / Approach to SORT the dataset which having the size of 500GB residing in Total Disk Size is 600GB ?". Regards, Jai

jaiganesh · ‎02-27-2019

Thanks a lot for you time and effort. Regards, Jaiganesh

jaiganesh · ‎02-27-2019

Mentioned Link does not help me much with respect to certain with LAG Function cumulative addition. Can you provide anything else

jaiganesh · ‎02-27-2019

I've been using Retain Keyword, one of my colleague has raise the concern of LAG function functionality and it's application in programming, Let me know if you need any other information.

jaiganesh · ‎02-27-2019

Hello, Can anybody help me to create the code which make the cumulative sum for the variable Marks used in below data set with LAG Keyword/Function. Input: data kk; input id names$ marks; cards; 1 jai 10 2 sai 20 3 ram 30 4 shyam 40 5 hari 50 ; run; output Should be id names marks New_marks 1 jai 10 10 2 sai 20 30 3 ram 30 60 4 shyam 40 100 5 hari 50 150 Please provide the output only with using LAG function not Looking with Retain Keyword. Regards, Jaiganesh

jaiganesh · ‎02-22-2019

Let me read about the MD5 or various SHA hashing functions.

jaiganesh · ‎02-19-2019

Thanks , Let me go through the pdfs you provided and i will let you know, if anything more i need to know / require.

jaiganesh · ‎02-19-2019

This question has been asked to me in one of the tough SAS interview.

jaiganesh · ‎02-18-2019

Hello, Can anyone would help me with below concern. "What is hashing algorithm in SAS?" , Can anyone explain with example. Regards, Jai

jaiganesh · ‎02-18-2019

Hello, Can anybody help me with below concern. "What is parallel processing with Jobs in SAS ?", can anyone explain with example. Regards, Jai

jaiganesh · ‎02-08-2019

Hello, I'm a learner of SAS. Can you please provide the data set you used for explaining this both examples. Regards, Jaiganesh

jaiganesh · ‎02-04-2019

Hello, I went through the %include concept. Can anybody please give small executable code of %include with external File. Regards, Jai

Online Status	Offline
Date Last Visited	‎12-17-2019 02:25 PM

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Re: Accessing windows file list from drive

Accessing windows file list from drive

Re: SQL connection from SAS

SQL connection from SAS

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SAS Program

Re: SQL connection from SAS

Re: variable date to week

Re: Missing Entries

Re: Missing Entries

Re: LAG Function

Missing Entries

Re: Sorting

Re: Sorting

Sorting

Re: LAG Function

Re: LAG Function

Re: LAG Function

LAG Function

Re: SAS hashing algorithm

Re: SAS Parallel processing

Re: SAS hashing algorithm

SAS hashing algorithm

SAS Parallel processing

Re: Differences between Proc Report and Proc Tabulate

Macro