About RandyStan

RandyStan · ‎02-13-2020

Dear All: I want to create 10 groups for the variable VARA using the 0/1 flag. So my data is as follows VarA Flag 10 0 8 0 11 1 24 1 35 0 and so forth I want to group the data by VARA and the flag. So I want VarA Flag Group_FLAG_0 Group_FLAG_1 10 0 8 0 11 1 24 1 35 0 Can this be done in one step. Thanks in advance Randy

RandyStan · ‎02-02-2020

Dear All My data is as follows Date ID VarA 01JAN2019 A 45 02JAN2019 A 16 05JAN2019 A 27 09JAN2019 A 45 08JAN2019 B 65 10JAN2019 B 14 15MAR2019 B 26 09SEP2019 B 25 25OCT2019 B 25 I want to construct a lag_VARA and resset the counter to 0 after the date 01SEP2019. 01SEP2019 is an example of the date from which the data becomes available once again. So the data I want would look as follows: Date ID VarA lag_VARA 01JAN2019 A 45 . 02JAN2019 A 16 45 05JAN2019 A 27 16 09JAN2019 A 45 27 08JAN2019 B 65 . 10JAN2019 B 14 65 15MAR2019 B 26 14 09SEP2019 B 25 . 25OCT2019 B 25 25 Please help. Randy

RandyStan · ‎02-02-2020

Sorry for the late reply. Thank you so much, your solution worked.

RandyStan · ‎01-23-2020

I have to reset Var_AGG after 01JUL2019

RandyStan · ‎01-23-2020

Dear All: I asked a Summing question yesterday, but the problem is a little more complicated. My data by ID is as follows My data is as follows. DATE ID Time VariableA VariableB 01JAN2019 X 9:30:05 B 100 01JAN2019 X 9:30:08 S -25 02JAN2019 X 10:45:45 S -25 02JAN2019 X 11:26:13 B 35 03JUL2019 X 13:15:58 B 205 03JUL2019 X 13:45:08 S - 45 05JAN2019 Y 14:45:05 S -145 05JAN2019 Y 15:15:06 B 130 06JAN2019 Y 13:02:09 B 150 07AUG2019 Y 10:55:08 B 200 07AUG2019 Y 12:13:57 S -150 09OCT2019 Y 11:33:45 B 50 I need to sum VARB but after 01JUL2019 the counter resets to 0. So the data I want is DATE ID Time VariableA VariableB Var_AGG 01JAN2019 X 9:30:05 B 100 100 01JAN2019 X 9:30:08 S -25 75 02JAN2019 X 10:45:45 S -25 50 02JAN2019 X 11:26:13 B 35 85 03JUL2019 X 13:15:58 B 205 205 03JUL2019 X 13:45:08 S -45 160 05JAN2019 Y 14:45:05 S -145 -145 05JAN2019 Y 15:15:06 B 130 -15 06JAN2019 Y 13:02:09 B 150 135 07AUG2019 Y 10:55:08 B 200 200 07AUG2019 Y 12:13:57 S -150 50 09OCT2019 Y 11:33:45 B 50 100 The code I wrote for the simple summing is data want ; set have ; by date ID VariableB; If first.ID then VAR_AGG = 0 ; VAR_AGG + VARIABLEB ; run; But how do I reset the counter after 01JUL2019? Thanks in a advance

RandyStan · ‎01-22-2020

Yes that is true. The reason is a quarters worth of missing data and the data is again available after a quarter.

RandyStan · ‎01-22-2020

On the date; July 3, 2020 (03JUL2020)

RandyStan · ‎01-22-2020

Dear All My data is as follows. On July 3 2020 VariableC should restatrt the Aggregation DATE Time VariableA VariableB Var_AGG 01JAN2020 9:30:05 B 100 100 01JAN2020 9:30:08 S 25 75 02JAN2020 10:45:45 S 25 50 02JAN2020 11:26:13 B 35 85 03JUL2020 13:15:58 B 205 205 03JUL2020 13:45:08 S 45 160 On July 3 2020 VariableC should restatrt the Aggregation. And the needed data is as follows DATE Time VariableA VariableB Var_AGG 01JAN2020 9:30:05 B 100 100 01JAN2020 9:30:08 S 25 75 02JAN2020 10:45:45 S 25 50 02JAN2020 11:26:13 B 35 85 03JUL2020 13:15:58 B 205 205 03JUL2020 13:45:08 S 45 160 Can someone please help. Thank you in advance. Randy

