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: 
pdhokriya
‎12-19-2023
  • 113 Posts
  • 39 Likes Given
  • 0 Solutions
  • 2 Likes Received

How to get YYYY-MM-DDThh:mm:ss from date (yymmdd10.) and time ( tod8.)

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 10:39 AM
‎10-20-2020 10:39 AM
Hi, How to get YYYY-MM-DDThh:mm:ss from date (yymmdd10.) and time ( tod8.)   My approch is mentioned below which is not proper for 1st record.   data xyz; date="12-Aug-2020"; output; Time= "11:45 PM"; output; run; data abc; set xyz; date1=put(input(date,anydtdte20.),yymmdd10.); time1 = put(input(time,time8.),tod8.); date_time = catx ("T",date1,time1); run;   Thank you. ... View more

Re: HH:MM:SS time format from AM/PM data

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 10:15 AM
‎10-20-2020 10:15 AM
Thank you so much for your quick reply. Its helpful for me. My approch was too long and also data was not proper. data have ; set want; hh = scan(time,1,":") ; mm = substr(time,4,2); am_pm = scan(time,-1," "); if hh ne "12" and am_pm = "PM" then hours = (hh + 12); else if am_pm ne "PM" then hours = hh; else if hh in ("00" "12") then hours=hh; cm_time= cat(strip(hours) ||":"||strip(mm)||":00"); run; Thank you again. ... View more

Re: Date conversion to yymmdd10.

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 10:10 AM
‎10-20-2020 10:10 AM
Thank you for your quick reply and help. My approch was long but your approch is simple, short and best, saved me time thanks again. ... View more

HH:MM:SS time format from AM/PM data

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 10:02 AM
‎10-20-2020 10:02 AM
Hi Team,   How shall I convert below mentioned data into 24 hours format of hh:mm:ss (char).   data want ; time="04:56 PM";output; time="11:59 PM";output; time="12:00 PM";output; time="12:51 PM";output; time="00:00 AM";output; time="10:19 AM";output; time="01:19 AM";output; run;   Thank you in advance. ... View more

Re: SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 08:43 AM
‎10-20-2020 08:43 AM
My approch was this, but I really liked your program. Thank you so much for your help. Take care. Data match; set xyz; Match = 'Y'; where CMCLASCD = cd_a and STS = "A"; Run; DAta match1; merge xyz match (keep= name CMCLASCD match); by name CMCLASCD; if match = "Y" and STS = "A"; run; proc sql; Create table match_n as select *, count(*) as cnt from match1 group by cmclascd; quit; Data match_n; set match_n; if CMCLASCD = cd_a and cnt gt 1 then delete; run; Proc transpose data= match_n out= final1;* prefix= CMCLSC0; by name CMCLASCD; Var cd_a ; run; Data final_a; set final1; drop _name_ ; Run; **************************; data final2; set xyz (where = (sts = "I")); Run; Proc transpose data= final2 out= final2_i(drop=_name_); by name CMCLASCD; Var cd_a ; run; Data final; set final_a final2_i; Run; ****************; Proc sql noprint; Select count(varnum) into: num_vars from sashelp.vcolumn where libname = 'WORK' and memname = "FINAL"; quit; Data _nul_; set sashelp.vcolumn; where libname = 'WORK' and memname = "FINAL"; call symput(cat('a', _n_), Name); call symput(cat('b', _n_),compress('CMCLSC'||put(_N_-2, z2.))); Run; %macro rename(); Data final_all; set final; %do i = 1 %to &num_vars.; %if &i. gt 2 %then %do; &&b&i. = &&a&i.; drop &&a&i.; %end; %end; run; %mend; %rename(); ... View more

Re: Date conversion to yymmdd10.

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 08:38 AM
‎10-20-2020 08:38 AM
My approch is this: Please share yours. data xyz; length date1 $30.; date1= "08-June-2020";output; date1= "31-Oct-2020";output; date1= "13/August/2020"; output; date1= "02/Jan/2020" ;output; run ; data one; set xyz; array char_month(24) $20 _temporary_ ("JANUARY" "FEBRUARY" "MARCH" "APRIL" "MAY" "JUNE" "JULY" "AUGUST" "SEPTEMBER" "OCTOBER" "NOVEMBER" "DECEMBER" "JAN" "FEB" "MAR" "APR" "MAY" "JUN" "JUL" "AUG" "SEP" "OCT" "NOV" "DEC"); array num_month (24) $20 _temporary_ ("01" "02" "03" "04" "05" "06" "07" "08" "09" "10" "11" "12" "01" "02" "03" "04" "05" "06" "07" "08" "09" "10" "11" "12" ); do j = 1 to 24 ; if strip(char_month(j)) = strip(upcase(scan (tranwrd (date1,"/","-"),2,"-"))) then cm_date=catx("-",scan (tranwrd (date1,"/","-"),3,"-"),num_month(j),scan (tranwrd (date1,"/","-"),1,"-")); end; drop j; run; ... View more

Re: Date conversion to yymmdd10.

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 07:15 AM
‎10-20-2020 07:15 AM
3rd record is coming null. Not working 😞 ... View more

Re: Date conversion to yymmdd10.

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 06:04 AM
‎10-20-2020 06:04 AM
Please share your program approch because this does not work for my data. data xyz; date1= "08-June-2020";output; date1= "31-Oct-2020";output; date1= "13/August/2020"; output; date1= "02/Jan/2020" ;output; run ; data one; set xyz; newvar = input(date1, best.); format newvar yymmdd10.; run; ... View more

