Hello Dear all, Very sorry, I am really new to SAS, I just need to get the XPT file from the zip file then i need it to convert in sas7bdat. But Due to file size (more then 1 gig) i can not import it from local PC ... View more

  1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 *path to the zip file; 70 filename src zip "/home/u63672513/Mydata/LLCP2022XPT.zip"; 71 72 *path to where to save the xpt file; 73 filename xl "/home/u63672513/Mydata/LLCP2022.xpt" ; 74 75 *extract file from zip - P_DR2IFF.XPT in the code below is the name of the file in the zipped file that is to be 75 ! extracted; 76 data _null_; 77 /* using member syntax here */ 78 infile src(LLCP2022.xpt) 79 lrecl=256 recfm=F length=length eof=eof unbuf; 80 file xl lrecl=256 recfm=N; 81 input; 82 put _infile_ $varying256. length; 83 return; 84 eof: 85 stop; 86 run;   ERROR: Entry LLCP2022.xpt in zip file /home/u63672513/Mydata/LLCP2022XPT.zip does not exist. ERROR: Physical file does not exist, LLCP2022.xpt. NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file XL is: Filename=/home/u63672513/Mydata/LLCP2022.xpt, Owner Name=u63672513,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=11Nov2023:10:27:26   NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 553.87k OS Memory 19616.00k Timestamp 11/11/2023 04:27:26 AM Step Count 24 Switch Count 0 Page Faults 0 Page Reclaims 150 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0     87 88 *where to store the SAS dataset; 89 libname projfile '/home/u63672513/Mydata'; NOTE: Libref PROJFILE refers to the same physical library as SASDATA1. NOTE: Libref PROJFILE was successfully assigned as follows: Engine: V9 Physical Name: /home/u63672513/Mydata 90 91 *XPT file (same as filename xl as above); 92 libname xptfile xport '/home/u63672513/Mydata/LLCP2022.xpt' access=readonly; NOTE: Libref XPTFILE was successfully assigned as follows: Engine: XPORT Physical Name: /home/u63672513/Mydata/LLCP2022.xpt 93 94 *extract the SAS dataset from the XPT file; 95 proc copy inlib=xptfile outlib=projfile; 96 run;   NOTE: Input library XPTFILE is sequential. WARNING: Input library XPTFILE is empty. NOTE: PROCEDURE COPY used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 589.40k OS Memory 19876.00k Timestamp 11/11/2023 04:27:26 AM Step Count 25 Switch Count 0 Page Faults 0 Page Reclaims 107 Page Swaps 0 Voluntary Context Switches 2 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8     97 98 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 108 Here is the log, please check ... View more

Thanks Reeza, But as i told i am very new, so i could understand, but also tried the 2nd part but rcvd error. I used your above code that is generating and   LLCP2022.XPT with 0 byte. here is my file. please advise     ... View more