About Rahul_SAS

Rahul_SAS · ‎07-07-2018

Dear Experts, Required you guidance. Attached 2 files, have and want. I need a new variable reqrddate as mentioned in the want data. If case id has status as corrected(secondary) and correctionreqrd(primary) both then fetch the date against correctionreqrd otherwise fetch the date against corrected. If case id has status as Complete(primary) then fetch date against complete. The reqrddate should have only one date for each case id. Please refer attached want data for more clarity. Thanks

Rahul_SAS · ‎07-03-2018

Thank you novinosrin it help me a lot, THANK YOU SO MUCH. Can i make Error levels(L1, L2,L3) as a separate variable??

Rahul_SAS · ‎07-02-2018

no, please see attached Final Data.

Rahul_SAS · ‎07-02-2018

thank you sir for replying. the numbers are absolutely fine but I need these numbers to be distributed and populated at row level so that i will be able to use this output for reporting purpose in SAS VA Required Final Output is Attached

Rahul_SAS · ‎07-02-2018

Attached a new sample data. I want two variables to be created- 1. Distinct CaseID Count (total should be 29) 2. Case Processed With atleast one error(L1,L2 or L3) and count should be 11 I don't know how will I get this but i need these numbers to use in SAS VA.

Rahul_SAS · ‎07-02-2018

Hi Expoets, Here, I need to get the distinct Case count for the cases that has ateast one error levels(L1, L2 or L3) excluding NA and null values. L1, L2 or L3 are the errors. Further I want all the sub-grouped values for each CaseType and Serousness. Tried By Group processing but didn't solve the purpose. Getting this is quit critical for me so please suggest me a way so that I could achieve this. -Thanks

Rahul_SAS · ‎06-22-2018

I have to get this as 1 to match the numbers. if it gets populated for all rows then the total could will be so high and won't give correct result while aggregation.

Rahul_SAS · ‎06-22-2018

HI RW9, its not giving the desired result. Example: 1000000018 NA 1000000018 A2 1000000018 A2 1000000018 A1 for this ID, the distinct count is 1 and excluding NA total Attempts is 3 so i need 1/3=.33 to be populated to all rows. 1000000018 NA 0 0 1000000018 A2 1 0.33 1000000018 A2 0 0.33 1000000018 A1 0 0.33 similarly if there are 4 Attempts then 1/4=.25 to be populated in Attempts

Rahul_SAS · ‎06-22-2018

Hi Experts, I have a data like given below: ID Attempts 1000000002 A2 1000000002 A2 1000000002 A1 1000000002 NA 1000000003 NA 1000000007 NA 1000000008 A3 1000000017 NA 1000000018 A1 1000000018 A2 1000000018 A3 1000000018 A2 1000000018 NA 1000000019 A1 1000000019 A3 1000000019 NA 1000000020 A1 1000000020 A3 1000000022 A2 want the output as ID Attempts Attemptbyid shared 1000000002 A2 1 0.33 1000000002 A2 0 0.33 1000000002 A1 0 0.33 1000000002 NA 0 0 1000000003 NA 0 0 1000000007 NA 0 0 1000000008 A3 1 1 1000000017 NA 0 0 1000000018 A1 1 0.25 1000000018 A2 0 0.25 1000000018 A3 0 0.25 1000000018 A2 0 0.25 1000000018 NA 0 0 1000000019 A1 1 0.5 1000000019 A3 0 0.5 1000000019 NA 0 0 1000000020 A1 1 0.5 1000000020 A3 0 0.5 1000000022 A2 1 0 need to created a varialble Shared which should have the total count of distince IDs where IDs with attemps NA has to be excluded. created Attemptbyid variable as count for IDs exculuding NAs but have to distribute distinct count (Attemptbyid) 1 to all subgroup observations. thanks

Rahul_SAS · ‎04-18-2018

hi Fredrik, please guide me how to set a date variable to category variable. thnx

Rahul_SAS · ‎04-18-2018

Hi Fredrike, My requirement is to calculate and create a data item which should contain the latest data i.e. 17 Jan 2018 in the given sample data. That data item will be used in a button bar to highlight Data Refreshed On. I hope, I am making sense here. Thanks

Rahul_SAS · ‎04-18-2018

Dear Experts, I have two variables ID and Date. I need to get a max date value, tried everything but not able to find a way so please help me. ID dates B0001 01/17/2018 B0002 11/20/2017 B0003 01/16/2018 B0004 11/19/2017 B0005 01/15/2018 B0006 11/18/2017 B0007 01/14/2018 B0008 11/17/2017 B0009 01/13/2018 B0010 11/16/2017

Rahul_SAS · ‎02-15-2018

Hi Michelle, I couldn't find the ..(Use the SAS Folders tree to locate the map ( )).. option in data builder so could you please guide me little further. -thanks rahul

Rahul_SAS · ‎09-13-2017

hi KurtBremser....could you please share a sample code for the first scenario.

Rahul_SAS · ‎09-13-2017

Hi Experts, I am trying to create a daily incremental code for Impala tables in SAS with Proc Append. But if I execute proc append twice or multiple time so the data gets appended multiple time. How can I avoide this replication of data. Or else, is there any way to overwrite or update the data in impala table using sas. Please help. -Rahul

Online Status	Offline
Date Last Visited	‎01-28-2025 04:46 PM

Array with Nested Loops

Re: date difference between 0001-01-01 and 2023-01-01

date difference between 0001-01-01 and 2023-01-01

Join table with case when

Re: Getting exponential value

Re: Getting exponential value

Getting exponential value

LASR Vs CAS Vs Micro Analytics Services

Reading Multiple CSVs

Re: Automated Incremental Load

Re: Getting exponential value

Re: Reading multiple csv files

Re: Spliting a string with all upper case

Re: A New Date Field Required

Re: why repeated observations??

Re: Converting a category to a measure in VA (character to numeric)

Re: Converting a category to a measure in VA (character to numeric)

delete rows from a LASR table

A New Date Field Required

Re: Subgroup count required

Re: Subgroup count required

Re: Subgroup count required

Re: Subgroup count required

Subgroup count required

Re: shared subgroup values

Re: shared subgroup values

shared subgroup values

Re: Getting max date value in SAS VA

Re: Getting max date value in SAS VA

Getting max date value in SAS VA

Re: Can able Import to SAS IMAP or SAS OLAP Cube in to SAS Visual Anal...

Re: Overwrite or update Impala table using sas

Overwrite or update Impala table using sas