I have a Dataset TEST which has below variables Send, X, Y, C State . Need to calculate how many values are populated and what percentage of values populated for each variable  when Send = Y and Sender =. by State  TEST  Send X Y C State Y 1 . 100 AL Y 2 . 28 AL Y . . 56 AL . . . 55 AL . . . 77 AL . . . 30 AL Y 10 25 44 PA Y 20 32 89 PA Y 30 43 78 PA . 40 27 43 PA . . 10 22 PA . . . 34 PA   Output should be something like    State = AL         Send=Y Send=. Send=Y Send=. Total Records   Count Count Percentage Percentage   X 2 4 33.33 66.66 6 Y 0 0 0 0 6 C 3 3 50 50 6   Similarly for PA calculate the count of records populated and percentage of records populated when Send = Y and send =. for each variable by State    Can anyone please help ? ... View more

Hi All, I get below error when I try update dataset in spde server Error : The file is locked by another user Error : Requested lock is not available for data set Libname stest spde ‘path’; Libname mlib ‘path’; proc append base = stest.cards (asyncindex= yes partsize=100) data= mlib.cards force; run; Can anyone please help . ... View more

I have a SAS dataset TEST and i wanted to update st_nm_des column where the description is missing on a specific date 16JAN2018. MD- Maryland and DE - Delaware   date state st_nm_des 15JAN2018 AL ALABAMA 16JAN2018 MD   16JAN2018 DE   17JAN2018 CT Connecticut 18JAN2018 FL Florida 19JAN2018 ID Idaho 20JAN2018 ME Maine   Can anyone please help ... View more

Hi , I have  a dataset  X which has these columns Apple1, Apple2, Orange1, Orange2. Another Dataset Y which looks like below in Dataset Y I have taken list of items I need to check in Data X whether they exist or not . Also, while checking when Apple1 is existing Orange1 should also exist in X dataset . Same thing when Apple2 is existing then Orange2 should also exist then only create output . I am using below code by using prxmatch but it doesnot work   test1 test2 Apple1 Orange1 Apple2 Orange2   proc contents data= X noprint out= GTAB (keep=name varnum); run;   Then created Y table which looks like below test1 test2 Apple1 Orange1 Apple2 Orange2   data _null_; set Y; call symput('wrd1'||left(_n_), strip(test1)); call symput('wrd2'||left(_n_), strip(test2)); CALL SYMPUT( 'Total' , _N_ ); run;   %MACRO LOOP;   data temp2; set  X ; %do i=1 %to &Total; if (prxmatch("/&&wrd1&i./",NAME) gt 0 and prxmatch("/&&wrd2&i./",NAME) gt 0) then output ; %end;   run; %mend;   %loop;   But this condition is not working and dataset temp2 is empty   Can anyone please help   Thanks       ... View more