About cm3

cm3 · ‎12-19-2023

It worked. Thank you Sir.

cm3 · ‎12-19-2023

Data _null_; Call symput (‘currdt’,put(datetime(),datetime20.)); Call symput(“prvdt’,put(datetime()-5,datetime20.)); Run; %put &currdt.; %put &prvdt.; Prvdt is not returning expected result, please advise. Thank you

cm3 · ‎07-27-2023

I understand, will make sure going forward. For 10894 , if at all it is possible to consider PV_addr1, City and ST in comparison with SRVC_addr or else it can be reported in output dataset. Thank you

cm3 · ‎07-27-2023

combination of PV_addr1,PV_addr2,City,ST match with SRVC_addr Thanks

cm3 · ‎07-27-2023

need help in finding at least one address match by group(TaxID NPI), if not then report in output dataset Appreciate your help

cm3 · ‎07-26-2023

TID. NID. Addr1. Addr2. Srvc_addr 45C 123. 1 fox ln. Suit 5. 1 fox ln Suit 5 51A. 234. 21 dey rd. Bruns. 21 dey rd Bruns 51A. 234. 21 Dey rd. Bruns. 66 Mac rd Cran 51A. 234. 21 dey rd. Bruns. St 2 app dr NC 58H. 378. 9 Horse ln. Garth. 88. Yard Bost 58H. 378. 9 Horse ln. Garth. 2 abc rd connect 58H. 379. 9 Horse ln. Garth. 9 Horse ln Garth Groupby TID and NID if not addr1+addr2 match with any one srvc_addr, then output that TID,NID Appreciate your support

cm3 · ‎01-23-2023

Also I was wondering how would we convert if enrollment_month is type date with same value?? Pls confirm

cm3 · ‎01-23-2023

your solution worked , thank you. Thanks for updating the title, it was bit confusing in mobile and I missed it

cm3 · ‎01-23-2023

I have a variable Enrollment_month - type character, length 8 with value ex:FEB2022. I want to convert this into date format as 20220201. Please help

cm3 · ‎01-14-2021

thanks for your help 1)any one of the Status value should be "completed" other two status values could be "cancelled" or blank 2)none of the 3 status variables should have "completed" 3)need out put data set Thanks again

cm3 · ‎01-14-2021

Hello, I have data like below with different Item values Item status_x status_y status_z 05 completed cancelled completed 05 cancelled completed 05 cancelled completed 05 completed 05 completed completed completed 05 cancelled completed 05 cancelled completed completed 08 completed - - - - - - - - - - 10 cancelled completed - - - - - - - - - - - - - I need counts of any one status completed, any two status completed and all 3 status completed by Item, like below table Item 1statuscompleted 2statuscompleted 3statuscompleted nostatuscompleted 05 4 2 1 0 08 ---- 10 ----- Appreciate your help. TIA

cm3 · ‎12-16-2019

Hi I am trying to get an excel output file with the custom Document properties Subject and Title. Can you pls help whether this is possible in Sas using ods or any other option? Thanks

cm3 · ‎09-27-2019

Thanks Paul D, It worked. Sorry @Shmuel, my specifications were not clear I figured out the below code which worked as well. proc sql; create table want as select A.*, B.* from T1 A left outer join T2 B on A.SSID = B.old or A.SSID = B.new; quit; data want (drop= old new tmp); set want; if SSID=new then delete; if old ^= . then do; SSID=new; end; run; Regards, cm3

cm3 · ‎09-26-2019

Appreciate your quick response. I can't use subquery option as I have another variable, old to new update which I did not mention in my example. And with the merge logic , new 201 and 401 records are missing in output data set. thank you

cm3 · ‎09-26-2019

Hi I have two datasets like below DATA T1; INPUT ssid gender $ grade; DATALINES ; 100 M 08 101 M 08 200 F 08 300 F 08 400 M 08 ; RUN; DATA T2; INPUT old new tmp $; DATALINES ; 100 101 abc 200 201 bcd 400 401 def ; RUN; I want to merge these two data sets to get the below output ssid gender grade 101 M 08 201 F 08 300 F 08 401 M 08 appreciate your help on this code, without "WARNING: Variable already exists on file" in the log as my data is large thanks

Online Status	Offline
Date Last Visited	‎02-01-2024 11:31 AM

Re: how to get 5 days back datetime from current day

how to get 5 days back datetime from current day

Re: need help in finding at least one address match by group, if not t...

Re: need help in finding at least one address match by group, if not t...

need help in finding at least one address match by group, if not then ...

Need help in finding at least one match from the group

Re: Hi

Re: Convert string date to date value

Convert string date to date value

Re: conditions on multiple variables

Re: Convert string date to date value

Re: Hi

Re: how to get 5 days back datetime from current day

how to get 5 days back datetime from current day

Re: need help in finding at least one address match by group, if not t...

Re: need help in finding at least one address match by group, if not t...

need help in finding at least one address match by group, if not then ...

Need help in finding at least one match from the group

Re: Hi

Re: Convert string date to date value

Convert string date to date value

Re: conditions on multiple variables

conditions on multiple variables

Excel document properties : Subject and Title

Re: help with merge/join to get only new ssid

Re: help with merge/join to get only new ssid

help with merge/join to get only new ssid