cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vraj1
‎01-24-2023
  • 272 Posts
  • 24 Likes Given
  • 1 Solutions
  • 3 Likes Received

Re: how splie records based on start and end dates

by Quartz | Level 8 in SAS Programming
‎10-10-2018 06:06 AM
‎10-10-2018 06:06 AM
Sorry kurt i just realised that. it should only split 2 days for first 2 times and the rest should be as it is. I am very sorry for confusion.  if first.id then it should split num 2 times and the rest of dates should be as it is  data have; infile datalines dsd truncover; input id num (start end) (:date9.); format start end date9.; datalines4; 101,2,12MAR2018,18MAR2018 101,3,15MAR2018,19MAR2018 101,4,20MAR2018,29MAR2018 102,2,12JAN2018,19JAN2018 102,3,20JAN2018,28JAN2018 102,4,29JAN2018,12FEB2018 102,5,13FEB2018,18FEB2018 102,6,19FEB2018,28FEB2018 ;;;; run; data want; infile datalines dsd truncover; input id num (start end) (:date9.); format start end date9.; datalines4; 101,2,12MAR2018,13MAR2018 101,2,14MAR2018,15MAR2018 101,2,16MAR2018,18MAR2018 101,3,15MAR2018,19MAR2018 101,4,20MAR2018,29MAR2018 102,2,12JAN2018,19JAN2018 102,3,20JAN2018,28JAN2018 102,4,29JAN2018,12FEB2018 102,5,13FEB2018,18FEB2018 102,6,19FEB2018,28FEB2018 ;;;; run; very sorry for the confusion ... View more

Re: how splie records based on start and end dates

by Quartz | Level 8 in SAS Programming
‎10-10-2018 04:22 AM
‎10-10-2018 04:22 AM
odd means if duration of start and end is 5 days and i want to split on 2 days each than 2 rows with 2 days duration and one row with 1 day. I am looking only for days and it will be continous start and end for one id  ... View more

how splie records based on start and end dates

by Quartz | Level 8 in SAS Programming
‎10-10-2018 03:36 AM
‎10-10-2018 03:36 AM
I have id's along with num- i need to spliet the same id and num basis on start and end  by 2. and if the duration is 5 days than 3 records with start and end in which 2 will have start and end seperate dates and one record with same date as they are odd.     data WORK.TEST; infile datalines dsd truncover; input id:32. num:32. start:DATE9. end:DATE9.; datalines4; 101,2,12MAR2018,14MAR2018 101,3,15MAR2018,19MAR2018 101,4,20MAR2018,29MAR2018 102,2,12JAN2018,19JAN2018 102,3,20JAN2018,28JAN2018 102,4,29JAN2018,12FEB2018 102,5,13FEB2018,18FEB2018 102,6,19FEB2018,28FEB2018 ;;;; Need something like this data WORK.want; infile datalines dsd truncover; input id:32. num:32. start:DATE9. end:DATE9.; datalines4; 101,2,12MAR2018,14MAR2018 101,3,15MAR2018,16MAR2018 101,3,17MAR2018,18MAR2018 101,3,19MAR2018,19MAR2018 101,4,20MAR2018,21MAR2018 101,4,20MAR2018,21MAR2018 101,4,22MAR2018,23MAR2018 101,4,24MAR2018,25MAR2018 101,4,26MAR2018,27MAR2018 101,4,28MAR2018,29MAR2018 ;;;; any help please ... View more

Re: new record based on condition

by Quartz | Level 8 in SAS Programming
‎10-09-2018 10:58 AM
‎10-09-2018 10:58 AM
Thanks a lot. Will this work no matter where the OVER record is. sometimes it can be in num 4 or num7? As i removed firstobs=2 then it didnt work.     ... View more

new record based on condition