Re: SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 05:42 AM
‎10-20-2020 05:42 AM
if data is matched i.e.(CMCLASCD = CD_a) then will consider only "A" values. That means will exclude I valued. 1003 B01AC A01AD A 1003 B01AC B01AC A 1003 B01AC M02AC A 1003 B01AC N02BA I I data does not match i.e.(CMCLASCD ne CD_a) then will consider I values only not A. 1003 R03BZ A 1003 R03BZ R03BH I 1003 R03BZ R03BQ I Hope I have cleared this. If any thing else plz do let me know. ... View more

Date conversion to yymmdd10.

by Pyrite | Level 9 in SAS Programming
‎10-20-2020 03:46 AM
‎10-20-2020 03:46 AM
Hi,   Here is some data, where I need to fetch yymmdd10. format data (e.g. 2020-06-08). which includes all Jan-Dec or January to December data with (- or / ) seperates. data xyz; date1= "08-June-2020";output; date1= "31-Oct-2020";output; date1= "13/August/2020"; output; date1= "02/Jan/2020" ;output; run;   Thank you in advance for your help and take care.   Regards Priya ... View more

Re: SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-19-2020 12:17 PM
‎10-19-2020 12:17 PM
Hi, Could you please help me out from this problem. Regards Priyanka ... View more

Re: SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-15-2020 10:14 PM
‎10-15-2020 10:14 PM
Posted in my question, please look at it. Thank you in advance. Take care. ... View more

Re: SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-15-2020 10:36 AM
‎10-15-2020 10:36 AM
Share in massage NAME CMCLASCD CMCLSC01 CMCLSC02 CMCLSC03 CMCLSC04 CMCLSC05 CMCLSC06 CMCLSC07 CMCLSC08 CMCLSC09 CMCLSC10 CMCLSC11 CMCLSC12 CMCLSC13 CMCLSC14 CMCLSC15 CMCLSC16 CMCLSC17 CMCLSC18 CMCLSC19 CMCLSC20 CMCLSC21 CMCLSC22 CMCLSC23 CMCLSC24 CMCLSC25 CMCLSC26 CMCLSC27 CMCLSC28 CMCLSC29 CMCLSC30 CMCLSC31 1003 B01AC A01AD M02AC N02BA 1003 C08DB C05AE 1003 G04CA 1003 R03AC R03CC R03CH 1003 R03BA D07AC R01AD R03BA R03BO R03BF R03BT R03BR R03BK R03BP R03BD 1003 R03BE 1003 R03BZ R03BH R03BQ ... View more

SAS data query

by Pyrite | Level 9 in SAS Programming
‎10-15-2020 09:58 AM
‎10-15-2020 09:58 AM
  Hi Reader, Below are some requirement. 1. Need to create new variables cmclscd02 to cmclscd31. 2. When sts = "A" and CMCLASCD = cd_a (multiple record, atleast 1 value should match ) then data should be CMCLASCD , cmclscd02, cmclscd03..etc. 3. When sts = "A" and CMCLASCD = cd_a CMCLASCD = cd_a (one record) then data should be CMCLASCD 4. When cmclscd ne cd_a then consider sts = "I" data then consider other dataset variable = cd_i and data should be collect in CMCLASCD , cmclscd02, cmclscd03..etc. 5. Output data is mentioned below for your reference.   data xyz; input name $  CMCLASCD $  CD_a $ /*CD_i $ 18-22*/ STS $ ; cards; 1003 B01AC A01AD A 1003 B01AC B01AC A 1003 B01AC M02AC A 1003 B01AC N02BA I 1003 C08DB C05AE A 1003 C08DB C08DB A 1003 G04CA G04CA A 1003 R03AC R03AC A 1003 R03AC R03CC A 1003 R03AC R03CH A 1003 R03BA D07AC A 1003 R03BA R01AD A 1003 R03BA R03BA A 1003 R03BA R03BA A 1003 R03BA R03BO A 1003 R03BA R03BF A 1003 R03BA R03BT A 1003 R03BA R03BR A 1003 R03BA R03BK A 1003 R03BA R03BP A 1003 R03BA R03BD A 1003 R03BE R03BE A 1003 R03BZ R03BH I 1003 R03BZ R03BQ I ; run;   Output data:   NAME CMCLASCD CMCLSC01 CMCLSC02 CMCLSC03 CMCLSC04 CMCLSC05 CMCLSC06 CMCLSC07 CMCLSC08 CMCLSC09 CMCLSC10 CMCLSC11 CMCLSC12 CMCLSC13 CMCLSC14 CMCLSC15 CMCLSC16 CMCLSC17 CMCLSC18 CMCLSC19 CMCLSC20 CMCLSC21 CMCLSC22 CMCLSC23 CMCLSC24 CMCLSC25 CMCLSC26 CMCLSC27 CMCLSC28 CMCLSC29 CMCLSC30 CMCLSC31 1003 B01AC A01AD M02AC                                                           1003 C08DB C05AE                                                             1003 G04CA                                                               1003 R03AC R03CC R03CH                                                           1003 R03BA D07AC R01AD R03BA R03BO R03BF R03BT R03BR R03BK R03BP R03BD                                           1003 R03BE                                                               1003 R03BZ R03BH R03BQ                                                             ... View more

Re: Create new variable by considering semicolon or spcae and split th...

by Pyrite | Level 9 in SAS Programming
‎10-12-2020 10:44 PM
‎10-12-2020 10:44 PM
I can see obs 1 is fine but not the 2nd and 3rd obs. Here usa;swati; is token1 as length is 10, if space in between 2data then should be split. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-19-2023 08:56 AM
Likes given to
Likes from
View All
Quick links