Hello, I'm looking to create a cartesian product with 3 tables through datastep where 3 tables are following: data min_scoperto_1; input min_Scoperto $; datalines; 0.01 0.02 0.03 ; run;   data scoperto_1; input Scoperto $; datalines; 0.1 0.2 0.3 0.5 1.0 2.0 ; run;   data limite_1; input limite $; datalines; 40 50 60 70 80 90 ; run; For two tables - through datastep - the right code is the following data c;    set LIMITE_1;    do i=1 to n;       set SCOPERTO_1 point=i nobs=n;       output;    end; run;   Which is the right sas code through datastep for the 3 tables? Thanks in advance! max ... View more

Hallo community, I am writing to you because I have this problem. I want to make the Cartesian product of two datasets where each contains 6 lines (the final db must have 36 lines) through a datastep (and not proc sql). Could you give me a hand? The two datasets are as follows data scoperto_1; input Scoperto $; datalines; 0.1 0.2 0.3 0.5 1.0 2.0 ; run; data limite_1; input limite $; datalines; 40 50 60 70 80 90 ; run;   I want to get a single dataset with all combinations of "limite" and "scoperto" (36 rows) through a datastep (and NOT proc sql). Thanks in advance max   ... View more

Hello everyone! I have a dataset where in a column I have repeated but different values for some determinations of another variable (I don't know the number) and I would like to create a new column that contains these values divided by the number of occurrences. How can I do this with simple programming? Attached the dataset with the "value" column of the values to be divided and the "value_1" column as I would like it (value_1 is the coloumn I 'd like to obtain). Thanks again for those who want to help me max ... View more

Good aftenoon at all, i need to create a new column mandatory in proc sql from a datasets where the existing column contains years in numbers.   here below  my query that doesn't "run":   proc sql; create table new as select "31/12"!!year <--- the problem as MY_DATE from old; /* where old db contains a variable "year" (year values are : 2000,2001,2002, etc - numerical format -) quit;   I need to know how "to pass" correctly values of year.   Thanks in advance massimo   ... View more