Hello, It's what I did but still not solve the problem!   Thanks!   if 0 then set class cities;  keep Name Sex Age Persona Department;  if _n_ = 1 then do; declare Hash Match1 (dataset:'class');  ... View more

I put a keep just after If 0 (I dont know if it is that you mean by Set reading statment)   but still processing all the variables in PVD (please see log below) Code : if 0 then set class cities;  keep Name Sex Age Persona Department;  if _n_ = 1 then do; declare Hash Match1 (dataset:'class');     Match1.DefineKey ('Name');   Match1.DefineData ('Name','Sex','Age');   Match1.DefineDone ();   end;    set cities ;   if Match1.find(key:Persona) = 0 then output;  PUT _ALL_; run;   log : NOTE: There were 5 observations read from the data set WORK.CLASS. Name=Alice Sex=F Age=13 Height=. Weight=. zipcode=75008 City=Paris 8è Department=Paris Persona=Alice _ERROR_=0 _N_=1 Name=Carol Sex=F Age=14 Height=. Weight=. zipcode=91940 City=Les Ulis Department=Essonne Persona=Carol _ERROR_=0 _N_=2 Name=Henry Sex=M Age=14 Height=. Weight=. zipcode=92330 City=Sceaux Department=Hauts-de-Seine Persona=Henry _ERROR_=0 _N_=3 Name=Henry Sex=M Age=14 Height=. Weight=. zipcode=93140 City=Bondy Department=Seine-Saint-Denis Persona=Henry _ERROR_=0 _N_=4 Name=Alice Sex=F Age=13 Height=. Weight=. zipcode=94150 City=Rungis Department=Val-de-Marne Persona=Alice _ERROR_=0 _N_=5 data Set1;   Thanks ... View more

In this case it will be process in PDV, but I want to avoid that for efficiency because my data are very big!   Thanks ... View more

Hello,   In fact, in my output I just want de keep Name Sex Age and department and not (zipcode, City, Persona)  I dont even want that the variables (zipcode, City, Persona)  went to PVD   Thanks ... View more

Here is an example :   data class; input Name$ Sex$ Age Height Weight; infile datalines dlm=' ' dsd; datalines; Alfred M 14 69.0 112.5 Alice F 13 56.5 84.0 Barbara F 13 65.3 98.0 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 ;     data cities; input zipcode City :$30. Department :$30. Persona:$10.; infile datalines dlm=',' dsd; datalines; 75008, Paris 8è ,Paris,Alice 91940, Les Ulis, Essonne,Carol 92330,Sceaux, Hauts-de-Seine,Henry 93140, Bondy , Seine-Saint-Denis,Henry 94150, Rungis, Val-de-Marne,Alice ;   data Set1 ; if 0 then set class cities;     if _n_ = 1 then do; declare Hash Match1 (dataset:'class');     Match1.DefineKey ('Name');   Match1.DefineData ('Name','Sex','Age');   Match1.DefineDone ();   end;    set cities; if Match1.find(key:Persona) = 0 then output;    run; What I want is an output set that contains Name Sex Age Department! I can do it with (keep=Name Sex Age Department), but I dont want to process this variables! Thanks ... View more

Thanks! ... View more

Thanks! ... View more

What I need is this:     If it's positiv its empty   Thanks! ... View more

SAS 9.4 Macro Language: Reference, Fifth Edition   Sas Guide to Macro Processing : No links  ... View more

Thanks!   I use the note but still have the same problem:     1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 Filename filelist pipe "dir /b /s /home/ssafini0/TestRisk"; ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement. 70 71 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 81 ... View more