records.dat have 5000 records, but my main_set dataset have only 4999 records. Not able to figure out what is wrong with this. any pointers would be of great help!   Data main_set; infile "records.dat" dlm='|' dsd truncover; input id : $10. name : $25. ; run; ... View more

Have 2 datasets Old & New, Old have some location id with its details field, the new list have location id only details field will be blank.   Dataset New :- Location id    Area    Phone 1234 2345 1233 5543 Dataset Old :- Location id   Area     Phone 1234            NYC     55555 2345             ABC     77777   Output Dataset Expected: Location id Area Phone 1234 NYC 55555 2345 ABC 77777 1233 5543   Code written:- proc sort data=New nodupkey;by merchant_market_hierarchy_id; proc sort data=Old nodupkey;by merchant_market_hierarchy_id;   data New; merge New(in=ln) Old(in=lo); by location_id; if ln;   My output is not as expected.  What am i doing wrong here? would require some help on this please! ... View more

I need help with the below code snippet.   data A dup; set B;  /* Sorted dataset by id update_dt updt_code*/ by id update_dt updt_code; if first.id and last.updt_code then output A; else output dup; run; Data B: id     Update_dt   updt_code 123 14/02/2017   3 123 14/02/2017   3 123 14/02/2017   6 Required Data A: id     Update_dt   updt_code 123  14/02/2017   3 123  14/02/2017   6 ... View more

I am exporting a variable called _call_list from unix to SAS.   In unix , export _call_list=${_call_list}   In SAS, %global call_list; %let call_list=%SYSGET(_call_list); %put SEE THE value of call_list is &call_list. ;   In Log:-   MLOGIC(GET_VARS): %LET (variable name is CALL_LIST) WARNING: The argument to macro function %SYSGET is not defined as a system variable.     I did some research on this error:-   http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a000543699.htm   my query is how do we define a variable on the operating environment. Any pointers please? ... View more

Country used to come in this format - ARG   %if (&&cntry_cd&i = ARG) or %eval(&&cntry_cd&i. IN &list.) %then %do; %do a = 0 %to 9; %str(execute(DROP TABLE abc PURGE) by hadoop;); %end; %end; %else %str(execute(DROP TABLE abcd PURGE) by hadoop;);   New Country format - 'ARG'   %if (%bquote(&qctry. = %str(%')ARG%str(%')) or %eval(%bquote(&qctry.) IN &list.) %then %do; %do a = 0 %to 9; %str(execute(DROP TABLE abc PURGE) by hadoop;); %end; %end; %else %str(execute(DROP TABLE abcd PURGE) by hadoop;); ERROR MESSAGE: ERROR: Macro keyword DO appears as text. ERROR: A dummy macro will be compiled. ERROR: Macro keyword DO appears as text. ERROR: Macro keyword END appears as text. ERROR: Macro keyword END appears as text. ERROR: There is no matching %IF statement for the %ELSE.   I am not sure why am i getting this error, i am trying to mask the quotes as per the new country format. ... View more

Hi all,   I am stuck with a small issue in PROC SQL. I have to fetch from a flat file & use that string in a sql query but the items in the list are strings so during the fetch i need to fetch it with quotes to use it in oracle. Any Help would be much appretiated.   Thanks!   CODE.txt AAA AAB AAC   filename colcode "/xyz/CODE.txt";run;   data col_code; infile colcode; length col_code $3.; input col_code $; run;   proc sql noprint; select (trim(left(col_code))) into:collist separated by ', ' from col_code;run; %put Colleage LIST IS: &collist ;   Current Output:- Colleage LIST IS: AAA, AAB, AAC   Required Output:- Colleage LIST IS: 'AAA', 'AAB', 'AAC'   I am using that &collist in a where condition in one sql run on oracle in later stages.! ... View more