proc-sql

相关标签：javascript jquery android 多少钱 iPhone

SAS proc import missing leading zero

I am trying to import numbers from csv file to sas dataset with proc import ( SAS ) , but all my leading ze开发者_运维百科ro are disappear after the import.[详细]

2023-04-13 07:37 分类：问答
proc rank in sas

my data set has two variables ID and diagnosis. I am trying to assign row numbers in my dataset based on ID and diagnosis.[详细]

2023-03-29 00:42 分类：问答
How does SAS macro quoting interact with format literals?

Executing locally in a clean sess开发者_如何学Goion: %let x = %str(put(age, best.)); proc sql; select &x from sashelp.class;[详细]

2023-03-14 14:50 分类：问答
SAS proc contents

I am trying to list content of sas library Sasuser with standard sas 9 setup. From explorer, the library contains Table and catalogs. I am wondering what went wrong. Plus I am able to run proc content[详细]

2023-03-05 08:35 分类：问答
week function in proc sql

does any one know how to get weeknumber within sas proc 开发者_如何学Gosql ?Personally, I find it very hard to go past SAS\'s own, native WEEK function. It can be called from inside proc sql. Pass it[详细]

2023-02-19 03:04 分类：问答
How to develop a third-party SAS PROC?

Is it possible, as a third party, to develop a SAS PROC?I\'m thinking of something like a matlab toolbox or an R package.[详细]

2023-02-06 13:42 分类：问答
Force all coefficients to be negative in PROC REG

I\'m wondering if there\'s a way to force all non-intercept coefficients to be positive/negative in proc reg. If I use:[详细]

2023-02-04 22:36 分类：问答
SAS: What are the difference between "data files" and "raw data files"?

So, according to SAS books, you do: PROC IMPORT DATAFILE=\"filename\" | TABLE=\"tablename\" OUT=SAS-data-set[详细]

2023-01-24 17:28 分类：问答
Minute interval in mysql / sas or proc sql

Does any one know proc sql or data step have a function where I can convert datetime value into : 15 mins interva开发者_开发知识库l for example :[详细]

2023-01-23 04:20 分类：问答
Updating an Oracle table with data from a SAS data set using SAS code

I am rather new to SAS and I have run into a problem that I think probably has a better solution than what I\'ve found so far.[详细]

2023-01-09 09:44 分类：问答