cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lucas1
‎07-04-2018
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Problem Importing Dates from CSV File

by Calcite | Level 5 in SAS Programming
‎07-04-2018 03:38 PM
‎07-04-2018 03:38 PM
Is this what you're referring to?   SAS Studio Alphabetic List of Variables and Attributes# Variable Type Len Format Informat1 DECEASED_DATE Num 8 MMDDYY10. MMDDYY10. ... View more

Re: Problem Importing Dates from CSV File

by Calcite | Level 5 in SAS Programming
‎07-04-2018 03:33 PM
‎07-04-2018 03:33 PM
SAS Studio 4 DECEASED_DATE Char 1 $1. $1.   When I run the coding you provide this is the error message I get: SAS Studio 65 format DECEASED_DATE mmddyy10.; _________ 484 NOTE 484-185: Format $MMDDYY was not found or could not be loaded.   Coding used: data import_with_date; set import; format DECEASED_DATE mmddyy10.; run; ... View more

Re: Problem Importing Dates from CSV File

by Calcite | Level 5 in SAS Programming
‎07-04-2018 03:22 PM
‎07-04-2018 03:22 PM
Could you elaborate on the "specification accompanying the file"? Not sure if I understand you completely.   The only difference from the successful import and unsuccessful is in the CSV file where I put a date in the first row of data.    Thanks, Lucas ... View more

Problem Importing Dates from CSV File

by Calcite | Level 5 in SAS Programming
‎07-04-2018 03:13 PM
‎07-04-2018 03:13 PM
I am attempting to import a CSV file into SAS Studio, however all dates (formatted as 9/11/2012 in the csv) are being converted to the single digit numbers. If I cut and insert a row at the top of the data then it imports it properly. Please help, I don't understand why having the second row (1st row has my variable names) without a date causes this error. Thanks!   Here is the code for my import: %web_drop_table(WORK.IMPORT); FILENAME REFFILE '/folders/myfolders/DP_NUTR_BMI-REQUESTED-20180227-1.csv'; PROC IMPORT DATAFILE=REFFILE DBMS=CSV OUT=WORK.IMPORT; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.IMPORT; RUN; %web_open_table(WORK.IMPORT); ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-04-2018 08:22 PM
Quick links