BookmarkSubscribeRSS Feed
Edwinl
Calcite | Level 5

I tried to import excel file using the file, but SAS data step processing never end running, I just have to end the process. I am not sure what why I couldn't read in the data

Any help please?

NOTE:
DATA statement used (Total process time):

      real time           3:47.30

      cpu time            0.37 seconds

531   data cholesterol;

532  infile 'F:\UQ\dcm\module 1\cholesterol.prn';

533  input @6 id 3. @16 cholest 1. @20 gender $1.
@30 systolic 3. @38 diastolic 3. @46 height 3.

533!  @54 weight 3. @64 ses 1. @73 dob $20 @ 89 da

534  te_assess $10.;

535  ;

2 REPLIES 2
PGStats
Opal | Level 21

You need a run; statement at the end for the data step to execute.

PG
Edwinl
Calcite | Level 5


Thanks heaps

that solved my problem.

much appreciated

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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