About user24feb

user24feb · ‎07-29-2014

.. but you don't need the macro. If you replace the data _NULL_ with: data _NULL_; set test; Do x=1 To &num.; %Let digit=10000; If dept < 10 and round (payment,&digit.)>=50000 Then Do; Put Staff= Dept= Payment=; Return; End; End; run;

user24feb · ‎07-28-2014

Something like: Proc Import Datafile = "C:\Path\XL_FILE.xlsx" /* change path and name */ Out = SAS_XL_File DBMS = Excel2007 /* .. if it is XL 2007 .. */ Replace; Getnames=Yes; /* .. the first line will become the variable names */ Range="Sheet1$B12:Y12"; /* don't forget the $ between sheet name and the Excel cells .. */ Run;

user24feb · ‎07-22-2014

If you try Proc Varmax Data=sim_data; Model spend1 spend2 prod1 prod2 / p=2 Trend=Linear; /* or Quad */ ID Time Interval=Month; /* if it is Month .. */ Run; instead of proc varmax data=sim_data noprint; model spend1 spend2 prod1 prod2 = time_period / p=2 xlag=0; run; ?

user24feb · ‎07-22-2014

I think you need options: Tools►Options from the menu at the top of the application. Select the Custom Code option in the selection pane, and then select both the Insert custom SAS code before task and query code and Insert custom SAS code after task and query code check boxes. Click the Edit button for the "before" code and type options missing = " ";. Click Save. To reset the option for other items that are run, such as code for SAS programs, change the option back. Click the Edit button for the "after" code and type options missing = ".";. Click Save►OK. http://support.sas.com/resources/papers/proceedings10/145-2010.pdf

user24feb · ‎07-22-2014

Just some ideas, if you have for example monthly data: - proc arima and a "Var=<Variable> MiniC P=(0:12) Q=(0:12);"-statement, but you probably never would have a MA(5,7,11) or so and you would have to repeat this for the cases of differencing, seasonal differencing, taking logs, etc. - de-seasonalize the data using proc expand or proc x11 and use minic of a low order afterwards - pre-define simple (to avoid over-fitting), but "propable" models (AR(1), AR(1,2), AR(1)(12), etc.) and find the model with the lowest SBC "manually" (or with clever code)

user24feb · ‎07-21-2014

Hi! Another option would be the windows task scheduler .. http://support.sas.com/resources/papers/proceedings11/005-2011.pdf

user24feb · ‎07-17-2014

%Symexist is the function I think you are looking for. SAS(R) 9.2 Macro Language: Reference

user24feb · ‎07-17-2014

Hi! The Akaike (AIC) or the Schwarz-Bayesian (SBC) criterion can be used to determine the proper order of p. It is in the SAS output.

user24feb · ‎07-17-2014

Hi! Thanks for your reply. You are right, sub-levels of by-products technically seem not make sense. The correct product structure and part master would be: Data ProductStructure; Input Product $ Component $ Qty; Datalines; P2 C1 0.80 P2 C4 0.35 P2 C5 -0.1 C1 C11 0.30 C1 C12 0.50 C1 C5 0.25 ; Run; Data PartMaster; Input Descr $ Text $35.; Datalines; P2 Product_2 C1 Component_1 C4 Component_4 C5 Byproduct_of_P2_and_Component_of_C1 C11 Subcomponent_1 C12 Subcomponent_2 ; Run; Proc BOM Data=ProductStructure PMData=PartMaster Out=BOM_Result ; Structure / Part=Descr Parent=Product Component=Component Quantity=Qty ID=(Text) ; Run; The problem is, that the by-product (C5) occurs as input and output (exactly the same name and material number), this is I can´t directly use a "Is_Output_or_Input"-Flag or so (would have to add the flag to ID, then proc bom, then correct result). The quantities cannot cancel out each other because they are on different levels of the b-o-m. Sorry that I didn't get the product structure right the first time. Graphically, what I mean is:

