Good morning.   I need to loop a macro a number of times based on unique values in a data table. I have a table of information from which I'm pulling unique values, counting them and then using those values in my ODS (file names). I've broken out the steps as much as I can to try to find out where I'm going wrong, but I can't seem to solve this.   In the first step I want all distinct values for casel. The second step just counts how many unique values I have. The third step inserts the unique values with the count into a variable. The second step is where the error normally occurs. put(count(*),1.) only seems to work if there are a particular count of unique values. If the count goes over (or under) that limit I get the erorr: ERROR: Invalid value for width specified - width out of range. changing the 1 to a 2 solves the issue but only until the unique value count decreases/increases on some subsequent run. Then I'll get the same error.   I'm at a loss on how to either do this better or to assign the value dynamically based on the unique values. Of course I could be totally misunderstanding the issue here so any help would be much appreciated.   Thank you.   CASE_12 CASEL 1111 2222 3333 4444 5555 6666 7777 8888 9999 1010   /*List the distinct values so I can see and count them.*/ proc sql; create table report_casel as select distinct casel from case_12; /*Count the number so I know how many times to loop.*/ select put(count(*),1.) into :cnt from report_casel; /*Insert the casel into a variable.*/ select casel into :casel1 - :casel&&cnt from report_casel; quit; /*Create one report for each existing casel.*/ %macro create_reports; /*Set the looping initial value.*/ %let w = 1; %do %until (&w. > &cnt.); /*Do reporting.*/ %let w = %eval(&w. + 1); %end; %mend; %create_reports;     ... View more

Good morning. I'm hoping someone could help me with an error I'm receiving.    I've simplified my steps as much as I can to attempt to pin down where my error is coming from but so far I've been unsuccessful.   In running the attached code I get the following error:   ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.   What I'm attempting to do is to initialize a variable and then use that variable in a SQL step. The first error I received was the SQL step looking for the "location_str" variable as a column in the SAS_COMM_TEST_DATA file. That was really strange since I am looking at the values within the location variable not the actual variable names. These steps seem pretty straight forward but I can't seem to determine where I've gone wrong with either error. I know there must be a better way to do this but this is what I have in an attempt to just get it to work.   I'd sure appreciate any help or advice on how to best/better proceed.   Thank you. data _null_; if week_day = 2 then do; location_str = 'LOCA 1'; title_location = 'LOCA 1'; end; call symput("location_str",location_str); call symput("title_location",title_location); run; proc sql; create table test_01 as select a.key, a.location from SAS_COMM_TEST_DATA as a where a.location contains (&location_str.) order by a.key; quit; key location 1 LOCA 1 2 LOCA 2 3 LOCA 3 4 LOCA 4 5 LOCA 5 6 LOCA 6 7 LOCA 7 8 LOCA 8 9 LOCA 9 10 LOCA 10 11 LOCA 11 12 LOCA 12 13 LOCA 13 14 LOCA 14 15 LOCA 15 16 LOCA 16 17 LOCA 17 18 LOCA 18 19 LOCA 19 20 LOCA 20   ... View more

Good morning.   I am attempting to find the first day of each month for which a record exits. For instance, person_1 may have been involved from 1/10/2012 through 8/17/2020 while another may have very different dates of involvement. What I need is the first day of each month in the range where the person existed. So person_1 would exist in 2/1/2012, 3/1/2012, 4/1/2012 all the way to 8/1/2020 and be counted on each first of each month. Unfortunately I don't have a clear "date" from which to count from I only have a range to count within.   Could anyone point me in the right direction?   Thanks very much.   Have person start end PERSON_1 1/10/2012 8/17/2020 PERSON_2 10/2/2020 10/30/2020 PERSON_3 9/30/2009 9/30/2021 PERSON_4 10/15/2013 2/19/2014 PERSON_5 2/1/2017 12/31/2021 PERSON_6 2/1/2017 10/3/2021 PERSON_7 6/29/2012 11/30/2018 PERSON_8 7/6/2014 11/15/2016 PERSON_9 7/29/2013 6/14/2017 PERSON_10 1/6/2014 6/19/2019     ... View more

Good morning.   I wanted to ask a general question about output file last modified date. I don't have example code so I was looking for a hint or just a general direction to search to see if it's possible for SAS to set the output file last modified date to a different defined date? For instance, if I have an ODS EXCEL or PROC EXPORT process at 9:30 AM on May 5, that will become the output file last modified date. Can I force that last modified date to be a different date and time? Is there such a feature in SAS?   Thanks for any direction someone could point me. ... View more