Hello, I have got a SAS .egp that does a evaluation of data for different cases and then puts this data in one Excel-file with 6 data sheets. Now I have to change the program: so that in the data step where the cases are checked, should the program check if the ID is not in a CSV file (one column with the IDs only). How can I do this? I have already this: proc import datafile="temp.csv"
out=temp
dbms=csv
replace;
getnames=no;
run;
proc print data=work.temp;
run; And now I want to check it with this code: data schritt2; /* this is working correctly */
set data_table; /* contains colums ARBEITSSTUNDENBEZAHLT, PERSONALNUMMER etc. */
if ARBEITSSTUNDENBEZAHLT >400;
/* this is what I added: */
%LET var=PERSONALNUMMER;
proc sql;
select *
from WORK.TEMP
where VAR1 = var;
quit;
/* how to do this? */
if (ergebnis != TRUE);
run; I hope someone could give me a hint. Thanks Sebastian
... View more