Hello,    I am trying to extract text files that are saved within multiple zip files. For example, I need to extract a text file within a structure such as "C:\Users\myname\Documents\files.zip\specifictextfile.zip\mydata.txt".    In my case, each text file is saved within their own zip file inside "files.zip". I have been able to successfully extract the text file within a single zip level, so something like  "C:\Users\myname\Documents\specifictextfile.zip\mydata.txt" but I cannot get it out of the two level zips.    This resource was extremely helpful with extracting from a one level zip: https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/   Even if I could just extract the second level zips into their own folder, I could use the code at the link above to extract the text files from there. Does anyone know if this is possible or have any ideas how to do this? I could resort to manually extracting the "files.zip" first then using sas to read the txt files within each "specifictextfile.zip" zip, but I would rather not if possible. Let me know if I can provide additional information to assist with my question. The only example code I have was the code used in the blog to extract from a single zip file so I did not bother including it. Thanks so much.  ... View more

Hi all,    I was creating a US county level population distribution map using the most recent mapsgfk.us_all dataset and I noticed that two counties were not being mapped correctly, they are being cut in half diagonally. The two counties are Fayette County, Illinois and Cross County, Arkansas. It was fairly apparent on my full map as they are white spaces in an otherwise completed map. I include code below that will allow you to see the issue and I included a screenshot of the output. Is there a way to manually correct this or is this behavior somehow intentional? Any input would be appreciated. Thanks.    I am using SAS 9.4 TS1M5.   proc gmap map=mapsgfk.us_all data=mapsgfk.us_all /*all density=1*/; id id; choro county / nolegend /*levels=1*/; where statecode in ("IL", "AR"); run; quit; ... View more

I apologize if this is the wrong board, but since I am using PROC GMAP, I posted here. I am using SAS 9.4 TS1M5.    I am new to mapping and I am trying to map Puerto Rico using the mapsgfk.us_all dataset supplied with SAS. I need the map to be at the county (municipio) level. When I create the map using this dataset, it maps it at the county subdivision level. My data is still mapping correctly (filling up each sub division to fill the entire county), but considering my data is at the county level I would rather not give the impression my data is more granular. Does anyone know of a way to remove the subdivision lines and only show the major county lines? The odd thing is that it seems Puerto Rico has more granular information than the rest of the US in this file. When using the ID field in mapsgfk.us_all for the id statement in PROC GMAP, it maps all of the US correctly using a code such as 'US-15001' and the ID2 field is empty, but for Puerto Rico data, the ID field looks more granular such as 'PR-7200100401' and the ID2 field looks more like the other identifiers 'PR-72001'. When I try to use ID2 to map the data, it looks very distored. I included code below which maps Puerto Rico at the subdivision level and I included images of what the non-distorted map looks like (using ID) and what the distorted map looks like (using ID2 which seems to be at the county level). I have tried using PROC GREDUCE, but it seems like this is not solving the problem but I wonder if it is needed here. If anyone knows how to only map the county lines and not the subdivision lines, I would greatly appreciate it. Thank you! proc gmap map=mapsgfk.us_all data=mapsgfk.us_all ; id id; choro state / nolegend ; where statecode="PR"; run; quit; ... View more

Hi all,    I am trying to output a docx file using SAS. I was having some issues with formatting using RTF so I wanted to give docx a try. I am using SAS 9.4 TS1M6 in which ODS word is in preproduction. When I try to open the outputted docx, I am getting the error you see below. I have attached some sample code to mimic what I am doing, but it is really not all too complicated. I also provided the link to a paper I was using on the subject. Anyone have an idea how to prevent this error? For what it is worth, when I output this using ODS RTF and .RTF (instead of .docx) it works just fine.   data mydata; input var1 $ var2 $ var3 $ var4 $; datalines; 18-24 10.00% .5 1 25-34 10.00% .5 1 35-44 10.00% .5 1 45-54 10.00% .5 1 55-64 10.00% .5 1 ; ods escapechar="^"; %Let year_range=Jan 2018 – Dec 2018; proc format; value $ sym '1' = '^{unicode 2713}'; run; %macro hex2(n); %local digits n1 n2; %let digits = 0123456789ABCDEF; %let n1 = %substr(&digits, &n / 16 + 1, 1); %let n2 = %substr(&digits, &n - &n / 16 * 16 + 1, 1); &n1&n2 %mend hex2; /* convert RGB triplet (r,g,b) to SAS color in hexadecimal. The r, g, and b parameters are integers in the range 0--255 */ %macro RGB(r,g,b); %cmpres(CX%hex2(&r)%hex2(&g)%hex2(&b)) %mend RGB; ODS word file="locationhere\name.docx"; proc report data=mydata split='*' style(hdr)=[foreground = Black background=%RGB(126,172,147) font_size=2.5 font_face=Arial verticalalign=m height=.52in just=c] spanrows style(column)=[font_size=1.8 font_face=Arial height=.35in verticalalign=m background=%RGB(255,255,255)]; define var1 / display 'Var1' style=[cellwidth=2.1in]; define var2 / display "Var2* &year_range" style=[cellwidth=1.5in just=c]; define var3 / display 'Var3' style=[cellwidth=1.5in just=c]; define var4 / display 'Var4' style(column)=[just=c font_size=4 cellwidth=1.4in verticalalign=m font_face=Arial]; format var4 $sym.; run; ODS word CLOSE;   https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3235-2019.pdf   ... View more