Hello, I am trying to read raw data into a sas data set and I keep getting numbers like 1690411140. I am having trouble formatting this into a normal date, such as 8/23/2013... Any help would be much appreciated! I am new to SAS and this one little thing is holding me up! Example of raw data file (fake data) Student,Points Awarded,Points Available,%,Grading Status,Finished On,Version John Doe,10,10,100%,Graded,7/25/2015 10:39 PM,4 Code I wrote: options validvarname=any; data work.test; infile 'C:\mypath\file.csv' dlm=','; Module='Test Name'; length Student $ 20; input Student $ Points_Awarded Points_Available '%'n percent4. Grading_Status $ Finished_On : MDYAMPM20. Version $; format '%'n percent6. Finished_On month9.; drop Grading_Status Points_Awarded Points_Available Version; if Student='Student' then delete; run; proc print data=work.test; run; Output: Test Name         John Doe         100%           1690411140   (want this to be formatted as a date) Thank you so much for your help! ... View more

Hey everyone, I am trying to create a variable that references the input file's filename (without extension). Is there a way to do this? I am going to combine multiple test files into one excel file so I can run pivot tables for grade reports. Using the filename would be an easy way to assign the module or test name. for example: data work.test;      infile 'C:\xxx.csv' dlm=',';      Module='INSERT CODE FOR FILENAME REFERENCE HERE'      length Student $20;      Input Student Grade;      format grade percent6.; run; proc print data=work.test; run; Then under the variable "Module", you would see "test 1" "test 2" "test 3" etc. Thanks for your help! ... View more