About user24feb

user24feb · ‎07-11-2014

Your Libname command looks o.k. Could it be that SAS Access to ODBC works under Windows and SAS Access to SQL is needed. You might need to contact product support.

user24feb · ‎07-10-2014

It's probably more complicated, but it sounds like %include might do. SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

user24feb · ‎07-10-2014

You could try the force option (Proc Append Base=XL_All Data=XL_&a. FORCE;) - but this will only work if the first data set is complete. If the files aren't too large "set" will do. Replace Proc Append Base=XL_All Data=XL_&a.; Run; With Data XL_All; Set XL_All XL_&a; Run;

user24feb · ‎07-10-2014

Hi! Try for example: Range="Sheet1$A2:E12". 5444 - How to read an Excel range into SAS using PROC IMPORT

user24feb · ‎07-10-2014

I had a similar problem once. If you modify this code (Excel Version!!) you might get a reasonable result. The aggregated file is called: XL_All. %Let Directory=C:\Users\xxxx; %Let XL_vers=ExcelCS; Filename Dir_Pipe PIPE "DIR &Directory. /B" LRecL=32767; Data Dir_List; Infile Dir_Pipe Truncover; Input Text $200.; Run; Data XL_List; Set Dir_List ; Where UpCase(Substr(Text,Index(Text,'.')+1,4)) in ("XLSX" "XLS"); Run; Proc SQL NoPrint; Select Text Into :XL_List Separated By '#' From XL_List; Quit; %Put **&XL_List.**; %Macro Import_XL(XL_List=); %Global i; %Let i=1; %Let Element=%Scan(&XL_List.,&i.,'#'); %Do %While ("&Element."^=""); %Put **&i.**&Element.**; Proc Import Out=XL_&i Datafile="&Directory.\&Element." DBMS=&XL_vers Replace; *Sheet=""; Run; %Let i=%Eval(&i.+1); %Let Element=%Scan(&XL_List.,&i.,'#'); %End; %Mend; %Import_XL(XL_List=&XL_List.); %Let i=%Eval(&i.-1); %Put **&i.**; %Macro Append_XL; Data XL_ALL; Set XL_1; Run; %If &i.=2 %Then %Do; Proc Append Base=XL_All Data=XL_2; Run; %End; %Else %Do; %Do a=2 %To &i; Proc Append Base=XL_All Data=XL_&a.; Run; %End; %End; %Mend; %Append_XL;

user24feb · ‎07-10-2014

Thanks to all. I've been playing around with the options a little. Maybe the batch process is the solution. (will mark as helpful answers as soon as I find the button .. )

user24feb · ‎07-09-2014

I didn't think of batches. Will try. 🙂 Is there a way to provent the enterprise guide from connecting to large data sets, if I only would like to get to a program file?

user24feb · ‎07-08-2014

P.S.: I guess you are aware that your question is a tricky one. If you ask your question this way, it is almost certain that the respondent puts his/her statistical reputation on the line. 🙂

user24feb · ‎07-08-2014

I think one statistally right way would be a seasonal Unit-Root-Test: Proc Arima Data=<Data_Set>; Identify Var=<Variable> Stationarity=(ADF=(1) DLag=12); /* Augmented Dickey-Fuller-Test with 1 autoregressive term; monthly data */ Identify Var=<Variable> (1) Stationarity=(ADF=(1) DLag=12); /* -"- in 1st differences */ Run; There are other tests as well (and simpler methods). For example if you have quaterly data and carry out a trend regression you might check the dummy-coefficients for statistical significance.

user24feb · ‎07-08-2014

