Write and run SAS programs in your web browser

Proc SQL

Reply
New Contributor
Posts: 3

Proc SQL

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 

Grand Advisor
Posts: 9,682

Re: Proc SQL

What data?

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

 

 

New Contributor
Posts: 3

Re: Proc SQL

Hello This is what we were given 
New Contributor
Posts: 3

Re: Proc SQL

*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;

Esteemed Advisor
Posts: 5,063

Re: Proc SQL

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.
Data never sleeps
Post a Question
Discussion Stats
  • 4 replies
  • 485 views
  • 0 likes
  • 3 in conversation