About Babloo

Babloo · ‎09-09-2019

Format which you provided is OK to some extend but I'm not seeing the right value in hh:mm. Value which I got in the Output is 09.09.2019 010:0 instead of 09.09.2019 10:50. Please see the log below 1889 proc format; 1890 picture dtfmt (default=16) 1891 low - high = '0%d.0%m.%Y 0%H:0%M' (datatype=datetime) 1892 ; NOTE: Format DTFMT is already on the library WORK.FORMATS. NOTE: Format DTFMT has been output. 1893 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 1894 data metadata; 1895 %let etls_stepStartTime = %sysfunc(datetime(), datetime17.); 1896 %put %str(NOTE: &etls_stepStartTime.); NOTE: 09SEP19:10:50:17 1897 SCHDLD_OBJ_RUN_STRT_TMST=%sysfunc(inputn("&etls_stepStartTime",datetime17.)); 1898 format SCHDLD_OBJ_RUN_STRT_TMST dtfmt.;; 1899 run;

Babloo · ‎09-09-2019

Thank you! If datetime is character variable, then how will you deal with it? Just apply input function?

Babloo · ‎09-09-2019

Is there a way that we can convert the datetime value 20MAY19:09:11:54 to like this 20.05.2019 09:11? I'm not finding any SAS datetime format which format like 20.05.2019 09:11.

Babloo · ‎09-08-2019

Assume my jobs are located in /var/data/life/myjob /var/data/nonlife/myjob Now I want to create one new variable called DOMAIN which should say which domain DIS job belongs to. In my example life and nonlife is domain and so the new variable DOMAIN should have those values. My question is how to find values for new variable from the DIS job folder?

Babloo · ‎09-08-2019

I have to extract variable value from the DIS job folder and I would like to know where the folder details are stored apart from the properties of the job. If it not stored any where apart from properties, how can I extract value from that?

Babloo · ‎09-06-2019

I'm trying to implement the things in precode and postcode with the use of macros. Again how and where can I store the values of macros without creating datasets. Once I have this information in SAS, I have to feed the values in SQL table. Also could you please tell me where can I find the transformation return code in DI job?

Babloo · ‎09-06-2019

Could you please tell me how can I achieve the objective only via DI? Because I do not have access to other softwares like Environment manager, Management console....

Babloo · ‎09-06-2019

It is pointing to the folder where it is not accessible. I wonder if that folder exists.

Babloo · ‎09-06-2019

I'm trying to resolve the error as mentioned below but I'm unable to do it. SCHDLD_OBJ_NM is the variable which I'm creating in the same datastep where I placed the below if condition and I was asked to achieve this one single step. 4219 if SCHDLD_OBJ_NM like %"_AP_"% then FNCTL_CMPNT_NM="AP" else "LIS"; ____ ____ 388 388 202 202 ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored. 4220 run;

Babloo · ‎09-06-2019

I've created the WORK datasets under precode and postcode and I would like to see how the data was populated. However I'm unable to figure out where this dataset is physically located in DI studio 4.9. If I see the physical storage of other WORK datasets which was created as part of other transformation e.g. Extract, Sort...I could see as 'Job's default library for temporary tables' under Location. Is there a way that we can find the location without any support from SAS admin?

Babloo · ‎09-06-2019

I want to track the SAS job name which was executed, job start time, job end time, job folder location and job status after the execution of every job in SAS DI 4.9. Is there any table which automatically pulls this details for every job? If yes, I can pull those information via SAS code which I can place in 'post code' section Objective is to get these details from SAS and insert it into the SQL table.

Babloo · ‎09-03-2019

May I know how can I create the look up table?

Babloo · ‎09-02-2019

Yes, I want to apply the format to convert the values of Entity_ID to some other text. Yes, I want to query the external database. Below example is the data which I have in external database (sql server) as a table.Right now I have the variable in SAS with old_entity_id and I want to convert it into new_entity_id E.g. New_Entity_id Old_entity_id 1234 12345 6789 67890

Babloo · ‎09-02-2019

There is a variable called Entity_Id in SAS dataset and for that variable I have to apply the format where the format is located in the SQL table. I don't want to create the SAS dataset of that SQL table. How can I apply the format from SQL to SAS?

Babloo · ‎08-28-2019

I got it. Could you please tell me how will you optimize the code below to update the permanent table? I'm trying to do optimize the above second step as follows, but I couldn't succeed as I'm not certain how to set the values in INSURANCE_CONTRACT_GROUP_ID I've 16 columns in IFRSLDIS.INSURANCE_CASHFLOW and therefore I should have same columns in the final result with updated values for INSURANCE_CONTRACT_GROUP_ID

Online Status	Offline
Date Last Visited	‎06-03-2024 06:10 PM

SQL help on transpose logic

Re: Unexpected select error in Update statement

Re: Unexpected select error in Update statement

Unexpected select error in Update statement

Update statement based on Join condition not working

Select top 1 record based on conditions

Re: Substr with max function

Re: Substr with max function

Re: Substr with max function

Substr with max function

Re: Unexpected select error in Update statement

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Case when to handle blank and NULL values

datetime format for dd.mm.yyyy hh:mm?

Re: datetime format for dd.mm.yyyy hh:mm?

Re: Error in Macro Variable

SAS 9.4 installation documents

Understanding of code submission to Grid nodes

Re: datetime format for dd.mm.yyyy hh:mm?

Re: datetime format for dd.mm.yyyy hh:mm?

datetime format for dd.mm.yyyy hh:mm?

Re: SAS DI Job tracking details

Re: SAS DI Job tracking details

Re: SAS DI Job tracking details

Re: SAS DI Job tracking details

Re: How to find the physical storage of WORK dataset which was created...

Error using LIKE operator

How to find the physical storage of WORK dataset which was created und...

SAS DI Job tracking details

Re: User defined format from reference SQL table

Re: User defined format from reference SQL table

User defined format from reference SQL table

Re: Update table in proc sql