How to import the Zip files into SAS? If it is possible in
SAS? If it is posible write the code...
- 7 Answers
- 27576 Views
- I also Faced
- E-Mail Answers
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 |
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
What are the criticality that you have faced during your project in SAS?
what is the need of INDEX in datasets?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is the difference between %put and symbolgen?
which features do you use to check the data validations and errors? : Sas-administrator
what r the job openings SAS for fresher graduates !
For what purpose(s) would use the RETURN statement?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
Teradata 
