Hello, new day new question. This time I want to calculate bandwidth of a histogram inside a makro which also creates the histogram. Here is some data I'm using: data plot; do i =1 to 1000; y = rannor(1234) ; y1 = rannor(1235) ; output; end; run; data varCorr; input correlation ; datalines; 4 ; The data is the used in the macro: %MACRO createPlot(dataPlot, varCorr, obs ); data bandwidth; set &varCorr; b = 3.5 * y/(&obs**(1/3)); %let b = %SYSEVALF(b); proc sgplot data=&dataPlot; histogram y / binwidth=b transparency=0.5; histogram y1 / binwidth=b transparency=0.5; density y / type=kernel lineattrs=GraphData1; density y1 / type=kernel lineattrs=GraphData2; xaxis label="bla" ; keylegend "yK" "yG" / across=1 position=TopRight location=Inside; run; %MEND; I want to calculate the b first and use it later in the proc sgplot when plotting the histogram. I think the problem is in this line: %let b = %SYSEVALF(b); But I cannot figure it out how to fix it by myself. Thanks for your help. ... View more

Hello, today I wanted to merge two data sets together to finally draw some plots with the data. I got the code working outside of a macro, but as I have more data sets I wanted to create a macro for this: Lets say I have data like this: data data1; input y ; datalines; 1 2 4 2 6 4 3 4 ; data data2; input y ; datalines; 4 3 7 5 6 9 5 4 ; Now I want to merge the two data sets: %MACRO createPlotData(data1 , data2); proc sql; create table plot1 as select y from &data1 ; quit; proc sql; create table plot2 as select y as y1 from &data2 ; quit; data outputPlotData; set plot1 plot2; run; %MEND; The code is working when I use it outside of the macro. I already googeld and looked in this forum for a solution but I could not get the code to work. I think I need to at something inside the proc sql code? Thanks for your help! ... View more

Hello, new day and I have new SAS beginners problem. I want to calculate the variance for two parameters in my data set and in the next step I want to do some calculations with the just calculated variances. For that I tried to write a macro because I want to apply that method on some more data sets: %MACRO calculateICC(data, name); PROC UNIVARIATE DATA = &data; VAR a; VAR e; OUTPUT out = var VAR=vara VAR=vare; data ic&name; set var; ic = vara/(vara + vare); output out = ic; run; %MEND; I think the first part is wokring alright. But the second part is messed up. ... View more

Hello SAS Experts, I'm coming from the R world and have some troubles getting started with SAS at the moment. What I want to do: I have a data set with names of cluster and now I want to simlulate lets say 50 random numbers for each cluster. I already found out to do it without using the data set of cluster names: data A; do ClusterID=1 to 100; DO i=1 TO 50; ZV=Rannor(0); output; end; end; run; But how do I do it now when I have the cluster names stored in a data set called clusterid with the variable name clustername?   ... View more