SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

UsingSAS9.3-Generate password protected ZIP file(csv file in) and Get the properties of the Zip file

Reply
Occasional Contributor
Posts: 19

UsingSAS9.3-Generate password protected ZIP file(csv file in) and Get the properties of the Zip file

[ Edited ]

Hello All,

 

 I'm using SAS 9.3, i have a situation like

1. To generate CSV for the Data and generate password protected ZIP of the CSV.

2. Get the properties of ZIP file like

                           Filename of data file
                           Data file creation date
                           Uncompressed data file size in bytes

                           Number of columns in data file (if applicable)
                           Number of rows in data file, including header row (if applicable)

     including the original file datetime stamps, file size, and compressed size.

 

Kindly, help me out with the situation. I could find the code for 9.4, however i cant find the code for 9.3

 

Thanks,

Pavan.Ch

Super User
Super User
Posts: 9,402

Re: Using SAS 9.3 - Generate password protected ZIP file(csv file and Get the properties of the Zip

There isn't code SAS v9.3.  If you are sending a datafile, use a secure portal or SFTP.  Zip file via email is not really acceptable in this day and age, nor is taking file properties from the OS which can easily be manipulated.

Occasional Contributor
Posts: 19

Re: Using SAS 9.3 - Generate password protected ZIP file(csv file and Get the properties of the Zip

 Hi  RW9,

 

We have a client requirement to send it that way.

Super User
Super User
Posts: 9,402

Re: Using SAS 9.3 - Generate password protected ZIP file(csv file and Get the properties of the Zip

[ Edited ]

Then bill them the time each time to manual create a zip file and get the properties.  If they ask you to program whilst bouncing up and down and reciting the alphabet backwards...

 

Actually to say it isn't possible is a bit far, you would need to call the zipping program from the command line, e.g. X call or call system.  And of course have the privilidges to access command line.

Super User
Posts: 9,873

Re: UsingSAS9.3-Generate password protected ZIP file(csv file in) and Get the properties of the Zip

You do not need to "get" the properties of the csv file, you already have them in the data step that writes the csv.

The other values are best determined by using operating system commands.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 203 views
  • 0 likes
  • 3 in conversation