发帖
雷达卡
纠正一下
call symputx('Num', Statename) 这里Num是定义的macro所以不能在之前加&。
纠正一下之前关于format search (library reference)的问题，其实很简单看下边的注解就知道正确答案了
If you specify FMTSEARCH=(ABC DEF.XYZ GHI), SAS searches for requested formats or informats in this order:
WORK.FORMATS
LIBRARY.FORMATS
ABC.FORMATS
DEF.XYZ
GHI.FORMATS.
If you specify FMTSEARCH=(ABC WORK LIBRARY) SAS searches in this order:
ABC.FORMATS
WORK.FORMATS
LIBRARY.FORMATS
分享一个考前根据63题自己写的SAS code（只有有些题目有code）。
*63 items for advanced sas;
*#3;
/*
data employee;
input Name$ Dept$;
datalines;
Alan Sales
Michelle Sales
;
run;
data newemployee;
input Names$ Salary;
datalines;
Michelle 50000
Paresh 60000
;
run;
proc sql;
select Name, Dept
from employee
where name = any
*here you can also use =any to replace in;
(select Names
from newemployee
where salary>40000)
;
quit;
*/
*#4;
/*
data highway;
input Steering$ speed$;
datalines;
absent 0-29
absent1 0-29
absent2 30-49
absent3 30-49
absent4 50+
;
run;
libname ref '/folders/myfolders/sasuser.v94';
data highway;
set highway;
run;
proc sql;
select distinct Speed
into :Groups separated by ','
from highway;
quit;
*#5 and 59, ERROR: Indexed data set cannot be sorted in place unless the FORCE option is used.
;
proc sql;
create index steering on highway;
quit;
proc sort data=highway force;
by steering;
run;
*59. Here the data set name and new data have same name 'highway', so the index of steering is gone along with the variable steering.
I tried to change the data name to highway59, then the index of steering is still there.;
data highway;
set highway (keep=steering speed rename=(steering=newvar));
run;
proc sort data=highway;
by steering;
run;
*27;
data work.first;
input common$ x y;
datalines;
a 10 21
a 13 22
a 14 23
b 9 24
c 20 25
;
run;
data work.second;
input common$ y;
datalines;
a 1
a 3
b 4
b 2
;
run;
data work.combine;
set work.first;
set work.second;
run;
proc print data=work.combine;
run;
*30;
%let product=merchandise;
%put the value is "&product";
proc print data=work.combine;
title "the value is &product";
run;
*/
*31;
data work.one;
input x$ y;
datalines;
a 10
a 3
a 14
b 9
;
run;
data work.two;
input sumy;
datalines;
36
;
run;
data work.combine;
if _n_ = 1 then set work.two;
else set work.one;
run;
proc print;
run;
/*
*38;
%macro check(num=4);
%let result=%eval(&num gt 5.1);
%put result is &result;
%mend;
%check(num=10)
*47;
options mlogic mprint;
%macro execute;
%if &sysday=Thursday %then %do;
proc print data=work.combine;
run;
%end;
%put today is &sysday;
%mend execute;
%execute
*55;
data work.one;
input year qtr budget;
datalines;
2001 3 500
2001 4 400
2003 1 350
;
run;
data work.two;
input year qtr sales;
datalines;
2001 4 300
2002 1 600
;
run;
proc sql;
select *
from work.one as o
outer join
work.two as t
on o.year=t.year
;
quit;
*/
京公网安备 11010802022788号
