About SASPhile

SASPhile · ‎10-22-2020

I need help to split ID into two rows as below if there is a delimiter colon (:) ID Description 001 Text1 002:003 Text2 ID Description 001 Text1 002 Text2 003 Text2

SASPhile · ‎09-30-2020

My bad, I forgot to update the records, The refid2 should be 005, 006 and 007 respectively 1 122005 0.00 001 Sep1 001 2 122005 0.25 002 Sep2 002 3 122005 1.00 003 Sep3 003 4 122005 3.00 004 Sep4 004 5 122006 0.25 002 Sep1 002 6 122006 1.00 003 Sep2 003 7 122006 3.00 004 Sep3 004 8 122006 0.00 005 Sep4 005 9 122006 1.00 006 Sep5 006 10 122006 3.00 007 Sep6 007

SASPhile · ‎09-30-2020

Thanks Tom: This is what is required: "do you want to number them based on the sort order of the values of TIMEPOINT?" So for id 125006 (obs numbers 8,9,10) the refid2 should be 005,006,007 respectively Obs Id Point Refid Date refid2 1 122005 0.00 001 Sep1 001 2 122005 0.25 002 Sep2 002 3 122005 1.00 003 Sep3 003 4 122005 3.00 004 Sep4 004 5 122006 0.25 002 Sep1 002 6 122006 1.00 003 Sep2 003 7 122006 3.00 004 Sep3 004 8 122006 0.00 005 Sep4 001 9 122006 1.00 006 Sep5 003 10 122006 3.00 007 Sep6 004

SASPhile · ‎09-30-2020

timepoints 0,0.25,1,3,24,72,168,336 takes refid's 001 ,002 to 008. Not all id's can have all timepoints. Some id's can have same timepoint more than once. but if a timepoint exists the first instance it should take it's original refid. As example, For 122005 timepoint 0.25 has 002 as refid , for 122006 there is no timepoint 0 but it has 0.25, it would take 002 as refid for sep1, and for sep4, timepoint 0 will be 006 and for sep6 timepoint 3 will be 007 Id TimePoint Refid Date 122005 0 001 Sep1 122005 0.25 002 Sep2 122005 1 003 Sep3 122005 3 004 Sep4 122006 0.25 002 Sep1 122006 1 003 Sep2 122006 3 004 Sep3 122006 0 005 Sep4 122006 1 006 Sep5 122006 3 007 Sep6

SASPhile · ‎09-30-2020

A subjid can have multiple time points as shown below Subjid timepoint 1 0 1 0.25 1 1 1 3 So for each time, a refid needs to be assigned Subjid timepoint Refid 1 0 001 1 0.25 002 1 1 003 1 3 004 But if the timepoint repeats refid needs to be higher value Subjid timepoint Refid 1 0 001 1 0.25 002 1 1 003 1 3 004 1 0 005 1 1 006 I tried enumeration logic,but did not work.

SASPhile · ‎09-25-2020

I found the trick: proc format ; picture newfmt(default=10) other='%b-%Y'(datatype=date); run; This gets me the desired output.

SASPhile · ‎09-25-2020

Thanks Sumit, but how to display Prev as AUG-2020 and Curr as SEP-2020 instead of AUG-20 and SEP-2020

SASPhile · ‎09-24-2020

data _null_; pre = put(year(intnx ('month', today(), -1)) ,8.)||'-'||put(month(intnx ('month', today(), -1)), z2.); call symputx('prev', left(Trim(pre))); cur = put(year(intnx ('month', today(), 0)) ,8.)||'-'||put(month(intnx ('month', today(), 0)), z2.); call symputx('curr', left(Trim(cur))); run; %put &prev.; %put &curr.; How to convert 2020-08 to Aug-2020 and 2020-09 to Sep-2020?

SASPhile · ‎03-09-2020

Hi Tom, Its only the second and foruth record that needs parsing.

SASPhile · ‎03-09-2020

NORMAL to goes to Character_Var column. Thanks for pointing it out!

SASPhile · ‎03-09-2020

A variable has mix of numbers and characters. I would want to separate numbers and characters into two variables: Raw Variable 2-5 TIMES IN WEEK 4-NORMAL 2018-09-27 Last Visit 4 - severe problems walking Raw Variable Character_Var Numeric_Var 2-5 TIMES IN WEEK 2-5 TIMES IN WEEK 4-NORMAL NORMAL 4 2018-09-27 Last Visit 2018-09-27 Last Visit 4 - severe problems walking severe problems walking 4 I tried this anydigit(substr(Raw_Variable ,1,1))>0 and substr(Raw_Variable ,2,1)='-' to separate out ,but did not seem to handle properly all the cases. Any help is appreciated

SASPhile · ‎01-09-2020

If the date doesnt have seconds ,I dont want to display seconds.

SASPhile · ‎01-09-2020

THanks. what if the some dates have seconds like 2019-12-01T16:40:35 and some dont have 2019-12-01T16:40?

SASPhile · ‎01-09-2020

I'm having issues converting iso8601 date to numeric and back to iso8601. When converting back to iso8601, I'm getting extra 00's in the time component. Ex: 2019-12-01T16:40 gets converted to numeric,.To reconvert it back I'm getting 2019-12-01T16:40:00 ANy help is apprecited.

SASPhile · ‎12-23-2019

I'm looking for an efficient way to convert a column that has mixed dates to YYYY-MM-DD. Your help is aprreciated Raw_Date 01 NOV 2019 01-NOV-19 Corrected_Date 2019-11-01 2019-11-01

Online Status	Offline
Date Last Visited	‎04-23-2021 05:04 PM

Multiple rows

Re: Enumeration

Re: Enumeration

Re: Enumeration

Enumeration

Re: Convert YYYY-MM to MON-2020

Re: Convert YYYY-MM to MON-2020

Convert YYYY-MM to MON-2020

Re: Separate Number and characters

Re: Separate Number and characters

Re: Multiple records

Re: Add dummy values to column

Re: INPUT function reported 'WARNING:

Re: INPUT function reported 'WARNING:

Re: INPUT function reported 'WARNING:

Xcopy

long to wide

input and output files

Re: Like Operator

Name match algorithm

Multiple rows

Re: Enumeration

Re: Enumeration

Re: Enumeration

Enumeration

Re: Convert YYYY-MM to MON-2020

Re: Convert YYYY-MM to MON-2020

Convert YYYY-MM to MON-2020

Re: Separate Number and characters

Re: Separate Number and characters

Separate Number and characters

Re: ISO8601 to Numeric and back to ISO8601

Re: ISO8601 to Numeric and back to ISO8601

ISO8601 to Numeric and back to ISO8601

Mixed Dates to YYYY-MM-DD