About StephanDup

Kurt_Bremser · ‎10-31-2017

@StephanDup wrote: Thank you very much. It worked! How do I keep other variables of ds1 as well (such as ID)? Either put them into ds2 when you create it, or insert them in the first call execute in the keep statement. Or you could turn the logic around and create ds2 with variable names to be dropped, and create a drop statement with call execute.

StephanDup · ‎10-31-2017

Thank you so much!

Astounding · ‎10-30-2017

@Ksharp gets partial credit here. It's the right statement to add, but has to be added in exactly the right place. In a DATA step, _numeric_ refers to all numeric variables that have been defined so far. To get rid of the original numeric variables, the order of the statements must specifically be: array vars {*} _numeric_; drop _numeric_; array L1vars ......... That's the only point in your DATA step where _numeric_ refers to all the original numeric variables coming from HAVE. (Yes, technically the DROP statement could come between the SET statement and the first ARRAY statement.)

Ksharp · ‎10-25-2017

data have; infile cards truncover; retain id 1; input Date $ Var1 Var2 Var3 Var3000; cards; 10/25 5 2 1 8 10/24 10/23 10/22 10/21 2 4 2 6 10/20 10/19 10/18 10/17 4 5 1 7 ; run; data want; update have(obs=0) have; by id; output; drop id; run;

Online Status	Offline
Date Last Visited	‎11-01-2017 09:15 AM

Re: Selecting variables from another data set

Selecting variables from another data set

Re: Replacing missing values with next and previous values

Replacing missing values with next and previous values

Drop an entire array after using it

Re: Replace missing values with previous values

Replace missing values with previous values

Re: Selecting variables from another data set

Re: Replacing missing values with next and previous values

Re: Drop an entire array after using it

Re: Replace missing values with previous values