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: 
lambad
‎03-29-2023
  • 12 Posts
  • 5 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: SAS DMS

by Obsidian | Level 7 in New SAS User
‎03-29-2023 05:40 AM
‎03-29-2023 05:40 AM
No worries!   Thanks for the help, i can't share more than that, no data, and full code. really sorry for that.   No worries we can close this here.   Thanks Dheeraj ... View more

Re: SAS DMS

by Obsidian | Level 7 in New SAS User
‎03-29-2023 05:08 AM
‎03-29-2023 05:08 AM
Yes!, actually this code just run for all as True, where there are some false also, the false condition output also is as Ture  ... View more

SAS DMS

by Obsidian | Level 7 in New SAS User
‎03-29-2023 03:22 AM
‎03-29-2023 03:22 AM
i Have written below code on SAS Data flux, as there are many other True/false condition are there, in below condition everything became true assecond part of the query should be false      if ((not isnull(`FSP_KATR10`) or not isblank (`FSP_KATR10`)) and  (not isnull(`DNP_KATR10`) or not isblank (`DNP_KATR10`))) or     ((isnull(`FSP_KATR10`) or isblank (`FSP_KATR10`)) and  (isnull(`DNP_KATR10`) or isblank (`DNP_KATR10`))) then     begin     T_F = 'true'     end     else         begin         if (not isnull(`FSP_KATR10`) or not isblank (`FSP_KATR10`)) and inlist(trim(`SYSTEM_ID_DNP`),'P48010','P24010','P45010','P47010','Q26010') and (isnull(`DNP_KATR10`) or isblank (`DNP_KATR10`)) then             begin             T_F = 'false'             `ReasonFalse` = `ReasonFalse` & "Attribute 10 on FSP but not on other SYSTEM ,"             end         else             begin              if (isnull(`FSP_KATR10`) or isblank (`FSP_KATR10`)) and inlist(trim(`SYSTEM_ID_DNP`),'P48010','P24010','P45010','P47010','Q26010') and (not isnull(`DNP_KATR10`) or not isblank (`DNP_KATR10`)) then                 begin                  T_F = 'false'                 `ReasonFalse` = `ReasonFalse` & "Attribute 10 on other system but not on FSP ,"                    end             end         end ... View more

Re: Duplicate check in DataFlux

by Obsidian | Level 7 in SAS Data Management
‎08-02-2022 02:52 AM
‎08-02-2022 02:52 AM
Hello Audrey,   Good day!   I am really tankful to you for this. i wanted to directly write to you however i couldn't or i didn't find option to write you directly. thanks for your help and it worked for me. Thanks Dheeraj   ... View more

Duplicate check in DataFlux

by Obsidian | Level 7 in SAS Data Management
‎08-01-2022 08:53 AM
‎08-01-2022 08:53 AM
Hello All,   SAS DataFlux is new for me, i am trying to find duplicate in same data set  base on few criteria. i have created 3 Keys, KEY1, KEY2, KEY3 which are like KEY1= FirstName+LastName+EMailID+PhoneNumber+Accountnumber. Key2= FirstName+LastName+EMailID+PhoneNumber. and Key3= FirstName+LastName+EMailID . Now i have challenge to make group base on these keys where i have to find: Where Key1 qualifies for , those all 100% are Duplicate Records Key2 will tell me, where all other detail is duplicate but different account number Key3 will give where personal detail is duplicate but different Phone umber and account   How i can make this in DataFlux.   Thanks     ... View more

Re: dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-23-2022 03:57 AM
1 Like
‎06-23-2022 03:57 AM
1 Like
Awesome !! you are great Audrey!! i have all the files as per how many cluster i have :-     ... View more

Re: dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-23-2022 03:09 AM
‎06-23-2022 03:09 AM
Hello Audrey,   it worked successfully without error, but output is not as desired. there is just one .txt file with limited data.   I am very new to this tool. sorry for the silly questions     Thanks once again   Dheeraj Lamba   ... View more

Re: dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-22-2022 11:01 PM
‎06-22-2022 11:01 PM
Hola,   Really appreciate for your reply, yes i do have permission and other access.         ... View more

Re: dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-22-2022 11:15 AM
‎06-22-2022 11:15 AM
Hello Audrey,   Good day!   it worked for me, made some changes now i have this error. file not opened. at once it create one file that is blank.   could you please suggest. where i am going wrong.       ... View more

Re: dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-22-2022 06:58 AM
‎06-22-2022 06:58 AM
No Exactly helping me, i have data for example i have 100 System Data in one file, now i want to have 100 files for each one system. ... View more

dataflux How to split a file into multiple .txt output files

by Obsidian | Level 7 in SAS Data Management
‎06-21-2022 10:33 AM
‎06-21-2022 10:33 AM
Hello All,   Good day!   Can anyone help me on this, i have Data Set on SAS Dataflux Data Management studio, where i have done the clustering, now base on each cluster i needs to have one .txt output file for each cluster.   Thanks Dheeraj  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-29-2023 09:00 AM
Likes given to
View All
Likes from
View All
Quick links