SAS export from CVS wide to long

desireatem — Wed, 06 Apr 2016 05:18:28 GMT

I imported this CVS file, save in a permenant directory and wish to convert from wide to long using code below but it doesn't work:

LIBNAME ICP 'E:\Dr.Olson\';
data ICP.test;
set ICP;
run;

DATA longICP;
SET ICP.test;
time=0;
timesecond=time0;
output;
time=6;
timesecond=time6;
output;
time=12;
timesecond=time12;
output;
time=18;
timesecond=time18;
output;

drop time0 time6 time12 time18;

run;

Log file

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LONGICP may be incomplete. When this step was stopped there were 0
observations and 3 variables.
WARNING: Data set WORK.LONGICP was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.06 seconds

ANY HELP???

Re: SAS export from CVS wide to long

Kurt_Bremser — Wed, 06 Apr 2016 05:22:57 GMT

The important error messages are further up in the log. Post these, so we can help.

Re: SAS export from CVS wide to long

desireatem — Wed, 06 Apr 2016 05:28:36 GMT

Thanks, I see the error now. I corrected it.

topic Re: SAS export from CVS wide to long in SAS Procedures

SAS export from CVS wide to long

Re: SAS export from CVS wide to long

Re: SAS export from CVS wide to long