Hello I created a macro which has a threshold parameter and which generates a table name: table_&threshold. then I created another macro of iterations of the first macro by threshold but my problem is when I want to use comma thresholds it does not work because the name of the table cannot contain a comma for example: table_0.5 I want to calculate another parameter when I Have threshold 0.5 I want to generate table_0_5 this is part of my code: %macro macro2(v, threshold); proc sql; create table_&threshold .... %mend; %macro table_result(V,threshold); %DO i=1 %TO &threshold %BY 0.5; %macro2(&V,&i); %END; %mend; ... View more

Hello, I want to calculate the percentage of ok/ko of each variable and consolidate all the results into a single table such as the table "WANT" data have; input var1 $ var2 $ VAR3 $; CARDS; ok ok ko ko ok ko ok ok ok ok ok ok ok ok ko ko ok ok ok ok ok ok ok ko ; run;     data want; input varname $ prct_ok prct_ko; CARDS; var1 75 25 var2 100 0 var3 50 50 ; run; ... View more

Hello, I want to compare negative line by positive line in terms of price. the comparison is made on the variables (name, city, age, product). I want a table which contains just the negatives with their positive correspondents and the name of the variable which is different between the two rows, if I find more than one difference between two rows I do not put it in this table like the case of " Oliver "I have two differences in the city and the age. data have; input row name $ city $ age product $ price; CARDS; 1 Philip Paris 43 P1 -10 2 Mikael Marseille 23 P2 -20 3 Oliver Metz 32 P2 -25 4 Lisa Toulouse 43 P1 -15 5 Philip Paris 55 P1 10 6 Michael Marseille 23 P2 20 7 Oliver Lille 23 P1 25 8 Lisa Toulouse 43 P2 15 ; run; data want; input negative_row name $ city $ age product $ price positive_row column_diff $; CARDS; 1 Philip Paris 43 P1 -10 5 age 2 Mikael Marseille 23 P2 -20 6 name 4 Lisa Toulouse 43 P1 -15 8 product ; run;     ... View more

data have; input var1 6.2 var2 6.2 var3 6.2; datalines; 1400.00 165.55 839.57 0.00 0.00 106.42 1200.00 142.98 725.09 0.00 0.00 91.91 270.00 0.00 168.85 0.00 0.00 67.54 0.00 0.00 33.61 270.00 0.00 0.00 0.00 0.00 168.85 0.00 0.00 101.15 155.00 1.70 150.00 0.00 0.00 3.30 ; run; Hello I want to verify if var1 < (var2+var3) by group (while I have 0.00) (1) exemple: 1400.00 with 165.55 + 839.57 +106.42 1200.00 with 142.98 + 725.09 + 91.91 270.00 with 168.85 + 67.54 +33.61 want = new column 1 if i Have (1) 0 else   ... View more