About anirudhs

anirudhs · ‎03-13-2018

No sir, when i will hit the run in EG to run the code for importing the .xlsx file then at that time if the xlsx file in the derictory has modified date/time then it should import. If it finds the last run time/date then it should not run ..it should terminate with msg : old file.

anirudhs · ‎03-13-2018

no im not dropping any column, i just looking alternate way in query builder for dynamic structure. Yes i know this can be done by putting the date column ..but the dataset size will increase on daily basis vertically .... as the records are around 40lakhs while when you increase the data set horizontally then the no. of observation remains the same. only variable increases.

anirudhs · ‎03-13-2018

Hi i am looking for some of the following creating of the new columns in query builder tagged with the dd from todays date. As this column will be created after the join. e.g. dataset1 column name: x_12,y_12,z_12 *Note : dataset1 is of 12th march 2018 new data set Dataset2: x_12,y_12,z_12,x_13,y_13,z_13 *Note: dataset2 contains columns names of 13th march2018.

anirudhs · ‎03-13-2018

i dont want the last record by date or time .... i want to read the file only when it is modified where the windows updates the date and time when the file is modified ..so if the file is not modified then it should not read it.

anirudhs · ‎03-12-2018

Yes im on windows and surely i will try for the same.

anirudhs · ‎03-12-2018

i want to read .xlsx file with latest modified time.

anirudhs · ‎03-12-2018

Hi looking for code which can check for the latest file based on its created date and time, if it find latest file then it should execute the process flow. Hint: the file can be of any sas readable format. eg. if a.xlx was last modified/created Today's date at 3:13 pm then it should import and execute. if not updated then ...it should terminate the execution.

anirudhs · ‎02-26-2018

Thanks a lot for the code, missed the simple understanding in hurry.

anirudhs · ‎02-26-2018

Sorry for start date the month should be the next month.i.e. if end date=28feb2018 then start date should be 5march2018

anirudhs · ‎02-26-2018

Hi , I am looking for auto date fetching; e.g start date='05feb2018'd i want to fetch auto date for every next month i.e. 5th day of every month should be the start date. .eg. for next month when the program is auto run it should fetch the start date as 5th day of next month. Similarly end date should be last day of every current month. e.g end_date='28thfeb2018'd for feb ...for march it should fetch the last date e.g. end_date='31March2018'. Also let me know how can we code it in EG using the query builder. Thanks

anirudhs · ‎02-19-2018

Hi this is not what i am looking for as i am not looking for data lock to dataset.. i am looking for row level security where the specified user can access only the data through the given condition as which is managed in VA . the same way using the code. where you have to pass the condition for users with their user id using the excel in enterprise guide.

anirudhs · ‎02-19-2018

Need a code to implement the row level security to a dataset in enterprise guide. please also let me know the what columns should the excel contain with the condition. Thanks

anirudhs · ‎02-16-2018

Hello , can anyone help in using of nodupkey by id in sas eg query builder please need it very fast.

anirudhs · ‎02-16-2018

sorry for this ... yes i want on the base of datetime values.

anirudhs · ‎02-15-2018

Hi I want the following records in the data set . CASE_ID,Activity_Creator,Decisioned_By,comment,Suspect_Reason,Agency_Date 25412,RAPID INVESTIGATION SERVICES,Agency,CREDIT REFER,06FEB2018:15:35:14.00 14284,SHARP EAGLE INVESTIGATION PVT LTD,Agency,VERIFICATION OF SALARY SLIP,01NOV2017:15:40:11.00 As these are eg ... but the logic should work on multiple observations.. from which i should get the latest of the grouped dates.

Online Status	Offline
Date Last Visited	‎04-25-2022 04:45 AM

Re: How to handle date in sas while using passthrough from oracle

Re: How to handle date in sas while using passthrough from oracle

Re: How to handle date in sas while using passthrough from oracle

How to handle date in sas while using passthrough from oracle

Re: want to convert date

Re: want to convert date

want to convert date

Re: Proc report not working

Re: Proc report not working

Re: Proc report not working

Re: want to convert date

Re: Flaging the latest date

Re: excel processing taking long time

Re: BASE SAS

Oracle stored procedure call from SAS

loading data set to LASR using code

Re: check for the latest file while run

Re: new column creation with date.

new column creation with date.

Re: check for the latest file while run

Re: check for the latest file while run

Re: check for the latest file while run

check for the latest file while run

Re: auto fetching of dates

Re: auto fetching of dates

auto fetching of dates

Re: code to implement row level security to data set using enterprise...

code to implement row level security to data set using enterprise gui...

How to use nodupkey in query builder

Re: How to flag the latest date or use group by

Re: Flaging the latest date

SAS Analytics Explorers