About Emma2021

Emma2021 · ‎03-17-2023

I have the following SAS datasets in a folder : dsn_23jan2023 etc. suffix are dates. But sometimes those tables are empty. How can I select the latest non empty data from today’s date? Thank you

Emma2021 · ‎07-20-2022

I have ICD 10 codes from 1 to 10 listed. I would like to combine all codes values if any listed ICD 10 codes start with A. How can I do that? Thank you. Example fake data: Code1 code2 …code10 H25 G45 J257 D467 A56 A46 A56 F35 D456 A456 Y366 Wanted data would be keep all values when start with A.

Emma2021 · ‎02-17-2022

This code does not do anything

Emma2021 · ‎02-16-2022

It runs but it does not remove the desired rows. The rule is simple: Sort by id and date, then remove all rows within 10 days: but before removing all rows within 10-days -check the type —keep only the one row with lowest type value.

Emma2021 · ‎02-16-2022

Sorry it does not work too: see below data: data have; input id type $ date :mmddyy10.; format type $3. date mmddyy10.; cards; 1 A-2 1/1/2021 1 A-1 1/4/2021 1 A-1 1/20/2021 1 A-1 1/23/2021 1 A-1 1/25/2021 1 A-0 1/25/2021 2 A-1 1/1/2021 2 A-1 1/4/2021 3 A-1 1/1/2021 3 A-2 1/4/2021 4 A-2 1/1/2021 4 A-3 1/4/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 6 0-B 07/22/2020 6 1-B 08/05/2021 6 1-B 08/11/2021 6 1-B 08/18/2021 6 1-B 01/26/2022 ; data wanted; input id type $ date :mmddyy10.; format type $3. date mmddyy10.; cards; 1 A-1 1/4/2021 1 A-0 1/25/2021 2 A-1 1/1/2021 3 A-1 1/1/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 6 0-B 07/22/2020 6 1-B 08/05/2021 6 1-B 01/26/2022

Emma2021 · ‎02-16-2022

Thank you! I should sort by id type and date and I think this should work!

Emma2021 · ‎02-15-2022

Thank you, but the both codes do not work.

Emma2021 · ‎02-15-2022

The code does not work for below data (when the same type and within 10 days it shifts the date, but I do not want to shift any date): data have; input id type $ date :mmddyy10.; format type $3. date mmddyy10.; cards; 1 A-2 1/1/2021 1 A-1 1/4/2021 1 A-1 1/20/2021 1 A-1 1/23/2021 1 A-1 1/25/2021 1 A-0 1/25/2021 2 A-1 1/1/2021 2 A-1 1/4/2021 3 A-1 1/1/2021 3 A-2 1/4/2021 4 A-2 1/1/2021 4 A-3 1/4/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 6 0-B 07/22/2020 6 1-B 08/05/2021 6 1-B 08/11/2021 6 1-B 08/18/2021 6 1-B 01/26/2022 ; data wanted; input id type $ date :mmddyy10.; format type $3. date mmddyy10.; cards; 1 A-1 1/4/2021 1 A-0 1/25/2021 2 A-1 1/1/2021 3 A-1 1/1/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 6 0-B 07/22/2020 6 1-B 08/05/2021 6 1-B 01/26/2022 ;

Emma2021 · ‎02-14-2022

I have the following data: data have; input id type $ date :mmddyy10.; format type $3. date mmddyy10.; cards; 1 A-2 1/1/2021 1 A-1 1/4/2021 1 A-1 1/20/2021 2 A-1 1/1/2021 2 A-1 1/4/2021 3 A-1 1/1/2021 3 A-2 1/4/2021 4 A-2 1/1/2021 4 A-3 1/4/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 ; I would like to keep only all observations with 10 or more days difference by ID, but if within 10-days then type should be with smallest value's row (see id=1 and type=A-1; also id=4 and type=A-1) even the date was higher than the previous date, see wanted data: ID TYPE DATE 1 A-1 1/4/2021 1 A-1 1/20/2021 2 A-1 1/1/2021 3 A-1 1/1/2021 4 A-1 1/5/2021 5 A-2 2/1/2021 How can I accomplish this? Thank you.

Emma2021 · ‎02-01-2022

Sorry, I want to check the name for the year=2000. So, if I find year=2000, then I want to print out in log whatever value has the variable “name”. Thank you

Emma2021 · ‎02-01-2022

I want to check only the log.

Emma2021 · ‎02-01-2022

I have a variable year as 4 digits string, for example, 2000,2001, 2002 etc. I would like to loop over those values over year variable and print in log if I find 2002. How can I do that? Thank you.

Emma2021 · ‎02-01-2022

I am using proc infile to get multiple text files into sas (filename all (“&path.file1.txt” “&path.file2.txt”), How can I get the last string (1 and 2 from file names and create as new variable “filenumber” while reading the all files into sas? Thank you.

Emma2021 · ‎01-22-2022

I have a numeric integer variable. If last 2 digits are zeros, then I want to remove those zeros. How can I do that? For example, 100 should be 1, 101 should be 101, 3300 should be 33. Thank you!

Emma2021 · ‎01-19-2022

I would like to calculate difference within ID. I have a below SAS code, how can I change this to SQL? data tmp1; set tmp; by ID; dif_day=dif(day); if first.id then dif_day=.; run; data have; input id day ; cards; 1 1 1 1 2 4 2 4 2 5 3 3 3 3 3 3 3 4 3 4 ; data want; set have; by id; dif_day=dif(day); if first.id then dif_day=.; run; Thank you.

Online Status	Offline
Date Last Visited	‎01-19-2024 01:16 AM

Re: Sas Macro dynamic values and look up from another table

Sas Macro dynamic values and look up from another table

Re: Search words within folders

Search words within folders

Re: RE label multiple variables

Re: RE label multiple variables

RE label multiple variables

Re: Multiple datasets reshape and calculate

Re: Multiple datasets reshape and calculate

Re: Multiple datasets reshape and calculate

Re: Sas Macro dynamic values and look up from another table

Re: Sas Macro dynamic values and look up from another table

Re: RE label multiple variables

Re: RE label multiple variables

Re: Multiple excel sheets and get all headers from each excel file

Re: Replace values

Latest no empty data find

Array and keep all if condition met

Re: Keep observations matches

Re: Keep observations matches

Re: Keep observations matches

Re: Keep observations matches

Re: Keep observations matches

Re: Keep observations matches

Keep observations matches

Re: Find a value and print put in log

Re: Find a value and print put in log

Find a value and print put in log

Infile text file and get last character from file

Remove the last 2 zeros

DIF by ID sql