About shellp55

shellp55 · ‎10-20-2023

Thank you, Kurt, but I have ++ tables to export to Access and it really would be better if I could export directly.

shellp55 · ‎11-10-2020

Thanks Reeza, but I'm not understanding what you mean. Where would this statement go in relation to the code I provided? Thanks so much.

shellp55 · ‎11-09-2020

You are correct, Reeza, I was missing a subfolder in the name. Now it works and all is well. Thanks very much.

shellp55 · ‎06-12-2020

Thanks to the both of you for your speedy response! Ballardw's solution works exactly as I required, thank you so much! Have a great weekend everyone!

Kurt_Bremser · ‎02-18-2020

@shellp55 wrote: I was wrong...if I open the file in Notepad then it shows as one would expect: mmddyy hh:mm:ss so it's unclear why it wouldn't be importing correctly. 04/03/18 17:00:00 imports as March 4, 2018 instead of April 3, 2018. I'd rather read that as March 18, 2004. This just illustrates the stupidity of not using ISO-formatted dates and times, and (still!) using 2-digit years. After the Y2K scare, this makes me doubt my faith in the future of mankind.

shellp55 · ‎10-24-2019

Thank you so much to all who responded, I really appreciate it. Tom, I did not know that you could use a wildcard for the infile statement so that will be life changing for future code! I also liked the simplicity of the code you provided and it worked like a charm. Have a great day everyone!

shellp55 · ‎07-12-2019

Hello I was missing the proper files so they have now been loaded and everything works as it should. Thanks everyone!

shellp55 · ‎06-28-2019

Thanks Reeza!! A perfect example of my trying to make it more difficult than it is!

shellp55 · ‎05-08-2019

Thanks ChrisNZ, that will work. I actually found an error in my cards as regn 1002 should have the regdate and dispdate be the same. I also found a different program to use for the readmits that meets my needs. It is based on SAS paper 1622-2014 from Sarfaraz and Fen of UMWA. proc sort data=grp1;by chartno regn;run; data solution1; set grp1; by chartno regn; ref_date=lag(dispdate); format ref_date regdate dispdate yymmdd10.; label ref_date="Reference Date"; gap=regdate-ref_date; if first.chartno then do; ref_date = .; gap=.; tag=.; readmissions=.; end; if 0<=gap<=30 then tag=1; readmissions+tag; if tag gt 0 then output; run;

shellp55 · ‎04-18-2019

Thanks Reeza but figured it out and posted solution. Much less work to write it this way too! Thanks for pointing me in this direction from the other post this afternoon!!

Reeza · ‎04-18-2019

FYI - for the new tagset you linked to you, you need to use ODS TAGSETS.EXCELXP_mod Your code as shown doesn't do that, what happens if you fix that? It references the parent tagsets so should still maintain all features. I tried all the options above but couldn't figure it out 😞 I also looked at the XML file and it appears to be using #FFFFF format but at the same time couldn't find the blue (0000FF) specified :(. My next debugging step would be to create two files, one with colours, one without and do a file comparison to see how it's being set and work backwards from there. Unfortunately I don't have the time to do that now.

shellp55 · ‎04-17-2019

Wow, so many people answering on this site, thanks very much Novinosrin!!

Ksharp · ‎07-12-2018

If you have SAS/IML, you could try CALL EXECUTEFILE() .

shellp55 · ‎01-15-2018

Thank you so much! "Taming" is a great description and I will certainly tuck this code away for another day. Thanks for taking the time to respond.

shellp55 · ‎10-04-2017

Thanks Reeza but it will take awhile to de-identify my data. I think you are correct that it is the blank values because I changed my test data so that there is no data in _proc1 and _date1 and it erroneously flagged the case as matching my criteria. i'm trying to use if not missing(px1) to include an 'else if missing(_proc1(i)) then leave but I get an error that I do not have a matching do/select statement.

Online Status	Offline
Date Last Visited	‎11-26-2023 11:40 PM

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Exporting SAS dataset to MS-Access

Re: Memo Field in First Row of Excel Export?

Memo Field in First Row of Excel Export?

Re: Creating Export Name from Variables?

Re: Creating Export Name from Variables?

Re: Exporting Data to Acess - Error

Re: Exporting Data to Acess - Error

Re: Rename Macro Do Loop Where Value is 1 Less than Current Occurence

Re: ODS Excel tagattr not working for data types/formats

Re: Exporting SAS dataset to MS-Access

Re: Memo Field in First Row of Excel Export?

Re: Creating Export Name from Variables?

Re: Summary of Minutes per Day Between Two DateTime values?

Re: Infile CSV Issue with Date Time Format

Re: CSV Import - Add Column From File Name?

Re: Exporting Data to Acess - Error

Re: Rename Macro Do Loop Where Value is 1 Less than Current Occurence

Re: Code Not Picking Next Visit as Readmit

Re: ODS Excel tagattr not working for data types/formats

Re: ods options for tab_color not working

Re: How to Control Starting Point of Do Loop Based on Results of Other...

Re: Calling SAS code from another SAS program including passing variab...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Comparing Arrays in same dataset?