Hello, I am using Enterprise Guide 6.1 (32 bit) and have a couple of questions regarding its optimal settings. 1. Are there recommended settings which are suitable for EG [6.1 M1 (6.100.0.4025) (32-Bit)] and SAS Base [SAS 9.4 TS Level 1M1 W32_7 PRO WindowsNT Server-Version] running under Windows 7 (32 bit, 4 GB RAM)? 2. When I switch between SAS-programs which have "large" data sets the EG starts working (on what I cannot tell) and will not stop. I assume that this has something to do with the size of the result files. I am not even interested in the data sets and only would like to reach the program code. Is there a possibility to either manage the memory/resources better or at least to turn off the connection (?) of a program to its data sets within the EG so that I can get to the mere program code? 3. If I try to quit a current EG-process using the Windows Task Manager I cannot restart my programmes because no lock for my data sets is available (which to some extent is clear, because I didn't close the EG properly, but I guess there should be a way to restart software without restarting the computer). Is there a way to restore a data-lock after the Task Manager interrupts? Thanks & kind regards

user24feb · ‎07-08-2014

Hi! I Think Proc Rank would be really an option: Proc Rank Data=In_File Out=Result Groups=10; Var <Variable>; Ranks <Group_Name>; Run;

user24feb · ‎07-07-2014

Thanks. I think TomKari is right, some text pre-processing (with "translate" or so) can´t be avoided. (Sorry, I didn´t mention that there are both values with and without a trailing minus). I will use: Number2=Input(Compress(Translate(Translate(TS,'','.'),'.',',')),TrailSgn15.); (In this case ',' is the decimal and '.' the thousands seperator). Data A; Input TS $20.; Sign=Index(TS,'-'); If Sign ge 1 Then Number=(Input(Substr(TS,1,Length(TS)-1),Commax15.3))*-1; Else Number=(Input(TS,Commax15.3)); Format Number 15.4; /* without Substr: */ Number2=Input(Compress(Translate(Translate(TS,'','.'),'.',',')),TrailSgn15.); Format Number2 15.4; Datalines; 100,008 100,008- 1555,458 1555,458- 2,04 2,04- 4.000,4 4.000,4- 112.000,4 112.000,4- 123.456.789,012 123.456.789,012- ; Run;

user24feb · ‎07-07-2014

Hello, is there a possibility to read data that has the trailing minus and a decimal seperator that is "," instead of "."? For example: 100,008- should give -100.008 (="minus one-hundred-point-zero-zero-eight" and NOT "minus hundred-thousand-and-eight"; that´s why Trailsgn15.3 does not work) Thanks & kind regards (My best guess would be (if TS is the input variable), but I am not really happy with this: Sign=Index(TS,'-')/Index(TS,'-'); If Sign eq 1 Then Number=(Input(Substr(TS,1,Length(TS)-1),Commax15.3))*-1; Else Number=(Input(TS,Commax15.3)); )

user24feb · ‎07-03-2014

%LET old_dt=%Sysfunc(PutN(%Sysfunc(IntNX(day,&start_dt.,-10)),Date9.));

user24feb · ‎05-28-2014

**If you copy-paste the entire code, hopefully (at least) one of the 3 ways to convert a number to a character variable should work; Data Sample_Data; Input Number Best12.; Datalines; 2 3 . 4 . 82 ; Run; Data S2; Set Sample_Data; Number_Character=Compress(""!!Number); Number_Character2=Strip(Put(Number,Best12.)); Number_Character3=CatX('',Number); Run; Proc Print Data=S2 NoObs; Run;

Online Status	Offline
Date Last Visited	‎09-02-2022 10:58 AM

Re: Macros

Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

data set for "simulation models .." by Erdman

Re: Saving Excel-dataset after modifying

Saving Excel-dataset after modifying

Re: Create and slice a sparse set of parameters in proc optmodel

Create and slice a sparse set of parameters in proc optmodel

Re: Conditionally define a constraint with proc optmodel

Re: Define Constraint for Proc Optmodel

Re: data set for "simulation models .." by Erdman

Re: PROC EXPORT to XLSX is creating a .bak file

Re: Saving Excel-dataset after modifying

Re: Passing a comma delimited variable to a Macro

Re: log summary is blank

Re: import excel from , skipping first 7 lines

Re: data set for "simulation models .." by Erdman

Re: Splitting a macro variable string into 2

Re: SAS ODBC to SQL Server issues

Re: Help with Calling SAS file to run

Re: How to read all *.xls-files from a folder into SAS and make one sa...

Re: How to read all *.xls-files from a folder into SAS and make one sa...

Re: How to read all *.xls-files from a folder into SAS and make one sa...

Re: Stability issues with EG 6.1

Re: Stability issues with EG 6.1

Re: Seasonal Factors

Re: Seasonal Factors

Stability issues with EG 6.1

Re: grouping in macro

Re: Trailsgn Informat if decimal mark is a comma

Trailsgn Informat if decimal mark is a comma

Re: create macro to go back from start date

Re: Not able to convert numeric variable to character