SAS Support Communities

RandyStan · ‎12-23-2022

Sincere apologies Row IDA IDB Cat VarA 1 A 1 1 7 2 A 1 1 9 3 B 1 1 7 4 B 1 1 10 5 B 2 1 11 6 A 1 2 12 7 A 1 2 14 8 A 2 2 16 9 C 1 3 12 10 C 1 3 14 Row IDA IDB Cat VarA 1 A 1 1 7 3 B 1 1 7 5 B 2 1 11 6 A 1 2 12 8 A 2 2 16 9 C 1 3 12

RandyStan · ‎12-23-2022

Dear All My data is as follows IDA IDB Cat VarA A 1 1 7 A 1 1 9 B 1 1 7 B 1 1 10 B 2 1 11 A 1 2 12 A 1 2 14 A 2 2 16 C 1 3 12 C1 1 3 14 I want the following table as output removing the duplicates and just keeping the first observation for IDA IDB for each CAT IDA IDB Cat VarA A 1 1 7 B 1 1 7 B 2 1 11 A 1 2 12 A 2 2 16 C 1 3 12 The code I wrote was proc sort data = have; by IDA IDB Cat ; run; data want ; set have by IDA IDB Cat ; if first.Cat then output ; run; Am I making a mistake somewhere? run;

RandyStan · ‎12-22-2022

Dear All My Data is as follows ID VarA Cat A 5 1 A 6 1 A 4 1 B 3 1 B 7 1 D 6 2 D 1 2 E 7 2 G 4 3 I want to keep just one ID from each CAT So my data should look like ID VarA Cat A 5 1 B 3 1 D 6 2 E 7 2 G 4 3 Can someone please help Thanks in advance Randy

RandyStan · ‎12-19-2022

Dear All: I have two variables and I want to change the format and informat of these variable VarA has Format BEST12. INFORMAT BEST32. I want to change it to BEST12. and BEST12. Var_B has $13. as the format and $13. as the INFORMAT I want to change it to $12. as the format and $12. as the Informat Can someone please help Randy

RandyStan · ‎10-10-2022

Dear All: Var_A Var_B Var_C Var_D 1003 1000Z ACZ PET 1006 400BA PQR DON The Code I wrote: Infile 'C:\Temp\have.csv' DLM = ',' Lrecl = 32000 DSD Truncover firstobs = 1; Input Var_A Var_B Var_C Var_D $50.; run; What is the mistake that I am making? Thank you in advance

RandyStan · ‎10-07-2022

Dear All: My SAS Data is as follows Date Group Var_A 02OCT2020 0 22 02OCT2020 1 28 02OCT2020 2 33 03OCT2020 0 55 03OCT2020 1 75 03OCT2020 2 86 I want to take the mean of VAR_A by excluding Group 0 from the calculation. There is a long method of doing this by creating a new data set excluding 0. Is there a shorter way to do this so that I can preserve the data set. Thanks much

RandyStan · ‎10-07-2022

Dear All: I am trying a IF/THEN statement and I do not seem to get the syntax. The conditions are as follows If Year < 2015 and date not between 24SEP2014 and 08OCT2014 and Group_ID >15 then Group_ID = 14 Data want ; set have ; if Year <2015 and date NE (24SEP2014 le 08OCT2014) and Group_ID > 15 then do; Group_ID = 14; run; I do not seem to get the date statement correctly. Please help. Thanks in advance

RandyStan · ‎10-05-2022

Dear All: May data set is as follows Date ID VarA Interval 01JAN 2019 A 22 1 01JAN 2019 A 26 1 01JAN 2019 A 21 1 01JAN 2019 A 24 2 01JAN 2019 A 27 2 01JAN 2019 B 19 1 01JAN 2019 B 23 1 01JAN2019 B 16 7 02JAN 2019 A 95 1 02JAN 2019 A 62 1 02JAN 2019 A 21 1 02JAN 2019 A 43 2 02JAN 2019 A 51 2 02JAN 2019 B 33 1 02JAN 2019 B 45 5 02JAN2019 B 56 5 I want my data to be as follows: Date ID Interval VarA_FO VarA_LO 01JAN 2019 A 1 22 21 01JAN 2019 A 2 24 27 01JAN 2019 B 1 19 23 01JAN2019 B 7 16 16 /* FO = LO */ 02JAN 2019 A 1 95 21 02JAN 2019 A 2 43 51 02JAN 2019 B 1 33 33 /* FO = LO */ 02JAN 2019 B 5 45 56 Thanks in advance. Randy

RandyStan · ‎10-05-2022

Thanks much

RandyStan · ‎10-03-2022

Dear All: Here is the code I wrote: Data want ; set have; if Year < 2015 then VarA = INTCK ('Minute25.' , '10:00:00't , time); else if year >= 2015 then VarA = INTCK ('Minute25.' , '09:15:00't, time) ; run; I cannot get the 25 minute intervals starting at different times for the different years. What mistake am I making? Randy

RandyStan · ‎07-11-2021

I hope this is what was wanted. Thanks much data WDBV; input ID date DATE9. ; cards ; 1 01JUL2021 1 02JUL2021 1 06JUL2021 1 09JUL2021 2 02MAR2021 2 09MAR2021 2 12MAR2021 3 14MAY2021 ; What I need is ID Date Work_Days_Between_Visits 1 01JUL2021 1 02JUL2021 0 1 06JUL2021 0 1 09JUL2021 2 2 02MAR2021 2 09MAR2021 4 2 12MAR2021 2 3 14MAY2021

RandyStan · ‎07-11-2021

Thank you. I want the first value to be a NULL value. So I randomly chose -50000. The date format is DATE9. SAS date format. The file is attached.. In this file I left the first cell of each ID blank to indicate a NULL value. Thank you so much

RandyStan · ‎07-10-2021

Dear All: My data is as follows: ID Date 1 01JUL2021 1 02JUL2021 1 06JUL2021 1 09JUL2021 2 02MAR2021 2 09MAR2021 2 12MAR2021 3 14MAY2021 I want Work Days Between Trades and my data should be as follows. The first observation of each ID should be -50000 ID Date Work_Days_Between_Visits 1 01JUL2021 -50000 1 02JUL2021 0 1 06JUL2021 0 /* 5 July was a Holiday*/ 1 09JUL2021 2 2 02MAR2021 -50000 2 09MAR2021 4 2 12MAR2021 2 3 14MAY2021 -50000 Please Help. And Thanks in Advance

RandyStan · ‎02-10-2021

Dear All: I have over a hundred ID values. I want to extract just 5 to conduct a preliminary analysis. The code I wrote Proc sort data = have ; by ID ; run; Data want; set have; If ID = '345' or ID = '650' or ID = '656' or ID = '700' or ID = '725' then output; run; Is there a shorter way of writing this code to extract the first 5 ID values. Randy

RandyStan · ‎02-09-2021

Dear All Just to clarify I want to split the data into files both in SAS and CSV format Thank you

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

SAS Support Communities

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

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

Re: Difference between days

Re: Difference between days

Difference between days

Extracting ID's

Re: Splitting a data set into many different files

Follow Us

What is...