About Babloo

Babloo · ‎09-12-2019

Even in your example value of &sysrc has not changed and it is suppose to change after the line number 735 in your log

Babloo · ‎09-12-2019

SYSRC have value as 0 even after the data step has ran with warnings. Value is not changing even &sysrc is placed before,after or in the program. Could you please help me understand with one example?

Babloo · ‎09-12-2019

I ran the code as per your instruction but still I'm getting the return code as 0 for the program which had warning. 2097 %PUT &SYSRC; 0 2098 /*derive operationl metadata*/ 2099 data metadata; 2100 set vars; 2101 /*Solution Component Name derivation*/ 2102 if find("&etls_jobName","_INPUT_",'_') > 0 2103 then SOLN_CMPNT_NM= "DATA IMPORT"; 2104 else if find("&etls_jobName","_EXPORT_") > 0 2105 then SOLN_CMPNT_NM = "DATA EXPORT" ; 2106 else if find("&etls_jobName","_LOA_") > 0 2107 then SOLN_CMPNT_NM = "DATA LOADER" ; 2108 else if find("&etls_jobName","_TRA_") > 0 2109 then SOLN_CMPNT_NM = "DATA TRANSER" ; 2110 else SOLN_CMPNT_NM = "OTHER" ; 2111 /*Job return code*/ 2112 /*%PUT &SYSRC.;*/ 2113 run; WARNING: In a call to the FIND function or routine, the modifier "_" not valid. NOTE: There were 1 observations read from the data set WORK.VARS. NOTE: The data set WORK.METADATA has 1 observations and 10 variables

Babloo · ‎09-12-2019

I would like to capture the status of data step or proc step in one variable. In order to do that first I'm trying to make use of the automatic macro variable &SYSRC. In the below example (see line number 4851), there is a warning and so I would like to see the respective return code instead of 0 (indicates successful run without any warning/error). Am I doing something wrong? 4840 /*Solution Component Name derivation*/ 4841 if find("&etls_jobName","_INPUT_",'_') > 0 4842 then SOLN_CMPNT_NM= "DATA IMPORT"; 4843 else if find("&etls_jobName","_EXPORT_") > 0 4844 then SOLN_CMPNT_NM = "DATA EXPORT" ; 4845 else if find("&etls_jobName","_LOA_") > 0 4846 then SOLN_CMPNT_NM = "DATA LOADER" ; 4847 else if find("&etls_jobName","_TRA_") > 0 4848 then SOLN_CMPNT_NM = "DATA TRANSER" ; 4849 else SOLN_CMPNT_NM = "OTHER" ; 4850 /*Job return code*/ 4851 %PUT &SYSRC.; 0 4852 run; WARNING: In a call to the FIND function or routine, the modifier "_" not valid. NOTE: There were 1 observations read from the data set WORK.VARS. NOTE: The data set WORK.METADATA has 1 observations and 10 variables.

Babloo · ‎09-12-2019

I want to capture the Status of DIS Job in one variable. In order to do that I write the code as below in user written code Transformation and connected it to the previous dataset and removed the mapping. So my DIS Job flow Looks like dataset->table loader->dataset->user written code. STAT_CD="&SYSRC."; So if my Job has warning in any of the Transformation including the user written Transformation, I want to capture the respective return code to the STAT_CD. However it is always showing as '0' even though there is warning in any of the transfomation. How to correct this issue?

Babloo · ‎09-12-2019

It's working If I remove the underscore.

Babloo · ‎09-12-2019

Thanks, now I could get the desired output but also I could see the warning message in the log as below. Could you please tell me how to get rid of this warning? 878 /*Solution Component Name derivation*/ 2879 if find("&etls_jobName","INPUT",'_') > 0 2880 then SOLN_CMPNT_NM= "DATA IMPORT"; 2881 else if find("&etls_jobName","EXPORT",'_') > 0 2882 then SOLN_CMPNT_NM = "DATA EXPORT" ; 2883 else if find("&etls_jobName","LOA",'_') > 0 2884 then SOLN_CMPNT_NM = "DATA LOADER" ; 2885 else if find("&etls_jobName","TRA",'_') > 0 2886 then SOLN_CMPNT_NM = "DATA TRANSER" ; 2887 else SOLN_CMPNT_NM = "OTHER" ; 2888 /*Job return code*/ 2889 %PUT &SYSRC.; 0 2890 run; WARNING: In a call to the FIND function or routine, the modifier "_" not valid. WARNING: In a call to the FIND function or routine, the modifier "_" not valid. WARNING: In a call to the FIND function or routine, the modifier "_" not valid. WARNING: In a call to the FIND function or routine, the modifier "_" not valid.

