Hi, I'm trying to use proc similarity (hope someone is familiar with it) and it needs sequential column variables, eg. Var1 Var2, Var3, ... Var1000, but when I sort it, it sorts as Var1, Var10, Var100, Var101, Var2, ... Var999... How can I keep the normal numbering system 1,2,3,...1000 .. If anyone knows proc similarity, I have 2 groupings that would duplicate the Date which is the ID variable.  I'm trying to use a by statement in proc similarity but I'm getting an error that the ID (date) is duplicated from all these groups.  Any suggestions, thanks. ... View more

Hi, I'm having a hard time with trying to get percentages by subgroups using proc tabulate.  I'm sure it's probably a simple fix, I just tried everything. I have this output (below). But I want to show the percentages of each CI1_B by Vendor_1 separately.  So each one would add up to 100%.  I tried rowpctn.   PctN Vendor_1 CI1_B 100 VendorA <= -20.1% -15.1% => and => -20% 100 -10.1% => and => -15% 100 -5.1% => and => -10% 100 0% => and => -5% 100 0.1% <= and <= 5.0% 100 5.0% <= and <= 10.0% 100 10% <= and <= 15.0% 100 > = 15.1% 100 VendorB >=30% 100 <30% 100 <20% 100 <10% 100 <5% 100 ... View more

How could I change this to work wiht the and? if V > 1then C ='Door' and D='Window"; else if V < 1 then C='Door2' and D2 = 'Window2". ... View more

Hi, I have inputed text data (see CODE1 below, and I want the CI1 to remain in the same order when I run it though proc tabulate.  But instead it sorts it as such (see OUTPUT1).  I'm using the TABULATE code (see CODE2).  thanks CODE1: if Vendor_1 < -0.20 then CI1 = '<=-20.1%'; else if Vendor_1 < -0.15 and Vendor_1 => -0.20 then CI1 = '-15.1% => and => -20%'; else if Vendor_1 < -0.12 and Vendor_1 => -0.15 then CI1 = '-12.1% => and => -15%'; else if Vendor_1 < -0.10 and Vendor_1 => -0.12 then CI1 = '-10.1% => and => -12%'; else if Vendor_1 < -0.08 and Vendor_1 => -0.10 then CI1 = '-8.1% => and => -10%'; else if Vendor_1 < -0.05 and Vendor_1 => -0.08 then CI1 = '-5.1% => and => -8%'; else if Vendor_1 <= 0 and Vendor_1 => -0.05 then CI1 = '0.0% => and => -5%'; else if Vendor_1 > 0 and Vendor_1 <= 0.05 then CI1 = '0.1% <= and <= 5%'; else if Vendor_1 > 0.05 and Vendor_1 <= 0.08 then CI1 = '5.1% <= and <= 8%'; else if Vendor_1 > 0.08 and Vendor_1 <= 0.10 then CI1 = '8.1% <= and <= 10%'; else if Vendor_1 > 0.10 and Vendor_1 <= 0.12 then CI1 = '10.1 <= and <= 12%'; else if Vendor_1 > 0.12 and Vendor_1 <= 0.15 then CI1 = '12.1% <= and <= 15%'; else if Vendor_1 > 0.15 then CI1 = '>15%'; else CI1 = 'ZZZ'; end; end; OUTPUT1: -10.1% => and => -12% -12.1% => and => -15% -15.1% => and => -20% -5.1% => and => -8% -8.1% => and => -10% 0.0% => and => -5% 0.1% <= and <= 5% 10.1 <= and <= 12% 12.1% <= and <= 15% 5.1% <= and <= 8% 8.1% <= and <= 10% <=-20.1% >15% CODE2: PROC TABULATE data=Test; CLASS USE_CI CI1 Vendor_1; var count; TABLE Vendor_1*CI1,pctn<CI1 all>  /rts=35; RUN; ... View more

Hi, I'm trying to send over the output form 4 proc tabulates into the same Excel file, but into 4 separate worksheets. Using ODS html body.  Any way on how to do this? Options Missing = '0'; ods html body = C:\Excel file.xls' style=minimal; options nodate nocenter pageno=1; Thanks ... View more