by Quartz | Level 8 in SAS Programming
‎10-09-2018 08:08 AM
‎10-09-2018 08:08 AM
data WORK.INC1; infile datalines dsd truncover; input ENDT:DATE9. STD:DATE9. menu:$4. id:32. day:32. adj:$200. num:$3.; datalines4; 07NOV2016,02NOV2016,IDEA,10001,,,2 14NOV2016,08NOV2016,IDEA,10001,1,OVER,3 28NOV2016,15NOV2016,IDEA,10001,,,4 14SEP2016,29NOV2016,IDEA,10001,,,5 ;;;; In the above test data if i have adj="OVER" then i need to create a new record before it i.e in example it is num=3 which has OVER. I need to create num=2 and minus number of day in num=2 whci has 07nov2016(end-day) and new record as 07NOV2016,07NOV2016,IDEA,10001,,OVER,2 data WORK.INC12; infile datalines dsd truncover; input ENDT:DATE9. STD:DATE9. menu:$4. id:32. day:32. adj:$200. num:$3.; datalines4; 06NOV2016,02NOV2016,IDEA,10001,,,2 07NOV2016,07NOV2016,IDEA,10001,1,OVER,2 14NOV2016,08NOV2016,IDEA,10001,,,3 28NOV2016,15NOV2016,IDEA,10001,,,4 14SEP2016,29NOV2016,IDEA,10001,,,5 ;;;; Can anyone guide me how to get the inc12 dataset attached with input as inc1. I have made test data for 1 id but they are many id's with different menu.   Any help?   ... View more

need to create value based on increment on days

by Quartz | Level 8 in SAS Programming
‎10-09-2018 01:20 AM
‎10-09-2018 01:20 AM
data want; set test(drop=exd); by id day; if first.id then call missing(_cp, _co); if period='A' then do; if ext='pine' then do; _cp+1; exd=2*min(int((_cp+1)/2),3); end; else if ext='ozi' then do; _co+1; exd=5*min(int((_co+1)/2),3); end; end; drop _:; run;   EXT is "pine", EXD should be assigned by value 2 for the first 2 days, value 4 for the next 2 days and value 6 for the remaining Period A. If EXT is "ozi", EXD should be assigned by value 5 for the first 2 days, value 10 for the next 2 days and value 15 for the remaining Period A.   I want to modify this code based on start and end dates and val should be incremented by 2,4,6 every 2 days . if for ext="pine" it should have first value as 2 and calculated what the next value will be based for the test data. First record for ext=pine val is 2 and the duration is 8 days 12-may-2018 to 19-may-2018=8 next record 20-may to 29 may then val for same id will be incremented from first record based on dates.   Any help? ... View more

how to assign values based on condition

by Quartz | Level 8 in SAS Programming
‎10-07-2018 03:38 AM
‎10-07-2018 03:38 AM
i want to assign values for EXD based on the below condition EXT is "pine", EXD should be assigned by value 2 for the first 2 days, value 4 for the next 2 days and value 6 for the remaining Period A. If EXT is "ozi", EXD should be assigned by value 5 for the first 2 days, value 10 for the next 2 days and value 15 for the remaining Period A.   Attached test data. can any one suggest how to do it.? ... View more

Re: how to assign values based on condition

by Quartz | Level 8 in SAS Programming
‎10-07-2018 01:37 AM
‎10-07-2018 01:37 AM
somehow it does not resolve if i use condition if period="A" then do; i get empty values. attached test data. ... View more

how to assign values based on condition

by Quartz | Level 8 in SAS Programming
‎10-06-2018 05:34 AM
‎10-06-2018 05:34 AM
data t; set FDAT; period="A"; if strip(EXT) = "pine" then do; EXD = 5; output; EXD = 10; output; EXD = 15; output; end; if strip(EXT) = "Rdone" then do; EXD = 2; output; EXD = 4; output; EXD = 6; output; end; run; if my variable EXT has pine in it then i want to assign new variable exd and randomly assign values 5,10,15 for all id's and the same with the next step as mentioned in the code. Somehow it doesnt work and creates more records than existing dataset. I am not sure if the logic i am using is correct. Any help? ... View more

where condition if using multiple datasets in proc sql join

by Quartz | Level 8 in New SAS User
‎10-05-2018 08:19 AM
‎10-05-2018 08:19 AM
Can we use case when or where condition if we join multiple datasets using proc sql.   proc sql; create table x_01 as select a.*, b.TDC_RAW as DTC_A, c.TDC_RAW as DTC_B, case when NDC_RAW ne "" d.NDC_RAW as DC_A, e.NDC_RAW as DC_B from rs a left join _dat b on a.ent=b.ect left join dat_b c on a.ent=c.ect left join dat d on a.ent=d.ect left join dat_b e on a.ent=e.ect quit; in the above code i am using case just to filter non missing from one of the dataset but it gives error - 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, OR, THEN, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored.   Any help if we can use where/case condition while joining multiple datasets ... View more

