hello people, the macro below  does not recognize "myinput1" and it only  throws an output :"The file myinput1 does not exist" why? How can  fix this?  please anyone. Thx   filename myinput1 ftp " 'XYZ.C.M.DATA.XYZZ.G0049V00' " user=** pass=***   host="xyz.com";                                                      %let testfile = myinput1; %macro findit;                                   %if %sysfunc(fileexist(&testfile)) %then %do;   %put good;                                          %end;                                            %else %put The file &testfile does not exist. ; %mend;                                         %findit; ... View more

hello, my SAS exports a  file temp.csv to UNIX----->> /folder1/folder2/folder3/temp.csv and most  of the time  i forget to  give ppl permission to it  which i do it  in  unix:) Is there a  way the access could be  granted in SAS before  exporting the  file to  UNIX?   Thanks ... View more

hi, i was given a  sas dataset to use and i noitced  it has some weird values in some of the  fields for exmple an email field with values starting from any position email tom@yahoo.com      miki@yahoo.com  mia@yahoo.com ..... ....... Tried left,compress,strip... nothing is  fixing this but also i noticed a  note in the log saying: NOTE: Data file xx.FINAL12.DATA is in a format that is native to another host, or the file encoding does not match       the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might       reduce performance.   how can this be  fixed?   thx Tal ... View more

hi, lastname and  firstname have missing values also include a lot of characters such as: ? [ ] | : ( ) '    . -  and i need to compress  them i know #1 wont do what i need  but i did run it out of curousity and got: #1 Table Y_TMI.TMI_KILL created, with 500475 rows and 7 columns.   #2 and #3   would do what i need but i am getting  different  results: #2 Table Y_TMI.TMI_KILL created, with 500058 rows and 7 columns. #3 Table Y_TMI.TMI_KILL created, with 500100 rows and 7 columns.   1.What is causing the  different  results in the 3 runs? 2.If i am to chose between #2 and #3 which one seems  to be more accurate ?   anyone  please? thx proc sql; create table y_tmi.tmi_kill as select distinct  compress(dg.EmailAdd) as EmailAdd,        /*#1*/  /*cats(upcase(strip(compress(dg.FirstName))), upcase(strip(compress(dg.LastName))), dg.dob,strip(POSTALCODE)) as NameDOBpostal,*/       /*#2*/ /*cats(upcase(strip(compress(dg.FirstName,,"ka"))), upcase(strip(compress(dg.LastName,,"ka"))), dg.dob,strip(POSTALCODE)) as NameDOBpostal,*/       /*#3*/  /*cats(upcase(strip(compress(dg.FirstName,"?[]|:()'.- "))), upcase(strip(compress(dg.LastName,"?[]|:()'.- "))), dg.dob,strip(POSTALCODE)) as NameDOBpostal,  from y_tmi.tmi_data_growth dg  left join y_cus.ALLIANZ a  on a.CUSTNUM = dg.CustNum  left join (select matchkey, contactid from y_cus.gi union select matchkey, contactid from y_cus.gi_driver) gi  on a.matchkey = gi.matchkey  left join y_gi.gi_contactid_xref xref  on gi.contactid = xref.cd_contact_id; quit; run;       ... View more