About user24feb

user24feb · ‎02-10-2017

For your example: Data A; Input ID A1 $ A2 $ A3 $ A4 $ A5 $; Datalines; 1234 abc def abc def . 1235 abc abc abc abc . 1236 abc . . . . 1240 asf abc asf def asf 1245 abc def asf ghi jkl 1251 asf abc . . . 1252 abc abc . . . ; Data B1 (Drop=i j); Set A; Array A{*} A:; Do i=1 To Dim(A); Do j=i To Dim(A); If (A{j}=A[i}) & (i^=j) Then Call Missing (A{j}); End; End; Run;

user24feb · ‎02-02-2017

%Let Alert=2017-01,2017-02,2017-03; %Let Alert_Where=%BQuote(%Str(%')%Sysfunc(TranWrd(%BQuote(&Alert.),%Str(,),%Str(%', %')))%Str(%')); %Put ***&Alert_Where.***; * .. but don't do this, if it comes from a data set then use Proc SQL; Data Dates; D='2017-01'; Output; D='2017-02'; Output; D='2017-03'; Output; Run; Proc SQL NoPrint; Select Catt("'",D,"'") Into :Alert_Where_SQL Separated By ',' From Dates; Quit; %Put ***&Alert_Where_SQL.***; * .. else define Alert the way you need it in the first place; %Let Alert_Comma='2017-01', '2017-02' ,'2017-03' ; %Put ***&Alert_Comma.***;

user24feb · ‎02-02-2017

Maybe you had your log redirected. Try "proc printto; run;".

user24feb · ‎02-02-2017

When you run a SAS-program ("run;"), SAS scans for macro statements and variables ("%let" and "&xx."). If it finds macro-code the SAS-macro-processor resolves the macro-statements, this is it replaces for example "&var." with the content of &var or it increments a macro-variable "%eval(&var.+1)" or something else. Eventually, the SAS-program - with the resolved macro variables (!) - is executed.

user24feb · ‎01-03-2017

Either Select * From xxx (Where=(Date=Today())); * .. OR ..; Select * From xxx Where Date=Today(); * ??;

user24feb · ‎01-03-2017

Data A; Input Text : $ Nr @@; Datalines; The 1 cow 2 jumps 3 over 4 the 5 moon 6 ; ***2nd select did not really make sense ..*; Proc SQL; Create Table B As Select a1.Text As Text1,a2.Text As Text2 From A a1,A a2 Where a1.Nr lt a2.Nr ; Quit;

user24feb · ‎11-15-2016

.. a random one, since the solution is not unique.

user24feb · ‎11-15-2016

Hello, I am looking for an SQL-equivalent to this: Data A; Infile Datalines DLM='09'x; Format ID $15.; Input ID $ Costs ; ID_short=Scan(ID,1,'_'); Datalines; 460_01 45 460_02 50 460_03 60 461_01 99 461_02 98 461_03 100 463_01 45 463_02_469_01 40 463_03_469_01 40 463_04_469_01 40 463_05 55 ; Run; Proc Means Data=A NoPrint; By ID_Short; Var Costs; Output Out=B (Drop=_:) MinID(Costs(ID))=ID Min=; Run; .. the problem ist of course, that there are multiple results for ID_short='463'. Thx

user24feb · ‎11-15-2016

/* Appending the above dataset using Do loop */ %MACRO TEST; %DO i=1 %TO 3 ; %If &i.=1 %Then %Do; Data Append_DT; Set A_&i.; Run; %End; %Else %Do; Proc Append Base=Append_DT Data=A_&i.; Run; * OR:; /* Data Append_DT;*/ /* Set Append_DT A_&i.;*/ /* Run;*/ %End; %END; PROC PRINT DATA = APPEND_DT; RUN; %MEND; %TEST;

user24feb · ‎11-08-2016

I believe you are trying to do something like this (and I agree with Astounding that it is not certain that you really will run out of memory): Data Have; Input V1 $ Date Date9.; Format Date Date9.; Datalines; MS000328 04JAN16 MS000328 08JAN16 MS000328 12JAN16 MS000328 08FEB16 MS000328 09FEB16 MS000328 12MAR16 MS000328 15MAR16 MS000328 16APR16 MS000328 17APR16 MS000329 02JAN16 MS000329 16JAN16 MS000329 29JAN16 MS000329 03FEB16 MS000329 19FEB16 MS000329 21MAR16 MS000329 31MAR16 MS000329 11APR16 MS000329 19APR16 ; Run; * List of Dates; Data Dates (Keep=Date); Format Date Date9.; Do i=0 To 365; Date=IntNX('day','01JAN2016'd,i); Output; End; Run; * List of V1s; Proc SQL; Create Table V1_IDs As Select Distinct V1 From Have Order By V1; Quit; * Full structure; Proc SQL; Create Table Want As Select * From V1_IDs,Dates; Quit;

user24feb · ‎11-08-2016

Why: Because a time series has to be stationary (=time-invariant) to be modeled (with ARIMA). Stationarity includes variance stationarity. Why log: Because it is easy and it is often able to stabilize the variance.

user24feb · ‎10-17-2016

I think it is actually a proc-sql-select-into-question then: Proc SQL NoPrint; Select Max(NObs) Into :NObs Trimmed From (Select Count(*) As NObs From Sashelp.Class); Quit; %Macro OutputSingleLine; %Do i=1 %To &NObs.; Data DS&i.; Set Sashelp.Class (Firstobs=&i. Obs=&i.); Run; %End; %Mend; %OutputSingleLine;

user24feb · ‎10-17-2016

I think that every macro solution is more complicated than a data step. Try: Data _NULL_; Set Sashelp.Class; i+1; Call Execute("Data xxx"!!Strip(Put(i,Best.))!!";"); Call Execute(" Set Sashelp.Class (Firstobs="!!Strip(Put(i,Best.))!!" Obs="!!Strip(Put(i,Best.)) !!");"); Call Execute("Run;"); Run;

user24feb · ‎10-12-2016

Not sure, if I understood you correctly: ODS Output ParameterEstimates=Est; Proc ARIMA Data=A; Identify Var=x CrossCorr=(y z r); Estimate p=1 q=1 Input=(y z r); Run; ODS Output Close; Data Sensitivity1Pct (Keep=Parameter Variable Sensitivity); Set Est; Sensitivity=Estimate*0.01; Run;

user24feb · ‎09-28-2016

DBMS=Excel + Datarow does not work for me either. DBMS=XLSX + Datarow should work.

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: Removing duplicate values

Re: PROC SQL and MACROS

Re: log summary is blank

Re: SAS Macro Variable

Re: Proc SQL - Import a table function

Re: making all possible combinations of all words from a given string(...

Re: Proc-SQL-MINID-equivalent

Proc-SQL-MINID-equivalent

Re: Appending dataset in Macro loop

Re: How to add continuous dates in the column - a range of dates as im...

Re: Why take the log transformation of data

Re: subsetting each row into new dataset using macros?

Re: subsetting each row into new dataset using macros?

Re: How to perform a What-If Analysis in SAS/ETS

Re: import excel from , skipping first 7 lines