topic Re: Proc SQL in SAS Studio

Proc SQL

palomita_74 — Fri, 16 Sep 2016 15:34:05 GMT

Hello,

I am trying to change this data using Proc SQL. I am unsure how to do so.

proc freq data=palomaflores;
tables x1 x2 c1;
run;

proc means data=palomaflores;
var x1 x2 c1;
run;
proc means data=palomaflores n nmiss mean max
q1 maxdec=2;
var x1 x2 c1;
run;

Proc sort data = palomaflores;
by group;
Run;

proc means data=palomaflores n nmiss mean max
q1 maxdec=2;
var x1 x2 c1;
By group;
run;
proc plot data=palomaflores;
plot x2*x1;
run;
quit;

Thank you

Re: Proc SQL

ballardw — Fri, 16 Sep 2016 17:07:01 GMT

What data?

Are you trying to direct the output of the procedures to data sets?

Re: Proc SQL

palomita_74 — Sun, 18 Sep 2016 04:38:56 GMT

Hello This is what we were given

Re: Proc SQL

palomita_74 — Sun, 18 Sep 2016 04:39:57 GMT

*type in your uin after the equals sign in the line below;;
%let youruin=661947537;
%let mu=%substr(&youruin,8,2);
*type in your name for the dataset name;;
data yournamehere;
s=sqrt(&mu);
do i=1 to 100;
x1=ranuni(&youruin+i);
x2=&mu+s*rannorm(&youruin-i);
c1=ranuni(&youruin+1000*i);
output;
end;
run;
data yournamehere;
set yournamehere;
if c1 <=.4 then group='A';else
if .4<c1<.8 then group='B';
run;

Re: Proc SQL

LinusH — Sun, 18 Sep 2016 13:21:30 GMT

So you got an assignment to replace this code (all of it?) to SQL?
Is this training or professional?
If professional, what's the purpose? Assuming that you got a working program.