Hello:   I use proc export to produce Excel spreadsheets, however, my variable names' labels are truncated.  The labels are truncated after my using the label statement in the proc export step.  Do you know what I can do to preserve the whole length of all labels?   Thank you!! Please let me know if I can be clearer/more specific.     ... View more

Hi there,   I have an input data set, which is structured something like the sample data set below. Would someone have a suggestion for the best way to identify the food item with the least amount of each nutrient type at each school-meal-day combination If the data set is food-level, has  up to 400 food items at a school throughout the week, and almost 2000 schools ?   Some details:   food item - food-level file where each different food item anew for each school where it's offered and each meal within that school it's offfered. So if a food item, an apple, is offered at 100 schools, for both breakfast and lunch, it'll be listed 200 times in the fole, one row for each school and meal combo where it's offered.   meal- breakfast, lunch day - weekday nutrient- the amount of a nutrient in that food item   Fooditem    School       Meal      Day        Nutrient1   Nutrient2    Apple           School1    B            Mon         5 cals        10 cals Apple           School1    M            Mon         5 cals        10 cals Apple           School1    B            Tues        5 cals        10 cals Apple           School1    M            Tues       5 cals        10 cals Apple           School1    B            Wed        5 cals        10 cals Apple           School1    M            Wed        5 cals        10 cals Apple           School1    B            Thurs      5 cals        10 cals Apple           School1    M            Thurs      5 cals        10 cals Apple           School2    B            Mon         5 cals        10 cals Apple           School2    M            Mon         5 cals        10 cals Apple           School2    B            Tues        5 cals        10 cals Apple           School2    M            Tues       5 cals        10 cals Apple           School2    B            Wed        5 cals        10 cals Apple           School2    M            Wed        5 cals        10 cals Apple           School2    B            Thurs      5 cals        10 cals Apple           School2    M            Thurs      5 cals        10 cals Milk           School1    B            Mon         5 cals        10 cals Milk           School1    M            Mon         5 cals        10 cals Milk           School1    B            Tues        5 cals        10 cals Milk           School1    M            Tues       5 cals        10 cals Milk           School1    B            Wed        5 cals        10 cals Milk           School1    M            Wed        5 cals        10 cals Milk           School1    B            Thurs      5 cals        10 cals Milk           School1    M            Thurs      5 cals        10 cals Milk           School2    B            Mon         5 cals        10 cals Milk           School2    M            Mon         5 cals        10 cals Milk           School2    B            Tues        5 cals        10 cals Milk           School2    M            Tues       5 cals        10 cals Milk           School2    B            Wed        5 cals        10 cals Milk           School2    M            Wed        5 cals        10 cals Milk           School2    B            Thurs      5 cals        10 cals Milk           School2    M            Thurs      5 cals        10 cals   Woulld there be another way aside from - assigning a macro and then callin a proc sort process for each school/day/meal/nutrient/food combo? - and aside from sorting the dataset by a list of BY vars then creating a concatenated var for each school/day/meal/food nutrient combo then identifying each unique first combo as the one with the least of each nutrient level? Thank you in advance   I use SAS 9.4 ... View more

Hi everyone,   I'm wondering if anyone has suggestions for how I could create some meal-level and school-level variables from a food-level file. More specifically,   - Input file is a food item-level file of about 200,000 food items, where each record has variables to indicate the school ID, weekday (num, 1-5), the meal (lunch/breakfast), the food category (five categories), and multiple variables to indicate nutrient contents for that food item. Since these are food-level files, any school-level and menu-level variables repeat for each food within a school or day.     How would I tell SAS to give me a variable of the minimum of a certain nutrient (ie lowest fat) at a specific school, on a day, during lunch meal, and within one food category.  What kind of functions would I use to get to this school-level variable?   Due to the size and structure of the input file, I'm opting not to do a basic proc transpose at the beginning of this work to convert the food level file to a school - level one. I'm wondering if there s other data/proc? step processing I can do to get to where I need to.   Would you let me know if I should clarify?   Thank you!   ... View more

Hi there -- Though this is less a SAS specific question and more a general clarification question, I'm wondering if someone would have feedback/suggestions: to report on the percent of, say, schools which fall under some list of conditions, is it necessary to have a school-level file?   I’m asking since I see the file I have is a food-level file, where isn't even one food item per record (instead, each food item can be listed more than 100 times). Additionally, the variable for unique school ID's reports frequencies of up to 300-400. Given the current interim file structure, I’m wondering whether the most desirable thing is to convert the food-level file to a school-level one or if there is an alternative. What approach could one take to report percent of schools which offer one food item (example)?   please let me know if i should clarify or if there s a better space for a question like this Thank you in advance!       ... View more

Hi, I have a program which outputs two emails. Without having changed the macro/code relevant to the program, however, I receive the following error:   "ERROR: Email: Permission is denied.".   Any thoughts why this may be? Should I provide more information?   Thanks in advance!   -- some code:   　 %macro from_email; %global from_email; %if "&sysuserid."="ShivjiA" %then %let from_email=Azim Shivji <azim_shivji@abtassoc.com>; %else %if "&sysuserid."="HuqM" %then %let from_email=Maisha Huq <maisha_huq@abtassoc.com>; %else %let from_email=noreply@abtassoc.com; %mend from_email; %from_email; %put &from_email.;   options nodate nocenter; options emailackwait=210; * ^ http://support.sas.com/documentation/cdl/en/lesysoptsref/68023/HTML/default/viewer.htm#n1s3ofo2vn63bln10wnrh4stkty2.htm; ods listing close; title; footnote; ods escapechar='^'; %macro email(to_email,to_name,to_reference); filename outbox email to=("&to_email.") type="text/html" subject="AHAR QC Report" from="&from_email." sender="&from_email." replyto="&from_email." bcc=("&from_email.")  ; ods html body=outbox style=journal rs=none options(pagebreak='no'); proc odstext; p "Hi &to_name.,"; p " "; p "XXX."; p " ";   run; ods html close; %mend email; %email( to_email=XXX@gmail.com, to_name=XXX, to_reference=%str(XX, XX) ); %email( to_email=XXX@gmail.com, to_name=XX, to_reference=%str(XX, XX) );   ... View more