About anirudhs

anirudhs · ‎04-03-2018

yes even if i apply distinct then i am getting the following output: Identifier_LHS MAX_of_Date_Loaded_LHS Status_LHS Work_Status_LHS MAX_of_MAX_of_Version 153553 24MAR18:18:31:58 Clear Unworked 1 153553 24MAR18:18:32:16 Clear Unworked 2 153553 24MAR18:18:32:17 Clear Unworked 3 153553 24MAR18:18:32:20 Clear Worked 4 14297488 27FEB18:16:56:53 Suspect Worked 2 14297488 28MAR18:16:39:42 Suspect Unworked 3

anirudhs · ‎04-03-2018

@Reeza : Your macro code also is giving error, mentioned NOTE: PROCEDURE EXPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: Apparent symbolic reference WORK not resolved. NOTE: The SAS System stopped processing this step because of errors. NOTE: Line generated by the CALL EXECUTE routine. 90 + proc export data=&WORK.DAC_3 (where=(city="ZIRAKPUR")) outfile="\\10.4.1.205\Upload\DAC_FINAL_ZIRAKPUR.xlsx" dbms=xlsx _ 22 76 90 !+replace; run;; ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored.

anirudhs · ‎04-03-2018

This code for export works fine: proc export data=WORK.DAC_3 (where=(City='MUMBAI')) dbms=xlsx outfile="\\10.4.1.205\Upload\DAC_FINAL_MUMBAI.xlsx" replace; run;

anirudhs · ‎04-03-2018

Extremely sorry to update you @Tom the code you send is working but it is exporting the xlsx city but those excel contains data of all the cities, requirement is that the excel should only contain data with the city names. i.e. if data set contains 500 records of city pune then the excel DAC_Final_Pune.xlsx will have those 500 records from the data set only.

anirudhs · ‎04-03-2018

Yeh found it, and is running but taking too long time to execute.

anirudhs · ‎04-03-2018

Thanks ... worked.

anirudhs · ‎04-03-2018

Hey, I am exploring for code to calculate the the total no of working days in a month excluding sundays only. i.e start date should be 1st date of every month and the end date should be last day of every month and calculate net working days in the current month. As the code should fetch the current month and calculate accordingly. Thanks

anirudhs · ‎04-03-2018

@Tom getting following errors for all cities when testing your code : NOTE: Line generated by the CALL EXECUTE routine. 89 + data=WORK.DAC_3 dbms=xlsx outfile= "\\10.4.1.205\Upload\DAC_FINAL_YAMUNANAGAR.xlsx" replace; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order.

anirudhs · ‎04-03-2018

this is the following error i am getting when used the code you have mentioned WARNING: Apparent symbolic reference WORK not resolved. NOTE: The SAS System stopped processing this step because of errors. NOTE: Line generated by the CALL EXECUTE routine. 1 + proc export data=&WORK.DAC_3 (where=(city='&city')) outfile="\\10.4.1.205\Upload\DAC_AGRA.xlsx" dbms=xlsx replace; run;; _ 22 76 ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored. please update..

anirudhs · ‎04-02-2018

Identifier_LHS Date_Loaded_LHS Status_LHS Work_Status_LHS MAX_of_Version Calculation 153553 24MAR18:18:32:16 Clear Unworked 4 1 153553 24MAR18:18:32:20 Clear Worked 4 1 153553 24MAR18:18:32:17 Clear Unworked 4 1 153553 24MAR18:18:31:58 Clear Unworked 4 1 153553 24MAR18:18:32:20 Clear Worked 4 1 153553 24MAR18:18:32:17 Clear Unworked 4 1 153553 24MAR18:18:32:16 Clear Unworked 4 1 153553 24MAR18:18:31:58 Clear Unworked 4 1 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 27FEB18:16:56:53 Suspect Worked 4 1 14297488 28MAR18:16:39:42 Suspect Unworked 4 0 want to fetch the latest record with latest date and version is greater max. but there are cases like record highlighted in blue where the date and time are the same. so after using the max function for date and version it dose not work.

anirudhs · ‎04-02-2018

no the status can vary ...to be unworked,clear,worked,etc.

anirudhs · ‎04-02-2018

Hi I Am looking for the highlighted data to be extracted for the following data Identifier_LHS MAX_of_Date_Loaded_LHS Status_LHS Work_Status_LHS MAX_of_MAX_of_Version 153553 24MAR18:18:31:58 Clear Unworked 1 153553 24MAR18:18:32:16 Clear Unworked 2 153553 24MAR18:18:32:17 Clear Unworked 3 153553 24MAR18:18:32:20 Clear Worked 4 14297488 27FEB18:16:56:53 Suspect Worked 2 14297488 28MAR18:16:39:42 Suspect Unworked 3 Tried using the max of date and max of version ...but not getting the desired o/p

anirudhs · ‎03-28-2018

I will try and test both the codes, but i would like to say that the data set contains round about 3 lakhs rows of data with recuring of city names with minimum of 5000 rows. SO i will update once i test both the code. Thanks

anirudhs · ‎03-28-2018

yes i want new work book for each city. but the code and condition is to be written 126 times... is that fisible ???? to write the proc export code 126 times by just changing the city name in each occurrence of export code

anirudhs · ‎03-28-2018

Hi , I am looking for a macro code as i have a variable name city and that variable contains 126 names of unique cities, and want to export the same data set into excel with condition where city='xyz' and the excel should contain the name of the same city which is used in the condition. As using the following code for 126 unique cities is not affordable. e.g.: proc export data=WORK.CAPFIRST_ENCOLLEC_MASTER (where=(City='PUNE')) dbms=xlsx outfile="\\10.4.1.205\Upload\DAC_FINAL_PUNE.xlsx" replace; run; So looking for macro and looping to export using that macro.

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: Extraction of data

Re: Macro code to export in excel

Re: Macro code to export in excel

Re: Macro code to export in excel

Re: Macro code to export in excel

Re: exploring code to calculate working days

exploring code to calculate working days

Re: Macro code to export in excel

Re: Macro code to export in excel

Re: Extraction of data

Re: Extraction of data

Extraction of data

Re: Macro code to export in excel

Re: Macro code to export in excel

Macro code to export in excel

SAS Analytics Explorers