Hi all, how can the below be achieved          data have; input Code1 :$20. Group :$20. Val1 Val2 Val3; datalines; A100 Big 90 45 25 A100 Medium 60 70 33 B100 Medium 60 70 33 B100 Small 60 70 33 C100 Big 60 34 45 C100 Medium 60 70 33 C100 Small 60 70 33 ; run;   Want --- A100 Big 90 45 25 A100 Medium 60 70 33 A100 Small 0 0 0 B100 Big 0 0 0 B100 Medium 60 70 33 B100 Small 60 70 33 C100 Big 60 34 45 C100 Medium 60 70 33 C100 Small 60 70 33 ... View more

    Hi All, I am trying to just extract 10 observations for a dataset and chose to do it in the below method.  But it does not seem to work . Can you help me with my logic below     Also before using the do while  i tried using do until but the code would not process . i put put statements and looked in the log but do until would not even go past 'point 1' ..       thanks .     data test; set sashelp.cars; counter+1; run;     data test_out; set test; put 'point1'; do while (counter =<10); output; put 'point2'; counter +1; end; run; ... View more

Hi i was wanting to filter  based on 'MONYYYY' date condition in the where step  I know about the default date filter condition 'DDMONYYY'd . But that does not help here . any suggestions ?  eg:  'AUG2018' 'SEP2018' ... View more

Hi All, I have 5 variables as below    Street_number Street_name Street_type Suburb Postcode   I have writte a logic that checks if any of the variable names are  empty and then I concat the remaining fields that are not empty. For that I have written multiple IF then logic's. Can I simplify the code like do this in a loop and reduce the IF Then's ? ********************************************************************   If street_number  eq ' ' and street_name not in  ' '  and street_type not in ( ' ') and suburb not in  ' ' and postcode not in   ' ' then Siteadd =  trim(street_name) || ' ' || trim(street_type) ||' ' || trim(suburb ) || ' ' ||  trim(postcode ) Else if  street_number  eq ' '  and street_name  in (' ') and street_type not in ( ' ') and suburb not in (' ') and postcode not in  (' ') Then Siteadd =   trim(street_type)|| ' '|| trim(suburb ) || ' ' ||  trim(postcode ) else if street_number  eq ' '  and street_name  in (' ') and street_type not in ( ' ') and suburb not in (' ') and postcode in (' ') then siteadd= trim(street_type) ||  suburb; ... View more

hi all , please can you help me with this requirement thanks in advance. input dataset Id claim_list ----- ----------------- abc 123, 456 ,789 def ghi 111,222,333 my output requirement: id claim_id abc 123 abc 456 abc 789 def ghi 111 ghi 222 ghi 333 ... View more