Babloo · ‎09-12-2019

I ran the code below and got the Output as "DATA TRANSFER" instead of "DATA LOADER" for the variable SOLN_CMPNT_NM

Babloo · ‎09-12-2019

Am I doing something wrong? 26 %macro check_and_do; 27 /*Get the number of obs in macro var N*/ 28 proc sql noprint; 29 create table have as select nobs into :n 30 from sashelp.class; 31 quit; 32 33 %put &=n;/*N is the number of obs in HAVE*/ 34 /*Check if N>0*/ 35 %if &n>0 %then %do; 36 data want; 37 set have; 38 run; 39 %else %do; ERROR: There is no matching %IF statement for the %ELSE. ERROR: A dummy macro will be compiled. 40 /*If n=0 then do the below*/ 41 data want; 42 if 0 then set have; 43 call missing(of _all); 44 output; 45 stop; 46 run; 47 %end; 48 %mend check_and_do; 49 50 %check_and_do WARNING: Apparent invocation of macro CHECK_AND_DO not resolved.

Babloo · ‎09-11-2019

I want to display missing value for a variable only if source dataset has 0 observation. If the source dataset has 1 or more than 1 observations then I want those observation(s) in the output.

Babloo · ‎09-11-2019

May I know for which condition the 'call missing' will execute? I want it to execute only if obs is 0 in the source dataset.

Babloo · ‎09-11-2019

I tried the code as follows and ended up with error. If there is any observation in the dataset then I want to get that value in 'vars' dataset and if no Observation I want to get missing value. 2859 data vars; 2860 if 0 then set dis_entity_id; 2861 call missing(of _all_); 2862 else set dis_entity_id; ____ 160 ERROR 160-185: No matching IF-THEN clause. 2863 output; 2864 stop; 2865 run; NOTE: The SAS System stopped processing this step because of errors.

Babloo · ‎09-11-2019

I tried the code as follows and ended up with error. If there is Observation in the dataset then I want to get that value in 'vars' dataset. 2859 data vars; 2860 if 0 then set dis_entity_id; 2861 call missing(of _all_); 2862 else set dis_entity_id; ____ 160 ERROR 160-185: No matching IF-THEN clause. 2863 output; 2864 stop; 2865 run; NOTE: The SAS System stopped processing this step because of errors.

Babloo · ‎09-11-2019

I tried and it didn't work as I got 0 observation

Babloo · ‎09-11-2019

Appericiate if someone of you help me tweak the code below to create missing value for ENITY_NM (character variable) if there is 0 obersvation in the Input dataset 'dis_entity_id' 752 /*extract and append ENTY_NMs based on Entity_ID*/ 753 754 data reqd_vars (drop=ENTITY_ID); 755 set dis_entity_id end=last_record; 756 by ENTITY_ID; 757 length ENTY_NM $50; 758 retain ENTY_NM; 759 if first.ENTITY_ID then 760 ENTY_NM=catx('/',ENTY_NM,put(ENTITY_ID, $ENTITY.)); 761 if last_record then 762 output; 763 run; NOTE: There were 0 observations read from the data set WORK.DIS_ENTITY_ID. NOTE: The data set WORK.REQD_VARS has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds Desired Output if the source dataset 'dis_entity_id' has 0 bbservation, ENTY_NM " "

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: Understnading for

Re: Understnading for &SYSRC

Re: Understnading for &SYSRC

Understnading for &SYSRC

Re: Different types of job status code for DIS job

Re: If else using find function

Re: If else using find function

Re: If else using find function

Re: Create Observation for a missing value.

Re: If else error

Re: If else error

If else error

Re: Create Observation for a missing value.

Re: Create Observation for a missing value.

Create Observation for a missing value.