Help using Base SAS procedures

PROC IMPORT

Reply
Occasional Contributor
Posts: 16

PROC IMPORT

I HAVE A DATASET IN EXCEL. I HAVE 3 VARIABLES. ALL ARE IN DATE FORMAT. I USED PROC IMPORT TO READ THE FILE INTO SAS. ONE OF THE COLUMNS COMES UP BLANK IN SAS, WHILST IN EXCEL THE CELLS ARE NOT EMPTY. I TRIED TO USE FORMAT mmddyy10. AND I GOT A MESSAGE SAYING VARIABLE HAS BEEN DEFINED AS BOTH CHARACTER AND NUMERIC. HOW CAN I RECTIFY ALL THESE.
Frequent Contributor
Posts: 81

Re: PROC IMPORT

It would help us understand the problem if you could post your SAS code.

You may try using the statement MIXED=YES in your proc import procedure.
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation