Hi Jim, Attached is the code that we use to build SAS flat files from SQL server.
Steff noted that there are a few "time" fields that we do not fill (as we don't capture the data), which may automatically get set to "0000" in this code. If you use our SAS program as reference, keep an eye on the time fields and overall output. Hope this helps? I know the turnaround time is tight... Thanks, Laurel From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Campbell, James R Sent: Monday, July 22, 2019 11:24 AM To: GPC STANDARDS Cc: Research Informatics Group, UNMC Subject: [EXTERNAL] HELP on Loading MS SQL dates to SAS datasets for CDMV41 tables We are struggling to format our SAS datasets from the CDMV41 tables we have built and recently converted to MS SQL. The inbound dates from MS SQL end up as SAS Numeric 'DATE9' format which does not match the format we had employed before. Our date formatting code converts everything to '19600101' Has anybody identified the SAS code to yield the format which Duke likes? This was 'YYMMDDN8' when we brought in the data from Oracle. Jim Campbell The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ______________________________________________________________________ The contents of this message may contain private, protected and/or privileged information. If you received this message in error, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained within. Please contact the sender and advise of the erroneous delivery by return e-mail or telephone. Thank you for your cooperation.
Build Flat Files.sas
Description: Build Flat Files.sas
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
