Hello, I'm currently using CPS ASEC data to tally all available counties in the data set. I combined state and county codes to create a standard FIPS State/County code and listed all counties in the US, including states containing unlisted counties (see code). This made for one very long PROC FORMAT.  I'm getting mixed results when I use and don't use the format. When the format is used, 241 levels are reported. When the format isn't used, 280 levels are reported. The 39 geographies that aren't in the original Proc Freq are listed in the Proc Format and are contained in the data set, so I don't understand why the original freq isn't displaying them.   Any insight appreciated. data listed not_lstd; set work.ststst; if gxco = '000' then output not_lstd; else if gxco not = '000' then output listed; run; /*Gives frequencies for 329 levels identified and not-identified counties*/ proc freq data = work.ststst nlevels; table stcofips / missing; *no format; run; /*Gives frequencies for 241 identified counties*/ proc freq data = listed nlevels; table stcofips / missprint; format stcofips $counties. ; *format stcofips $counties. ; /*280 levels when omitted*/ run; /*Gives frequencies for 49 not-identified counties within states*/ proc freq data = not_lstd nlevels; tables stcofips / missprint; format stcofips $counties. ; run; ... View more

Hello! I've sorted my data and created a sorted output data set ("SORT_MARKT"). I'm attempting to use that sorted data set to plot my data and show an ascending trend line, but once the data is plotted, it's displayed as if no sort was ever applied. I'm not sure what exactly is causing this to display this way.   My code:   PROC SORT DATA = MARKETING OUT=SORT_MARKT ; BY sales  ; RUN; goptions reset=all border; symbol value=dot interpol=sms line=1 width=2 ; proc gplot data=SORT_MARKT ;     plot sales*case_number /  haxis = 1 to 21 by 1                               vaxis = 10000 to 23000 by 1000                               vref = 13000 17000 20000    ; run; quit;   The attached picture shows the sorted data set and the proc gplot output. What am I missing?   ... View more

Hey all, I'm a little stuck with how best to approach the input of a text file. Here's what my data looks like -   HOUSEHOLD RECORD DATA       SIZE   BEGIN RANGE                   D HRECORD     1      1   (1:1) U All households V          1 .Household record D H_SEQ       5      2  (00001:99999)      Household sequence number V All households V     00001- .Household sequence number V     99999  . D HHPOS       2      7  (00:00)     Trailer portion of unique household ID. 00 for HH record. Same function in family record is field FFPOS (01-39). Same function in person record is PPPOS (41-79).   Following "D " is always the variable name ("HRECORD"), which I want to input. Following the variable is the length ("size" column) which I also wish to input. "U" designates the universe; I want to keep that string. "V" designates the values for that variable, which I also want bring in. A variation of this structure, is when the "D" row is followed by a variable description, (between D and U or V). I'm not exactly sure how to import/input this text file considering it's data structure. A PROC IMPORT will bring everything in, but into just one column and some descriptions are truncated/cut off. I've thought about using character functions to start parsing the data.   The goal is to have a data set with the following columns: Var_Name, Length, Description, Universe, and Values.   Any insight?   (SAS 9.4 TS Level 1M4, Enterprise Guide 7.1) ... View more