Help using Base SAS procedures

SAS export from CVS wide to long

Accepted Solution Solved
Reply
Super Contributor
Posts: 303
Accepted Solution

SAS export from CVS wide to long

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???


Accepted Solutions
Solution
‎04-06-2016 01:28 AM
Super User
Posts: 7,768

Re: SAS export from CVS wide to long

Posted in reply to desireatem

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎04-06-2016 01:28 AM
Super User
Posts: 7,768

Re: SAS export from CVS wide to long

Posted in reply to desireatem

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 303

Re: SAS export from CVS wide to long

Posted in reply to KurtBremser

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 242 views
  • 0 likes
  • 2 in conversation