About fordcr2

fordcr2 · ‎04-08-2019

As of right now, there are 107 observations and 11 variables from all_ids, but that number will grow as more are enrolled in the study. I would love to not use a macro if possible, but I have not figure out how to calculate a weekly interval variable. I would use the participant_startdate variable and have to count out 7 days from that date in order to get the weekly interval that I need for each participant. I have matched participants with their assigned providers so I can compare the provider login date with the patient login date.

fordcr2 · ‎04-08-2019

So I replaced %let start='24Jan2019',d; with %let start=participant_startdate; and put data set_weeks; set all_ids; (this is the dataset) and it keeps crashing SAS. I get an error "OUT OF RESOURCES. Select: R. Retry, N. Tell procedure/DATA step no more resources, C. Cancel submitted statements, T. Terminate SAS"?

fordcr2 · ‎04-08-2019

Hello, I am trying to calculate a percentage of health care providers that log into an online platform within a week of their patients logging in. I have a dataset with the date that the patient logged in as well as the dates in which the providers have logged in. This dataset will end up being very large (as the study will go on for 2 years with over 150 participants), so I need to figure out how to automate a SAS code to calculate weekly intervals based off of the date that the patients logged in. Not all patients log in on the same day, so I can't figure out how to do this. I found this macro online which makes weekly intervals, but I would need these intervals to be based off of a variable (participant_startdate) instead of a date that I could put in like this '24Jan2019'. I hope that makes sense! %let start='24Jan2019'd; %let end=date(); data set_weeks; retain fmtname 'weeks'; start=&start; end=start+6; label="Week: "||PUT(start, mmddyy10.)||" - "||PUT(end, mmddyy10.); OUTPUT; DO UNTIL (end > &end); start=start+7; end=end+7; label="Week: "||PUT(start, mmddyy10.)||" - "||PUT(end, mmddyy10.); OUTPUT; end; keep fmtname start end label; format start end mmddyy10.; run;

fordcr2 · ‎03-01-2019

That worked great! Thank you. I just needed it in the 02/21/2019 format to use for an internal study.

fordcr2 · ‎03-01-2019

Hello, I know there are a lot of posts about formatting dates, but I have not been able to find one that works for my problem. I am trying to import data where the dates are formatted like "2/21/2019" from an xslx workbook with multiple sheets. When I bring these sheets into SAS, the dates are converted to "43517" and this is being considered a character variable by sas. I have tried to make a new date variable using: date_=input(Date, mmddyy10.); but I keep getting this error: NOTE: Invalid argument to function INPUT at line 579 column 34 Please help! Thank you

fordcr2 · ‎02-21-2019

I figured it out using this code - thank you! Changed it to: Data PARI; set xml_files; date = input(DATE_TIME,yymmdd8.); time = input(substr(DATE_TIME,9),hhmmss6.); format date mmddyy10. time time8.; put (_all_) (=); run;

fordcr2 · ‎02-21-2019

You're misunderstanding what I said. I was regarding the "str" variable for the string. Right now what that would do is autofill the same str variable for each DATE_TIME variable and subsequently each new output for date and time. I am asking how to make it so that a new str value will be produced for each DATE_TIME variable input.

fordcr2 · ‎02-21-2019

This works great! Do I need to make a macro so that the str variable will update? Ex) the first DATE_TIME is 20181002105310 which comes out to date: 2018-10-02 time: 10:53:10 the next DATE_TIME is 20170509073215 and I would need the same type of output for date and time, is there a way to make a loop where SAS will just read all of these DATE_TIME variables and convert them accordingly?

fordcr2 · ‎02-21-2019

Hello, I have seen some posts about splitting text strings into multiple variables, including some date/time strings, but I have not found a solution that would work for my problem. I am importing device data that has multiple variables and one variable for date and time (called DATE_TIME). I need the string to be parsed out into date (formatted like 02/21/2019, so mmddyy10.) and time. An example of the string I am working with: 20181002105310 This would be 10/02/2018 at 10:53:10. If it is helpful - there are about 728 observations in this dataset, and I need to do this for two variables (DATE_TIME and TRANSMISSION_DATE_TIME) so it would be nice to be able to do this efficiently if possible 🙂

fordcr2 · ‎02-11-2019

I am using SAS 9.4

fordcr2 · ‎02-11-2019

That is the folder in which all of the XML files are held though? I specifically made the folder on my H drive in a sub folder practice then another folder called PARI which I dragged and dropped all of the xml files to.

fordcr2 · ‎02-11-2019

Ok. When I did that it said: Directory of h:\Practice\PARI File Not Found

fordcr2 · ‎02-11-2019

Microsoft Windows [Version 10.0.17134.523] (c) 2018 Microsoft Corporation. All rights reserved. H:\>h:/Practice/PARI/ 'h:/Practice/PARI/' is not recognized as an internal or external command, operable program or batch file. H:\>

fordcr2 · ‎02-08-2019

Thank you for your comments. So that directory is where all of the XML files are stored, but for whatever reason it is still reading in 0 observations: NOTE: The infile INLIST is: Unnamed Pipe Access Device, PROCESS=dir "h:/Practice/PARI/*.xml" /b, RECFM=V,LRECL=32767 Stderr output: File Not Found NOTE: 0 records were read from the infile INLIST. NOTE: The data set WORK.DIRLIST has 0 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.01 seconds 258 259 filename inlist clear; NOTE: Fileref INLIST has been deassigned.

fordcr2 · ‎02-08-2019

That didn't work either... I don't expect you to write it for me but I do not understand what you are doing in this code and therefore I don't know how to start with the debugging. The code isn't reading in any observations at all and I don't know why that is...

Online Status	Offline
Date Last Visited	‎01-30-2025 12:43 PM

Re: I need to order survey data by date and month and add rows for mis...

I need to order survey data by date and month and add rows for missing...

Re: How can I combine uses within 25 minutes of each other?

How can I combine uses within 25 minutes of each other?

Re: Parsing out and formatting a time variable from a yyyymmddhhmmss n...

Re: Parsing out and formatting a time variable from a yyyymmddhhmmss n...

Re: Parsing out and formatting a time variable from a yyyymmddhhmmss n...

Parsing out and formatting a time variable from a yyyymmddhhmmss numer...

Reformatting a date variable from YYYYMMDD to MM/DD/YYYY

Re: Parsing out date from character string

Re: Parsing out and formatting a time variable from a yyyymmddhhmmss n...

Re: Counting the number of observations within a time frame

Re: Splitting a date/time string with no delimiter

Re: Create weekly intervals with different start dates

Re: Create weekly intervals with different start dates

Create weekly intervals with different start dates

Re: Excel to SAS date format issues

Excel to SAS date format issues

Re: Splitting a date/time string with no delimiter

Re: Splitting a date/time string with no delimiter

Re: Splitting a date/time string with no delimiter

Splitting a date/time string with no delimiter

Re: Importing multiple XML files (hundreds at a time)

Re: Importing multiple XML files (hundreds at a time)

Re: Importing multiple XML files (hundreds at a time)

Re: Importing multiple XML files (hundreds at a time)

Re: Importing multiple XML files (hundreds at a time)

Re: Importing multiple XML files (hundreds at a time)