need flag for depriciating values

by Quartz | Level 8 in SAS Programming
‎07-02-2018 09:05 AM
‎07-02-2018 09:05 AM
I need flag 0 and 1. 0 if the value is depreciating and 1 if increasing. values i have are poor, medium, high and very high   data have; input pt vis prop $10. ; cards; 101 1 poor 101 2 poor 102 1 poor 102 2 high 102 3 very high 103 1 medium 103 2 medium 104 1 medium 104 2 poor 105 1 high 105 2 medium ; run; proc sort data=have; by pt vis; run; proc sql; create table want as select *,count(distinct prop)>1 as flag from have group by pt; quit; In this if pt of 101 is poor in both records so flag should be 0 for that pt. for pt=105 it decreaed from high to medium and flag should be 0. in pt=102 it increased from poor to high and then to very high so the flag should be 1 for that pt. Any help ... View more

Re: if the value is same for same id variable i want a flag and keep i...

by Quartz | Level 8 in SAS Programming
‎07-02-2018 09:00 AM
‎07-02-2018 09:00 AM
it didnt work   data have; input pt vis prop $10. ; cards; 101 1 poor 101 2 poor 102 1 poor 102 2 high 102 3 very high 103 1 medium 103 2 medium 104 1 medium 104 2 poor 105 1 high 105 2 medium ; run; proc sort data=have; by pt vis; run; proc sql; create table want as select *,count(distinct prop)>1 as flag from have group by pt; quit; also created a new variable to differentiate but for pt 105 it is from high to medium so the flag should be 0 but it is coming as 1. ... View more

Re: if the value is same for same id variable i want a flag and keep i...

by Quartz | Level 8 in SAS Programming
‎07-02-2018 08:41 AM
‎07-02-2018 08:41 AM
used it but no luck     data have; input pt vis prop $10. ; cards; 101 1 poor 101 2 poor 102 1 poor 102 2 high 102 3 very high 103 1 medium 103 2 medium 104 1 medium 104 2 poor 105 1 high 105 2 medium ; run; proc sort data=have; by pt vis; run; proc sql; create table want as select *,count(distinct prop)>1 as flag from have group by pt; quit; also created a new variable to differentiate but for pt 105 it is from high to medium so the flag should be 0 but it is coming as 1. ... View more

Re: if the value is same for same id variable i want a flag and keep i...

by Quartz | Level 8 in SAS Programming
‎07-02-2018 08:27 AM
‎07-02-2018 08:27 AM
It is not working and creating more records. from 11 observations it is becoming 14 and it should havce the same order as it is i.e first record for 105 is high and second record is medium that case it is decreasing     NOTE: The data set WORK.HAVE has 11 observations and 2 variables. NOTE: Compressing data set WORK.HAVE increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 268 ; 269 run; 270 proc sql; 271 create table want1 as 272 select a.*, 273 case when b.prop ne "" then 1 else 0 end as result 274 from have a 275 left join have b 276 on a.pt=b.pt 277 and a.prop ne b.prop; NOTE: Compressing data set WORK.WANT1 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: Table WORK.WANT1 created, with 14 rows and 3 columns. ... View more

Re: if the value is same for same id variable i want a flag and keep i...

by Quartz | Level 8 in SAS Programming
‎07-02-2018 08:11 AM
‎07-02-2018 08:11 AM
sorry for not being clear.  Here is the test data below and in this what i need is only improvement  as 1 and else it should be 0 based on pt.  in 101 there is no improvement so flag should be 0 for both records. in 102 it improved from poor to high so flag should be 1 and in 105 it went to hight to medium so flag should be 0.   data have; input pt prop $10.; cards; 101 poor 101 poor 102 poor 102 high 102 very high 103 medium 103 medium 104 medium 104 poor 105 high 105 medium ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-24-2023 11:53 AM
Likes from
View All
Quick links