Interested to Buy Any Domain ? << Click Here >> for more details...
How to import the Zip files into SAS? If it is possible in
SAS? If it is posible write the code...
- 7 Answers
- 29336 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 |
What are the joins,types of joins and thier functions?
Do you prefer Proc Report or Proc Tabulate? Why?
Describe 5 ways to do a “table lookup” in SAS?
What is the purpose of _character_ and _numeric_?
Explain the difference between using drop = data set option in set and data statement?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
What is interleaving in SAS?
what is the purpose of _error_? : Sas programming
what is the diff b/w verification validation in sas
where will go the observations that were deleted by delete statement?
how can you create zero observation dataset? : Sas programming
what is syntax of proc merge ?
Teradata 
