hi , it seems your '/' is a issue for path : folders/myfolders\calculator.csv" dsd dlm=',' firstobs=2; try this : folders\myfolders \ calculator.csv" dsd dlm=',' firstobs=2;
... View more
data have; infile datalines truncover; input id $ var1 $ var2 $ var3 $; datalines; 1 . A A 2 A A A 3 A . B 4 . A B 5 A B C 6 A A . ; run; data want; set have; array x {3} var1 var2 var3 ; do i= 1 to 1; if i ne . then do; if x{i} ne x{i+1} ne x{i+2} then output; end;end; run; you might modify it as per the amount of variables you have to check .
... View more
data vars; if 0 then set dis_entity_id; else set dis_entiti_id; call missing(of _all_); output; stop; run; this should work fine . if and else statement shall come together .
... View more