yes i have tryed startingly only. Actually i am having a table in that email variable is there now i want to add the new variables in to that cell only i have tryed by semicolon(;),comma(,) ,space like that ... View more

But i want to add the Email in the Table only as this is server for the above i should change it in many things actually in the previously i have added in the table only ,now also i wnat to add in the table only ... View more

1.First load your new file to a dataset 2.proc sql;   select max(date) into :max_date from old_table;   quit; 3. Now you can filter the date if the date is greater than the macro variable:max_date 4.you can append to the existing dataset. ... View more

%MACRO email(SEmailid);   FILENAME mymail EMAIL "NULL"   TO="&SEmailid"     data _null_;     FILE mymail;         END; run; %MEND; OPTIONS MLOGIC MPRINT SYMBOLGEN; data _null_; set MailDset; call symput("V_EMAIL_ID",trim(EMAIL_ID)); run; DATA _NULL_ ;   CALL SYMPUT("SEmailid","&V_EMAIL_ID");   RUN; %email(&SEmailid); We are having a Dataset mailDest in that we have a variable called Email_ID there now we have only one email id now we want to insert 2-3 email ids we have tryed by keeping semicolon,comma(,),space and in code but i am getting error ... View more

Tried semi colon(;) and comma(,) also.... ... View more

%MACRO email(sEmailid);  FILENAME mymail EMAIL "NULL"  TO="&sEmailid"  SUBJECT="&pSubject";  data _null_;    FILE mymail;        END; run; %MEND; I the table i will give the email in the table user1@gmail.com DATA _NULL_ ;  CALL SYMPUT("pEmailid","&EMAIL_ID"); run; I am using DI 4.2 ... View more

proc sql; create table mrg_tst as select AW.* ,AR.AR_ID ,AR.AR_LOCAL_ID from All_WatchList AW left join API5AFS.AR_TRANSLATION AR on AW.ACCT_NO=input(AR.AR_LOCAL_ID, 12.) where AW.ACCT_NO=input(AR.AR_LOCAL_ID,12.) ;quit; Try this ... View more

can u send the log and ERROR your are getting. ... View more

Thqs Ksharp,Art ,Tom for your Good and Quick Responce to me query ... View more

can u do the same code by using infile (the data file path ) with out using the cards and pasting the data ... View more

Hi ksharp i have tryed the code with infile but i am not getting the desired output i should get only 4 rows as enter is there as obs are coming in another rows also can u do the same by using infile statement with out using the cards as in the above example you have used cards and again pasted the observations can u do the same by infile statement please. data l;                                                                                -- infile 'C:\tt.txt'  dsd; length row $ 400;                                                                  - retain row; input;                                                                                                                        - row=cats(row,_infile_);                                                                                                                - if countc(row,'"') ge 20 then do;                                                                                                                                            - put row; call missing(row);                                                                                                                                                            - end; run;                                -- ... View more