b*****o
发帖数: 817 | 1 比如在同一个sas session里
LIBNAME IN1 "/disk/mydata/bdcinfo";
LIBNAME IN2 "/disk/mydata/bdcinfo";
两个那么in1 and in2可以同时使用还是in2 会overwrite in1? |
|
h***x
发帖数: 586 | 2 没有问题
6 libname mylib 'C:\Users\Huxxx\Desktop';
NOTE: Libname MYLIB refers to the same physical library as HUXXX.
NOTE: Libref MYLIB was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\Huxxx\Desktop
7
8 data mylib.XYZ;
9 input x y z;
10 datalines;
NOTE: The data set MYLIB.XYZ has 6 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
17 ;
... 阅读全帖 |
|
x*******u
发帖数: 500 | 3 请问有没有办法把libname的physic name 转成一个character string. |
|
d**********r
发帖数: 24123 | 4 LIBNAME 是 Byref，你修改任何一个LIB的内容，另外一个的也会变。 |
|
l*******a
发帖数: 107 | 5 libname mylib 'C:\Research\Data';
data mylib.XYZ;
input x y z;
datalines;
1 1 12.4
1 2 11.3
1 3 1.4
2 1 2.1
2 2 19.4
2 3 10.0
;
run;
结果出现了这样的问题：
ERROR: User does not have appropriate authorization level for library MYLIB.
请教各位，应该怎么解决？
多谢！ |
|
l*******a
发帖数: 107 | 6 不好意思 我测试的code 是：
libname mylib 'C:\Users\Desktop';
data mylib.XYZ;
input x y z;
datalines;
1 1 12.4
1 2 11.3
1 3 1.4
2 1 2.1
2 2 19.4
2 3 10.0
;
run;
为什么路径是desktop 就有错误呢？应该怎么解决呢？
多谢！ |
|
h***x
发帖数: 586 | 7 libname mylib 'C:\Users\HUXXX\Desktop'; |
|
l*******a
发帖数: 107 | 8 我贴code上来的时候做了些改动。 完整的是：
libname mylib 'C:\Users\lubinghua\Desktop';
data mylib.XYZ;
input x y z;
datalines;
1 1 12.4
1 2 11.3
1 3 1.4
2 1 2.1
2 2 19.4
2 3 10.0
;
run;
但是问题还是同样存在，大家run 这个code都没问题吗？ |
|
l**********8
发帖数: 305 | 9
************************************************************
上个完整的LOG， 谢谢大家了
****************************************************************
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
25
26 *-----------------------------------------------------;
27 %macro process(year,yr,file,first,numobs);
28
29 data cartemp;
30 set loc.carl&year.
31 (firsto... 阅读全帖 |
|
s****y
发帖数: 21 | 10 90%，比预期的高，之前做题勉强80%。
机经之前的帖子已经说得挺多了，我稍微补充点吧：
有两道关于excel文件包含多个sheets的题，一个是问怎样reference：选项有:
libname “aaa.xls”;
libname mydata "aaa.xls";
libname mydata "aaa.xls" work.sheets=(a,b,c);
libname a b c "aaa.xls".
另一个是怎样ref一个excel文件中一个叫north的sheet，选项有：
$north
'north$'e
'north$' n
什么的，完全不知道是什么东东，乱选了一个。
还有一道题是日期的写法,x="01feb2002"d,用的双引号，应该是可以这样写的。
还有个题要找出job中带manager的obs，选项有 where job like '%manager%';
其他的想起来再说吧。
磨磨蹭蹭的花了两三个月看完了little sas 和online tutor，以为就是拿钱换个证书
，后来做
123，50的时候发现只有80%的分，加上换题库，还是有点担心的。不过后来把 |
|
M****6
发帖数: 71 | 11 12.The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
A. libname qtrdata ‘qtr1.xls’;
B. libname ‘qtr1.xls’ sheets=3;
C. libname jan feb mar ‘qtr1.xls’;
D. libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,
mar);
版上的答案是A。看了... 阅读全帖 |
|
l**********8
发帖数: 305 | 12 就是debug不出来，大神们救我啊
******************* 完整的 CODE ***************
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
*libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12222015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12222015.log";
run;
*--------------... 阅读全帖 |
|
l**********8
发帖数: 305 | 13 就是debug不出来，大神们救我啊
******************* 完整的 CODE ***************
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
*libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12222015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12222015.log";
run;
*--------------... 阅读全帖 |
|
q**o
发帖数: 4111 | 14 查help,看到下面两条
1.SAS/ACCESS for PC Files
2.SAS/ACCESS for Relational Databases
两条的功能,方法和syntax好像都是一样的,唯一不同是1用pcfile和server名字,路径来
指定数据路径,2直接用oracle,db2之类来指定
举例说明,用libname statement去读oracle数据
1:libname mylib pcfiles server=*** prot=**** dsn=ORA9MS user=*** pwd=***
preserve_tab_names=yes;
2:libname mylib oracle user=*** password=*** path=*** schema=hrdept;
有区别吗?
还有一个疑问,同样是用pass-through facility去读数据
1.proc sql;
connect to oracle (user=*** password=*** validvarname=v6)
2.proc sql;
connect to syba |
|
j**********e
发帖数: 442 | 15 我想在Compustat下载一个数据库叫做pitidhistus,我运行下面的SAS code:
%let wrds=wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=_prompt_;
rsubmit;
libname comph '/wrds/comph/sasdata';
data mydata;
set comph.pitidhistus;
proc print data=mydata (obs=30);
run;
endrsubmit;
结果得到：
77 libname comph '/wrds/comph/sasdata';
NOTE: Libref COMPH was successfully assigned as follows:
Engine: V9
Physical Name: /wrds/comph/sasdata
78 data mydata;
79 set comph.pitidhistus;
ERROR... 阅读全帖 |
|
m*******m
发帖数: 182 | 16 There are two basic kinds of software libraries:
Static library. A library in which modules are bound into
the executable file before execution. Static libraries
are commonly named libname.a. The .a suffix refers to
archive.
Dynamic library. A library in which modules can be bound
into
the executable program at runtime. Dynamic libraries are
commonly
named libname.so. The .so suffix refers to shared
object.
The easy way: use GNU libtool. (`info libtool`)
The hard way:
gcc -g |
|
j**********e
发帖数: 442 | 17 我想在Compustat下载一个数据库叫做pitidhistus,我运行下面的SAS code:
%let wrds=wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username=_prompt_;
rsubmit;
libname comph '/wrds/comph/sasdata';
data mydata;
set comph.pitidhistus;
proc print data=mydata (obs=30);
run;
endrsubmit;
结果得到：
77 libname comph '/wrds/comph/sasdata';
NOTE: Libref COMPH was successfully assigned as follows:
Engine: V9
Physical Name: /wrds/comph/sasdata
78 data mydata;
79 set comph.pitidhistus;
ERROR... 阅读全帖 |
|
l*****i
发帖数: 296 | 18 我看了下脚本，发现相关的是这样的
首先你要有关于天线效应的CLF文件
我这里文件在script/antenna_6lm.clf
库的名字就是你设计的东西的那个库，这里用的libName是之前设好的变量
相关的流程是：
auLoadCLF
setFormField "Load CLF File" "Load CLF File Without Timing Related
Information" 1
setFormField "Load CLF File" "CLF File Name" "script/antenna_6lm.clf"
setFormField "Load CLF File" "Library Name" libName
formOK "Load CLF File"
axgSetHPORouteOptions
setFormField "HPO Signal Route Options" "Charge-Collecting Antenna" "
advanced"
formOK "HPO Signal Route Options"
axReportAntennaRat |
|
S***x
发帖数: 2382 | 19 星期五把SAS ODBC搞定了，本来想休息两天，暂时不去碰这些东西，呵呵
不过今天看到oloolo和ciarad的回帖，心想早点写出来免得过两天忘记了，
而且也请高手们指正。。
言归正传，前几天装好MySQL远程机之后就想试试用SAS连，网上看了看有两种
方法，一种是libname xxx ODBC, 一种是libname xxx MySQL, 星期五一早先试
了试ODBC,发现不work,系统给了个CLI, 代号113的错误，又试了试mysql,还是不work,
mysql说找不到mysql engine,想了想觉得是license的问题，中午打电话给sas
公司，被告知我的版本不包括mysql engine,只能用ODBC。
既然ODBC不work，显然要装ODBC driver,上网找了找，unixodbc.org上都有，下了
一个2.2.11，然后开始装，一开始装就出错，半道上configure不走了，说要qt2.2,
于是跑去下qt,qt的网站巨慢，吃完中饭回来还没下完，2:30 qt下好，开始装，装到
一半报错，说xxx没有装，没耐性再去找了，就ignore,装好qt之后装 |
|
s******d
发帖数: 303 | 20 我不确定你的意思，楼上是不是说再创建一个变量，如果是这样的话我不确定是否合适
。原因是我的records特别多，每个record 只有5个变量，所以增加一个变量，会使我
的文件增加几十个G.
我们平时都处理非常巨大的数据，希望可以找到一个有效处理大数据的方法。
另外还有一个问题，在产生新数据的时候既可以用if, 也可以用where,看上去效果差不
多，不知道哪个处理速度更快。for example
dataset libname.A;
set libname.X;
where VarA > 1; "if VarA > 1"
run;
Thank you! |
|
p********a
发帖数: 5352 | 21 ERROR: Connect:
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
这说明你的ERROR是在LIBNAME里，根本不是这个PROC IMPORT啊
你可能是弄了个EXCEL ENGINE，同时又搞IMPORT了 |
|
t****e
发帖数: 25 | 22 1.
** sashelp.prdsale has more than 100 observations
%macro test;
data out;
set sashelp.prdsale nobs=totalobs;
if totalobs>10 then do;
%let rc=high; end;
else do; %let rc=low; end; run;
%mend;
%let rc=Before Execution;
%put &rc;
why is the result low?
2.
libname A 'SAS library reference';
libname F 'SAS library reference';
options fmtsearch=(A F.X);
what is the second location searched for formats?
The tutorial says
work.formats->library.formats->A.formats->F.X
why is the answer work.formats as |
|
d*****6
发帖数: 100 | 23 libname A 'SAS library reference';
libname F 'SAS library reference';
options fmtsearch=(A F.X);
what is the second location searched for formats?
The tutorial says
work.formats->library.formats->A.formats->F.X
why the answer is work.formats here?
Thanks a lot! |
|
B***y
发帖数: 138 | 24 用libname odbc链接sql server 数据库。连接显示成功，也能对table进行操作，
但是为什么点击进入那个lib name ,看不到table 和 view 呢。 我在自己机器上试验
过其他数据库可以看到，说明这个libname odbc code 没问题。 是sql server user
id 的权限问题么？我的user id是dob_owner的权限啊。 有人能知道怎么回事呢？ |
|
p********a
发帖数: 5352 | 25 其实一点PP事。昨晚RUN个SAS PROGRAM，把LOCAL 的TEMP DRIVE（很小）占满了，某人
不能用SAS，然后他们满世界找人。我承认是我干的了，取消了程序，道歉了，然后问
能不能把TEMP FOLDER改到SERVER上。对方JJWW的说干不了。然后某DIRECTOR横空而出
，问我为啥不到ORACLE上用SQL写程序。然后说改TEMP FOLDER，一个LIBNAME语句就可
以了。看得我两眼冒火。TMD，这年头居然还有人教我如何用LIBNAME。头脑一热就不知
道自己回了些什么了。
问问大家，OPTIONS里可以改TEMP FOLDER吗？这帮家伙说CONFIG里不好改。 |
|
c**2
发帖数: 99 | 26 我是看了online tutor之后开始做130题的，用的是CxTerm同学排版后的三套仿真界面
pdf版，发现
好多题目里面的statement和function在tutorial里都没提到过啊，作得真郁闷。。。
有一题问：
What is the result of including _TEMPORARY_ keyword option on an ARRAY
statement?
答案是A：the values in the array are automatically retained.
我严重怀疑应该是B啊：the values are written to temporary variables in the
PDV.
还有一题：
Given the following OPTIONS statement:
LIBNAME A 'SAS library reference';
LIBNAME F 'SAS library reference';
OPTIONS FMTSEARCH=(A F.X);
what is the second location searched... 阅读全帖 |
|
D******n
发帖数: 2836 | 27 create a .vim directory under you home directory(there is a dot before
vim)
and then create a syntax directory under it
and then create a sas.vim file under the syntax directory
==============sas.vim======================
if version < 600
syntax clear
elseif exists("b:current_syntax")
finish
endif
syn case ignore
syn region sasString start=+"+ skip=+\\|\"+ end=+"+
syn region sasString start=+'+ skip=+\\|\"+ end=+'+
" Want region from 'cards;' to ';' to be captured (Bob Heckel)
sy... 阅读全帖 |
|
T*******I
发帖数: 5138 | 28 我准备接受goldmember的挑战公布Code。
SAS Code (Part I): Simulation for a Dichotomic Regression wirh Julious's Sample
我要公布的code仅仅是一个关于dichotomic regression simulation的SAS code。是我在4年多前写的。仅仅作了一点小小的更改。我的code写得很笨拙，但it runs good。请大家保存好你的500个随机样本。以备后用。
我将分段公布，这里是第一部分，data generation and random check.
这个例子是想要告诉大家，如果你的分析逻辑正确，根本不需要simulation。
正如我对goldmember说过，在接受这个挑战前，让我问大家几个问题：
如果总体中存在一个临界点，你认为样本临界模型一定在临界点处连续吗？如果你的回答是肯定的，你的哲学的或/和数学和/或统计学的逻辑基础是什么？然后再问问你自己，总体给了你连续性的保证吗？你可以在样本基础上假设总体的连续性吗？为什么？
大家回答了我的这几个问题后我再公布后面的正式算法... 阅读全帖 |
|
x**g
发帖数: 807 | 29 正在看一批数据，是SAS格式 （.sas7bdat），可是还带了一个同样文件名，不同后缀
名的文件(.trn)。请问这个.TRN文件是干什么用的阿？
在这批数据里还看到一个import的程序，是这样写的
%let dirnam = 'c:\folder';
%let trnnam = 'e:\folder\bbb010.trn';
libname dir &dirnam;
libname dirx xport &trnnam;
proc copy in=dirx out = dir;
run;
谁能帮忙解释一下阿？ |
|
p***r
发帖数: 920 | 30 So far as I know and practice, libname works well with .xlsx
LIBNAME LIBIN1 excel "xxxxxxx.xlsx" ;RUN; |
|
c**********e
发帖数: 2007 | 31 Which of the following PROC SQL steps display the name (Memname),
modification date (Modate), number of variables (Nvar), and the number of
observations (Nobs) for each table in the Sasuser library?
(A)
proc sql;
select memname, modate, nvar, nobs
from dictionary.tables
where libname='SASUSER';
quit;
(B)
proc sql;
select memname, modate, nvar, nobs
from dictionary.tables
where libname='Sasuser';
quit;
(C) Neither A nor B.
My question is: what is the dictionary lib in (A) ... 阅读全帖 |
|
s*******2
发帖数: 499 | 32 99. Given the following OPTIONS statement:
libname A 'SAS library reference';
libname F 'SAS library reference';
options fmtsearch = (A F.X);
What is the second location searched for formats?
A.F.X
B.A.FORMATS
C.WORK.FORMATS
D.SAS supplied formats
参考答案是C.觉得不能理解。因为WORK.FORMATS如果不在fmtsearch内的话，应该是首
先被寻找的。这里的fmtsearch也没有WORK.FORMATS. 请问为什么选C? |
|
j*****7
发帖数: 4348 | 33 libname test "X:\XXX\XXX\XXX";
proc sql noprint;
create table ddfdata as
select memname as dataset label='Data Set Name',
name as variable label='Variable Name',
label label='Variable Label',
type label='Variable Type',
count (distinct memname) into :totmem
from sashelp.vcolumn where libname='TEST'
order by dataset,name;
quit;
%macro trans;
data _null_;
set ddfdata;
by dataset notsorted;
retain b 1;
if first.dataset then do;
call symput(compress(trim(left('member'||t... 阅读全帖 |
|
c******y
发帖数: 3269 | 34 I'm not 大牛, and no longer use MS SQL server. Below is a real-life example,
hope it helps.
Background: VPN network to connect database, a bottleneck to overcome.
implicit sql-passthrough is exchanging data intensively, which choked the
VPN network, where you would see huge difference between real time and cpu
time.
explicit sql-passthrough only sends a command to the database, the database
do the data manipulation within itself, and sends final data back to SAS,
costing way much less network reso... 阅读全帖 |
|
K***a
发帖数: 72 | 35 Try this:
proc sql noprint;
select count(*), memname into :tb1-:tb100, :numDs
from sashelp.vtable where libname="Urlibname";
quit;
filename outfname ".../Libname.xlsx";
%macro expdt;
%do i = 1 %to &numDs;
proc export data=&&tb&i
outfile=outfname dbms=xlsx replace;
sheet=&&tb&i;
run;
%end;
%mend;
%expdt; |
|
m*****6
发帖数: 36 | 36 【 以下文字转载自 Quant 讨论区 】
发信人: mitbbs6 (Peter), 信区: Quant
标 题: 新手请教 SAS Oracle 连接问题
发信站: BBS 未名空间站 (Tue Jul 21 23:10:13 2015, 美东)
libname oralib oracle path=mydb user=user123 password=mypass schema=myschema;
proc sql;
select *
from oralib.mytable;
quit;
今天新换了机器 ，run以上code的时候不work了，没法连接oracle。
ERROR:The Oracle engine cannot be found.
ERROR: Error in the LIBNAME statement.
大家知不知道是怎么回事， 是不是 oracle client没有装好啊 ？
多谢 |
|
l**********8
发帖数: 305 | 37 为啥log总是报错，说找不到file work.cartemp
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12212015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12212015.log";
run;
*------------------------------------------------... 阅读全帖 |
|
|
h********r
发帖数: 928 | 39 dm "frogs;clear;market;clear";
options time=1day;
libname MITBBS "us:\";
data waterfall;
set hobobo;
if hobobo= "short" or Hobobo=long then delete;
drop Dow 500 where hobobo said 'up 500';
if dow='10400' then up;
run;
proc start;
run;
quit;
data wrong;
input wrong prediction;
dow up
;
if dow up finally, then learn from Hobobo to escape;
run.......; |
|
c*****s
发帖数: 180 | 40 Example
Suppose you want to store the Words macro in compiled form in a SAS library.
This example shows the macro definition for Words. The macro takes a text
string, divides it into words, and creates a series of macro variables to
store each word.
Notice that the STORE option is used in the macro definition so that Words
will be permanently stored as a compiled macro, as follows:
libname macrolib 'c:\storedlib';
options mstored sasmstore=macrolib;
%macro words(text,root=w,delim= |
|
c*****s
发帖数: 180 | 41 Complete the following code so that the macro Prtlast will be compiled and
stored in Macrolib.
libname macrolib 'c:\storedlib';
options mstored sasmstore=macrolib;
%macro
%if &syslast ne _NULL_%then %do;
proc print data=&syslast(obs=5);
title "Listing of &syslast data set";
run;
%end;
%else
%put No data set has been created yet.;
%mend; |
|
f**y
发帖数: 138 | 42 SAS definetely can write the results of GLM to a separate database.
Check help for LIBNAME. |
|
p********a
发帖数: 5352 | 43 不是SQL PROGRAMMER，但需要从SQL SERVER PULL DATA
用SERVER MANAGEMENT STUDIO CONNECT进去了，在那个DATABASES下面，点了DATABASE
的名字BSC，然后TABLES下面怎么只有SYSTEM TABLES，什么都没有呢？DEFAULT的
SCHEMA不就是DBO吗
我用SAS ODBC进去是看得见DATA的
libname bsc odbc datasrc=BSC schema=dbo User=xxx Password=xxx;
谢谢帮助 |
|
m********5
发帖数: 619 | 44 你或者download SSH直接upload
或者在你自己的机器上写
rsubmit;
libname temp '/sastemp1';
proc upload 'local file' output=temp.xxxx;
endrsubmit;
自己查查吧，看我写的对不对 |
|
s***r
发帖数: 1121 | 45 I accessed WRDS using SSH; I uploaded my databases and SAS code.
Buy how can I set libname at WRDS server?
Many thanks - Da Niu. |
|
m********5
发帖数: 619 | 46 直接upload sas program不行
这样子
你打开一个new terminal
输入
pico xxx.sas
这样就在你的home directory建立了一个sas程序
libname 里面你定义自己的home directory 也可以
/sastemp1 to /sastemp14 也可以
输入程序
ctrl x保存退出
运行的时候运行
sas xxx.sas |
|
p********h
发帖数: 544 | 47 这是白送分得题。考的是LIBNAME啊，老大。赶紧好好复习。 |
|
s*********e
发帖数: 1051 | 48 libname test oracle ....;
proc datasets library = test;
contents data = _all_;
run; |
|
c******j
发帖数: 270 | 49 写了这么一段code
LIBNAME Mylib 'C:\Documents and Settings\cloverzj\My Documents\SAS';
proc format lib=mylib;
value $itemfmt
'C'='Cassette'
'R'='Radio'
'T'='Television';
run;
data sasuser.orders;
infile aug99dat;
input ID 3. @5 Date date7.
Item $13 Quantity 15-17
Price 19-24 TotalCost 26-32;
format date date9. totalcost dollar9.2;
format Item $itemfmt.;
run;
proc print data=sasuser.orders;
run;
可是运行的时候总是说The format $ITEMFMT was not found or cou |
|
p********a
发帖数: 5352 | 50 你是初学者吧？
现成的SAS DATA是不需要INPUT的，你的SET语句也完全不对。建议你可以先学学
LIBNAME， SET， INFILE STATEMENT后再看看 |
|
