The SAS language is a 4GL that underpins the SAS system, a suite of products centered around data processing and statistical procedures.

learn more… | top users | synonyms

0
votes
0answers
6 views

how to read only specific coulmns from external tab delimited files using proc import into sas dataset

is it possible to read only specific variabiles from text files into sas as sas dataset using proc import? I have very big data in my text file which contains like 1000 observations and more than ...
0
votes
1answer
5 views

Storing Proc mean variables in SAS

proc means data=har.&seg_cell n mean std p1 p50 p99; class segment; var txn tpv; output out=stat_1 (drop = _TYPE_ _FREQ_) P1(txn)=txn_P1_T P1(tpv)=tpv_P1_T ...
0
votes
1answer
18 views

SAS Return date 'number/order' per user

I'm running the following query for a number of users, and proc SQL; select username, (select min(sub.date) from sample sub where sub.username = outer.username) Format=worddatx20. as ...
0
votes
0answers
8 views

Prediction intervals in proc X12

Does PROC X12 in SAS automatically calculate prediction (not confidence) intervals? I know the R package x12 does ('forecast' component of the x12 object returned from the model estimation).
2
votes
1answer
32 views

Creating a dataset variable from a macro variable containing both quotes, double quotes and mismatched quotes

In summary, I am struggling to achieve the following: data _null_; input x $ 1-50 ; call symput('problem',x); cards4; 'this' "is '' my "string"" from 'hell! ;;;; run; data _null_; ...
0
votes
1answer
54 views

R and SAS : different results for clustering analysis

I'm doing a cluster analysis with R and SAS and I have results which are really different. I know that the results are random, so a little difference is normal, but the difference is huge. I perform ...
-1
votes
0answers
111 views

Is it true, that R cannot invert big matrices like SAS? [closed]

I've encountered an opinion expressed on some serious meeting, that "R cannot invert big matrices", and that's why SAS is a better solution. Is that true? I now limitations of R core in order to the ...
0
votes
1answer
40 views

Importing a compressed dta file with SAS

I'm currently importing Stata-created .dta files into SAS with the following: proc import datafile='myfile.dta' out=test dbms=dta replace; run; In order to save space and bandwidth when backing up ...
0
votes
2answers
32 views

SAS MYSQL libname connection issue

Can anyone help with the following? 5 LIBNAME test1 mysql server='blah.blah.com' user='blah' password=XXXXXX; ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code ...
0
votes
3answers
43 views

Proc Sql case confusion

Within SAS I have a proc-sql step that I'm using to create macro variables to do some list processing. I have ran into a confusing step where using a case statement rather than a where statement ...
0
votes
2answers
27 views

SAS - Select from multiple records with same id but different status

Sorry for the misleading (if there is) question title, as I don't know how to express what I need in 1 question. I have a dataset as below: UserId Order Status 1 1 completed 1 ...
0
votes
3answers
40 views

SAS datastep/SQL select latest record from multiple records with same ID

For example I have a dataset as below: id Date 1 2000/01/01 1 2001/01/01 1 2002/01/01 2 2003/01/01 By datastep or sql, how could I get the record with id = 1 and latest Date 2002/01/01? Help is ...
2
votes
2answers
38 views

Replace missing values in SAS

How do you replace all missing values with zeroes in SAS? I have a text file that I dump into SAS to process some geo data, but whenever it has a missing value it breaks the operations. Is there a way ...
0
votes
1answer
30 views

Proper Formatting and Procedures for Basic Data Entry and Manipulation in SAS

I have a data file that I am trying to import into SAS that looks something like the below: WCM2B W C M 2 B M.B 2 18.4 12.3 g WCM2B W C M 2 B M.B 2 19.2 12.3 g WCM2B W C M 2 B S.P 2 19.5 DQ ('') ...
-1
votes
3answers
31 views

transaction count within an interval of time [closed]

This is my second day using SAS/SQL, so please bare with me. I am trying. I currently have columns DATETIME, REGISTER_NUM, STORE_ID. I am attempting to create a variable that counts the number of ...

1 2 3 4 5 81
15 30 50 per page