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
- 29621 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 |
SAS using companies in chennai
In PROC PRINT, can you print only variables that begin with the letter “A”?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What was the last computer book you purchased? Why?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
wt is a-z and a--z?
what are scrubing procedures in SAS?
What is the difference between informat and format statement?
what is study design in while working with SAS? what are screening variables in SAS?
What is program data vector (pdv) and what are its functions?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Teradata 
