topic Re: Learning Macros: ZIP file doesnt create any files. in New SAS User

Learning Macros: ZIP file doesnt create any files.

romonysh — Fri, 10 Apr 2020 23:26:35 GMT

Hello, I am learning to use SAS with SAS studio via a virtual machine on a mac. I am learning how to use macros, and am trying to use a macro to unzip a file. The program ran with no problem, the shared folders were able to be accessed, yet the output didnt provide anything.

Here is my code

dm 'clear log';
Options nocenter nodate nonumber symbolgen;
%Let Path = /folders/myfolders/;
Libname mylib "&Path";
%macro readraw (first=, last=);
Filename ZIPFILE SASZIPAM "&Path/names.zip";
%do year=&first %to &last;
DATA mylib.DSN&Year;
INFILE ZIPFILE(yob&year..txt) DLM=",";
INPUT name $ gender $ number;
RUN;
title "Listing from Data Set (Newborns' Names) for &Year";
proc print data=mylib.DSN&Year(obs=5) noobs;
format number comma7.;
run;
%end ;
%mend readraw;
%readraw(first=2000, last=2005)

Ive attached the zip file and my log when I run it. I should be getting data sets for the years 2000-2005, instead I get empty data sets

Re: Learning Macros: ZIP file doesnt create any files.

Shmuel — Fri, 10 Apr 2020 23:55:34 GMT

Have you noticed the error message in log:

ERROR: Member yob2000.txt does not exist.

check the name(s) in the zip file.

Re: Learning Macros: ZIP file doesnt create any files.

romonysh — Sat, 11 Apr 2020 02:29:51 GMT

Yeah I noticed the error, but I checked and that named file is in the zip. So I am still confused. Thank you for looking!

Re: Learning Macros: ZIP file doesnt create any files.

Shmuel — Sat, 11 Apr 2020 02:46:39 GMT

Cheking the zip file there are two subfolders.

Why not extract the files from the zipped folder, then the filename should be:

"&path/names/names/yob2000.txt";

Re: Learning Macros: ZIP file doesnt create any files.

Kurt_Bremser — Sat, 11 Apr 2020 10:57:38 GMT

Rule #1 for macro development: start with code that works for a single, non-dynamic instance. Then use macro language to make the code dynamic.

This worked for me:

filename zipfile zip '/folders/myfolders/names.zip';

data dsn1997;
infile zipfile(names/yob1997.txt) dlm=",";
input name $ gender $ number;
run;

Re: Learning Macros: ZIP file doesnt create any files.

romonysh — Sun, 12 Apr 2020 18:05:33 GMT

This also worked as a solution! thank you!