user24feb · ‎07-15-2014

Not sure if I understood your question properly, but if you are simply looking for a way to check where the result data is use "ods trace on" to find out the name (SAS(R) 9.2 Output Delivery System: User's Guide) and "ods output" to get the data.

user24feb · ‎07-15-2014

less elegant, but if you don´t care to sort and merge: Proc Sort Data=have; By name; Run; Proc Freq Data=Have NoPrint; Tables name / Out=Have_F (Keep=Count name); Run; Data Want (Where=(Count ge 2)); Merge Have (in=inH) Have_F (in=inF); By Name; If inH; Run;

user24feb · ‎07-15-2014

If you define a macro-variable as %global you can use it in different macros (?) Parameters are passed this way: %Macro xxx(Var1=); .. code .. %Mend; %xxx(Var1=123);

user24feb · ‎07-14-2014

another try (can't see whether you have 2 variables or 1, but) use DHMS: Data A; Input Text_DT $19.; Datalines; 28-05-2014 10:21:20 27-05-2014 14:22:26 27-05-2014 11:36:33 27-05-2014 17:14:55 27-05-2014 10:34:56 27-05-2014 19:03:48 27-05-2014 14:30:56 ; Run; Data B; Set A; DT=DHMS(Input(Scan(Text_Dt,1,' '),DDMMYY10.),Scan(Scan(Text_DT,2,' '),1,':'),Scan(Scan(Text_DT,2,' '),2,':'),Scan(Scan(Text_DT,2,' '),3,':')); Format DT DateTime19.; Run;

user24feb · ‎07-14-2014

Hello! I have to deal with a product structure that includes by-products. For example (sample code below), product P2 requires per unit 0.8 units of component C1 and 0.5 units of component C4, resp. In addition, the production step yields .25 units of by-product C5. My question is, whether there is a structured approach to deal with this. I think that I can get to the desired result by some data manipulation (checking if a component has a predecessor which is a by-product), but I am looking for a way to get there without doing too much "violence" to the data. Thanks&kind regards An example code would look like this (gives a wrong result due to the negative product component): Data ProductStructure; Input Product $ Component $ Qty; Datalines; P1 C1 0.60 P1 C2 0.30 P1 C3 0.40 P1 C4 0.05 P2 C1 0.80 P2 C4 0.50 P2 C5 -0.25 C1 C11 0.30 C1 C12 0.15 C1 C13 0.15 C5 C51 0.50 C5 C52 0.50 ; Run; Data PartMaster; Input Descr $ Text $15.; Datalines; P1 Product_1 P2 Product_2 C1 Component_1 C2 Component_2 C3 Component_3 C4 Component_4 C5 Byproduct_5 C11 Subcomponent_1 C12 Subcomponent_2 C13 Subcomponent_3 C51 Subbyproduct_1 C52 Subbyproduct_2 ; Run; Proc BOM Data=ProductStructure PMData=PartMaster Out=BOM_Result ; Structure / Part=Descr Parent=Product Component=Component Quantity=Qty ID=(Text) ; Run;

user24feb · ‎07-11-2014

.. I like that a lot. But I think I would have to use Reverse('.xlsx') to avoid typos.

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: Exit macro within loop

Re: Importing specific Excel .xlsx rows

Re: varmax independent variables time trend

Re: User Defined Missing Values in Enterprise Guide

Re: automatic arima modeling with proc arima

Re: /* How can i schedule the projects in base SAS 9.3 */

Re: Condintional macro based upon if macro variable exists, another co...

Re: VAR Granger Causality- Proc Varmax

Re: By-products in bill-of-materials (Proc BOM)

Re: Principal components for 10000 variable dataset

Re: Miss Match data from same dataset (get duplicates)

Re: sharing variables between macros

Re: How to convert character datetime to numeric datetime?

By-products in bill-of-materials (Proc BOM)

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