How to import the Zip files into SAS? If it is possible in
SAS? If it is posible write the code...
Answers were Sorted based on User's Feedback
Answer / sushil nayak
Yes, reading a ZIP file in Windows SAS is possible. Use the Winzip Command Line Support Add-on and a FILENAME statement to read zipped files into a SAS data set.
Check out this link :: Sample 26011: Reading zipped files on Windows :: http://support.sas.com/kb/26/011.html#
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / vinod kumar
We can read the zipped files in to SAS by using the SASZIPAM
option.
filename file1 saszipam 'd:\Myfiles\dumps.zip';
data dset;
infile file1(dumps1.csv) dlm=','; *-dumps1.csv is one of
the file in zipped file;
input email $ name $ address $ city $ zip $;
put _infile_;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / paul
to read zip files SAS has special keyword i.e., SASZIPAM
eg:
FILENAME myzipfile SASZIPAM 'd:\filelocation\6100Txn.zip';
data _null_;
infile myzipfile(sales_JAN);
input;
put _infile_;
run;
/*here iam extracting sales_JAN file from 6100Txn.zip file
since we don't know the file structure put everything to log.
to see the file names in zip, physically access the zip file
without extracting the file contents. */
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sanjay
filename foo pipe '"c:\program files\winzip\wzunzip.exe"
-o -c
c:\sample01584_1_data.zip
testfile.txt';
/* The zip file, sample01584_1_data.zip, is flat file
created */
/* from PROC Export and SASHELP.CLASS.
*/
data test;
/* Use FIRSTOBS= to skip the first 8 records related to
zip */
/* information, and the 9th record which contains a header
*/
/* record of variable names from SASHELP.CLASS.
*/
infile foo firstobs=10 truncover dsd;
input name :$9. sex :$1. age height weight;
run;
proc print;
run;
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / no no no noooo
PROC IMPORT OUT= WORK.ALL
DATAFILE= "C:\Users\1234Documents\SENTHIL\dmp3split.zip"
DBMS=CSV REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;
| Is This Answer Correct ? | 4 Yes | 6 No |
for what purpose would you use the retain statement? : Sas programming
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?
Explain the purpose of retain statement.
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What are the statements that are executed only?
How to do user inputs and command line arguments in SAS? D&B
what are sas bi dashboard components? : Sas-bi
what is the purpose of _error_? : Sas programming
how many display types available in sas bi dashboard? : Sas-bi
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
what is the use of proc sql? : Sas programming
What is PDV?