About abcd123

abcd123 · ‎08-17-2017

Thanks. Are you suggesting adding those additional variables and treat the problem as a general linear model? (BTW, what does "seasonality" mean? Is it a dummy variable?)

abcd123 · ‎08-17-2017

Hello, all I am fitting a time series model(ARIMA) and I have about 100 variables to choose from. I have tried PROC VARCLUS to reduce this number to 40, but still it is too much. Is there a way I can further reduce this number? I know PROC GLMSELECT could be one option; however, from what I know, PROC GLMSELECT only works for general linear model. It it suitable to use PROC GLMSELECT for time series model selection? Thank you very much.

abcd123 · ‎08-16-2017

Hello, all I am fitting a time series model(ARIMA) and I have about 100 variables to choose from. I have tried PROC VARCLUS to reduce this number to 40, but still it is too much. Is there a way I can further reduce this number? I know PROC GLMSELECT could be one option; however, from what I know, PROC GLMSELECT only works for general linear model. It it suitable to use PROC GLMSELECT for time series model selection? Thank you very much.

abcd123 · ‎11-18-2015

Thank you all for help!

abcd123 · ‎11-18-2015

Hello, I am trying to input some dates using input datatement. Here is raw data&colon; Date 12/10/2014 1/1/2015 9/30/2015 As you can see, the date could be any length(10, 9, or 8), and as a result, mmddyy8. or mmddyy10. will not work. Is there a way to input such mixed formated dates?

abcd123 · ‎08-07-2015

Wow, this is exactly what I want!!! Thank you so much!!!

abcd123 · ‎08-05-2015

Thanks, I tried to set options LRECL= 100K, however I got following error message: Option value for SAS option LRECL must be between 1 and 32767. In addition , I checked my variable headings and all variable name length are less than 32. So it seems that it is the 32767 restriction that cause the problem.

abcd123 · ‎08-05-2015

Hello, I am trying to import a csv file; first row contains variable names, and there are 10000 or so variables. My code look like following: filename foo 'C:\Users\Desktop\aaaa_2.txt' lrecl=100000; PROC IMPORT OUT= WORK.ABC DATAFILE= foo DBMS=TAB REPLACE; GETNAMES=YES; DATAROW=2; RUN; Although I specified lrecl in the code, the generated variable names are still messed (not showing correct name, but just "VAR3526", "VAR3527" etc) . Here are the log message I got: EFI will truncate records > 32767; your record length was 100000 Number of names found is less than number of variables found. It seems SAS still truncates after 32767 characters. Why lrecl not work?

abcd123 · ‎08-04-2015

Thanks, Tom. This is very helpful.

abcd123 · ‎08-04-2015

Hello, All I have a csv file "abc.csv", it has 5000 variables (var1-var5000, column1 through column5000), and nearly million rows. However I am only interested in var1, var1390,var3782, and var4703. I know I can do it using following code: filename myfile "abc.csv"; data want(keep=var1 var1390 var3782 var4703); infile myfile; input var1-var5000; run; However the code do waste time inputing those un-wanted columns. My question is: is there a way to input only wanted columns, i.e. var1, var1390,var3782, and var4703?

abcd123 · ‎05-21-2015

Thanks for reply. I am sure your method would work out, but I feel there should be a more xml-like way to do the job.

abcd123 · ‎05-21-2015

Hello, I am using proc sql pass through to extract xml data from a db2 server, the query looks like following: select xmlquery('data($DATA/*:annotation/*:EventStart/@data)') as MyData from db2server The returned data is like following: <?xml version="1.0" encoding="windows-1252" ?>1234567 But all I need is the numeric part, i.e., 1234567. How to remove the leading <?xml version="1.0" encoding="windows-1252" ?>? Thanks.

abcd123 · ‎09-01-2014

Thank you all so much for helpful discussion.

abcd123 · ‎08-31-2014

Thanks for help. Another question is: if I want to run a sql stored procedure, I have to use pass through (i.e., libname statement cannot run stored procedure), is this correct?

abcd123 · ‎08-30-2014

hello, the following statement runs successfully which will connect to the default database on My_DB2_Server_Name: CONNECT TO db2 as myDB2 (datasrc=My_DB2_Server_Name user = 'MyUserName' password = 'MyPassWord'); Now I want to connect to another database; I tried following 2 methods: CONNECT TO db2 as myDB2 (datasrc=My_DB2_Server_Name user = 'MyUserName' password = 'MyPassWord' database='AnotherDataBase'); CONNECT TO db2 as myDB2 (datasrc=My_DB2_Server_Name user = 'MyUserName' password = 'MyPassWord' schema="AnotherDataBase"); However, neither works. I know how to do change database connection using LIBNAME; however, is there a way we can specify the databse in the pass through? Thanks for your help.

Online Status	Offline
Date Last Visited	‎08-22-2017 05:19 PM

Re: variable reduction in Time series

variable selection

variable reduction in Time series

Re: SAS date input

SAS date input

Re: first row exceed 32767, lrecl not work

Re: first row exceed 32767, lrecl not work

first row exceed 32767, lrecl not work

Re: sas input selected columns

sas input selected columns

Re: error when assign macro variable

Re: WARNING: The quoted string currently being processed has become mo...

Re: open multiple SAS session

Re: variable reduction in Time series

variable selection

variable reduction in Time series

Re: SAS date input

SAS date input

Re: first row exceed 32767, lrecl not work

Re: first row exceed 32767, lrecl not work

first row exceed 32767, lrecl not work

Re: sas input selected columns

sas input selected columns

Re: sas proc sql pass through xml

sas proc sql pass through xml

Re: how to sepcify databse in proc sql pass through

Re: how to sepcify databse in proc sql pass through

how to sepcify databse in proc sql pass through