Dear Scott,
Thanks a lot for the reply..
I used the option GUESSINGROWS=50 (my dataset has only 25 observations),
but it didn't work out.
I used the following code that was generated by PROC IMPORT:
data TS ;
2269 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
2270 infile 'P:\DVL_0865\Mapping\1160_0025\Trial_design_1160-0025.txt' delimiter='09'x MISSOVER DSD lrecl=32767 firstobs=2 ;
2271 informat STUDYID $9. ;
2272 informat DOMAIN $2. ;
2273 informat TSSEQ best32. ;
2274 informat TSPARMCD $10. ;
2275 informat TSPARM $46. ;
2276 informat TSVAL $500. ;
2277 format STUDYID $9. ;
2278 format DOMAIN $2. ;
2279 format TSSEQ best12. ;
2280 format TSPARMCD $10. ;
2281 format TSPARM $46. ;
2282 format TSVAL $500. ;
2283 input
2284 STUDYID $
2285 DOMAIN $
2286 TSSEQ
2287 TSPARMCD $
2288 TSPARM $
2289 TSVAL $
2290 ;
2291 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
2292 run;
For the variable TSVAL , I need the length to be 700.
I've copied the above program and changed the format and informat for TSVAL and it worked..
Is there any way that I can do this in PROC IMPORT STEP without adding the datastep. This is beacause, we are using the proc import step in a macro and we didn't want to have the set of variables that are in the data step.
Thanks a lot