RandyStan · ‎11-30-2019

Dear All: My code is proc freq data = have ; table X*y / norow nocol ; weight V ; run; Can I output the table to CSV (preferable) or RTF format. Also how can I output the results to a SAS data set? Randy

RandyStan · ‎11-12-2019

Dear All My data is as follows ID IDA CO CO I I HUF HUF . . B B I want to fill in the two missing values in IDA ID IDA CO CO I I HUF HUF . NO_CAT . NO_CAT B B I wrote these lines Data want; set have; if IDA = '.' then do ; IDA = NO_CAT: end ; run; What mistake am I making Randy

RandyStan · ‎09-21-2019

Dear All My Data is as follows ID_B ID_S VarA A B 10 A C 10 C D 10 C A 10 D B 15 A A 5 C B 10 B B 20 A C 10 The total of VarA is 100 I want to construct the following two tables The first with the raw numbers A B C D A 5 10 20 0 B 0 20 0 0 C 10 10 0 10 D 0 15 0 0 And Then I want the Table in Percentages A B C D A 0.05 0.1 0 0.2 0 B 0 0.2 0 0 C 0.1 0.1 0 0 0.1 D 0 0.15 0 0 Thanks in advance Randy

RandyStan · ‎09-17-2019

Hi Tom: Sorry for not getting back earlier in the day. This is a trading data set and there are multiple observations for other variables on a particular date. The study is an event study where the window opens some days prior to the event and shuts some days after the event. The event date is flagged as VarA = 1 and VarB = 1. For a normal event study the code is simple (from the SA s Boards) data want; x='15JAN2019'd; fivedaysprior = intnx('day',x,-5); twodaysafter = intnx('day',x,2); format x fivedaysprior twodaysafter date9.; run; But what is complicating is that there are multiple events and multiple observations of other variables on the same day. Does anyone have any suggestions? Randy

RandyStan · ‎09-17-2019

Tom: I do not follow your question

RandyStan · ‎09-16-2019

Since there is no 06/25/2019 the flag should go to 06/26/2019. As I have noted earlier the date series is not continuous.

RandyStan · ‎09-16-2019

Just added 0's to the table Date VarA VarB VarA_BF VarB_BF 6/20/2019 0 0 0 1 6/20/2019 0 0 0 1 6/20/2019 0 0 0 1 6/20/2019 0 0 0 1 6/21/2019 0 0 1 1 6/21/2019 0 0 1 1 6/21/2019 0 0 1 1 6/22/2019 0 1 1 1 6/22/2019 0 1 1 1 6/22/2019 0 1 1 1 6/22/2019 0 1 1 1 6/23/2019 1 0 1 1 6/23/2019 1 0 1 1 6/23/2019 1 0 1 1 6/24/2019 0 0 1 1 6/24/2019 0 0 1 1 6/24/2019 0 0 1 1 6/24/2019 0 0 1 1 6/26/2019 0 0 1 0 6/26/2019 0 0 1 0 6/27/2019 0 0 0 0 6/27/2019 0 0 0 0 6/27/2019 0 0 0 0 6/28/2019 0 0 0 0

Online Status	Offline
Date Last Visited	‎12-23-2022 05:36 PM

Re: Removing Duplicates by ID 1

Removing Duplicates by ID 1

Removing Duplicates by classes

Changing Format and Informat

Importing Files

Dropping a group while taking the mean

If then statement with conditions

First and last observations

Re: Forming time groups

Forming time groups

Previous observatio as last observation if missing

Grouping by flag

Lagging

Re: Aggregating /Summing

Re: Aggregating /Summing

Aggregating /Summing

Re: Summing

Re: Summing

Summing

ODS output

Filling in Missing Values

Constructing Tables

Re: Dates backward and forward

Re: Dates backward and forward

Re: Dates backward and forward

Re: Dates backward and forward