@SASuserlot wrote:
Yes, I am having trouble with column statement.
More than that. You are having problems with 1) informats 2) missing DATALINES statement and 3) a not-standard-for-SAS date time appearance, or at least I can't find a "standard" date time format with the month abbreviation as shown.
data vital;
infile datalines;
informat usubjid $11. param $10. status $5. visit $7. firstdtc seconddtc $20. type $10. ;
input usubjid $11. param status visit firstdtc seconddtc type ;
array din firstdtc seconddtc;
array dtc{2};
do i= 1 to dim(din);
d = input(substr(din[i],1,11),anydtdte11.);
t = input(substr(din[i],13,8),time.);
dtc[i] = dhms(d,0,0,t);
end;
format dtc1 dtc2 datetime20.;
drop i d t ;
datalines;
SD-1001-101 diastolic pre Visit1 2018-MAR-19T10:10:10 2018-MAR-19T10:30:10 first
;
If you use a simple $ informat then the length of the variable is truncated to 8 characters. So I used and informat to specify longer values. Second with the non-typical date time I have broken into the date and time portions to then create a datetime value with the DHMS function.
You find with SAS it is usually a much better idea to have a common variable meaning appear first and then number them as I did with dtc1 and dtc2. For one thing there are places where you can use lists of variables and if you have 20 similar variables it is much easier to use dt1 - dtc20 to reference all of them instead of having to type first... second... nineteenth... and so on.
Having the date and time information in a datetime variable is much more flexible than a character value as there are functions to manipulate such and a number of formats to display the values.
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/... has a PDF with much information about dates.
