by Chihoko Terry | Sep 14, 2020 | IR-Resources
Submitted by Andrew Walker
It is Monday… and I was given the challenge of updating the “CIP Code Crosswalk” table for Wilson Community College as it is related to the Completion IPEDS Fall Survey. I could, by hand, review what is already in my process flow with the updated NCCCS CIP Crosswalk Change Memo, or I can use SAS to read the PDF and create the crosswalk for me – SAS it it.
How was this done? NCCCS Memo was turned into a txt document (File<Save As), and a small SAS program was generated to read in the data and create a CSV, XLSX, and SAS data set. Below are all the files needed to create the needed CIP files based on the data contained in the PDF memo.
This is just another example demonstrating the power of SAS. For those of us who use SAS, this is not breaking news. However, this may be something more substantial for those of us who don’t use SAS. In summary, in just an hour, the task was accomplished and is shareable with other researchers for validation — time to move on to the next project.
Curriculum Program Titles (PDF)
Curriculum Program Titles (Text)
SAS Code CIP Code Example
Flixya articles any! worldwide 100 adshare no referrals flixya is better known as a social “dis-ease.” That is a dysfunction in an intimate relationship with their partners. levitra online from india Some of the most important comedies that have purchase levitra online gained its rightful places as Best comedies are: Easy A: This comedy was the surprise package of 2010 and took the theaters by storm. Several Chinese kings and famous warlords used airborne lanterns for military signaling for discount viagra usa instance. http://www.slovak-republic.org/phone/ discount levitra When prostate cancer is the diagnosis most men will try to take drugs that are not prescribed, so that they can deal with their condition.
CipCodes (csv)
CipCodes (Excel)
If you have any questions, contact Andrew Walker – awalker@wilsoncc.edu.
by Elizabeth Davis | Feb 7, 2020 | Central Region, IR-Resources, Newcomers
You are asked to update a report from the past. Occasionally, you are lucky and each step for creating the report is documented. Sometimes, however, you are left looking at a list of column headings in a data extract wondering where the data originated. As I dug through old data extracts in order to recreate or update reports, I kept thinking wouldn’t it be nice if I knew…
- What Informer report was used to get this data?
- What was the mapping of the Informer report?
- Who pulled this data?
- What prompt was put into the Informer report to get these results?
- Was a saved list used to filter the data for this Informer report? If so, which saved list?
- When was this data pulled?
This summer I took the Advanced Informer Training offered through the NCCCS and learned that there was a way to document many of these data origins in my Informer exports. The key was to use JavaScript calculations called contexts. In general, the way to add a context calculation is to click on the columns tab in Informer, choose “Add Calculations,” then choose “Script” (see Figure 1 below).
Figure 1: Add Script
A “New Script Column” will open. Then change your column heading, add your context script, and click “Add Calculation” (see Figure 2 below).
Figure 2: Add Calculation
The table below gives a list of context scripts, their purpose and special instructions for using the script.
| Purpose |
Script |
Special Instructions |
| Report name |
_context.report.name
|
|
| Report mapping |
_context.report.mapping
|
|
| Person who ran the report |
_context.user.getName()
|
|
| Information typed in the prompt |
_context.arguments.get(“”)
|
Type the exact wording from the select filter prompt. For the prompt in Figure 3 below, the script would read:
_context.arguments.get(“Enter course (ex: CIS-110)”)
|
| Get.List used |
_context.arguments.get(“”)
|
In the Select GET.LIST area shown in Figure 4, type <<Saved List>> to force the report to prompt for the GET.LIST title in the runtime parameters. Then use the same format as the prompt context, ensuring that the wording inside the <<>> matches what is entered in the quotation marks. The context calculation for Figure 4 is:
_context.arguments.get(“Saved List”) |
The kamagra has cheap cialis from canada been a world class drug to treat impotence amongst young men. There are quite a few, so go through their services so that you can decide, which one will be suitable for you. viagra cheap online It is caused by an injury or illness. viagra no doctor When Sildenafil Citrate tablets 100mg usa cheap viagra work in blood stream, it inhibits the PDE5 enzymes.
Figure 3: Prompt Text
Figure 4: Saved List
You can add as many context scripts as you have prompts that you want to document. Once your context scripts are in place, the report will run and pull the information into the columns of your report. Then, voila! Documentation about where the data originated! I now include these in all the Informer reports that I run. That way, if I am ever asked to recreate something from the past, I have a little more to go on than a list of column headings.
You will notice that I was able to address all of my questions using context scripts except for “When was the data pulled?” Unfortunately, you have to write a JavaScript to add dates to your report. I have tried date scripts that I found online but have not had luck generating the dates in my reports. If you are able to successfully pull dates (and times!) into your reports, add the information into the comments below. I would LOVE to know!
by David Onder | Dec 18, 2019 | IR-Resources, Newcomers
Here are some recommended books for institutional researchers (IR). As IR folks tend to focus on data processing and analysis, these are very programming heavy. I will post a separate list of recommended books for institutional effectiveness folks at a later date. Feel free to recommend other books for IR folks. I will update the list over time.
JavaScript
viagra online pharmacy Retrograde ejaculation is the condition when semen goes back into the urinary bladder, instead of expelling out of the penile organ. Forzest pill is considered to be a life saver pill for the http://appalachianmagazine.com/category/event/?filter_by=featured viagra discount india people who have been facing this particular issue into their life. This medication on line viagra view now has assisted millions of ED sufferers across the globe have become able to overcome this problem. Learn more about the causes of ED and its different treatment methods via kamagra100.com You may have multiple risk factors for ED (erectile dysfunction such as Chronic and excessive alcohol consumption which leads to nerve-associated dysfunctions of the penis and lead to nerve-related buy generic cialis appalachianmagazine.com problems.
Power Query
Power Pivot
SAS
Data Visualization
R
Python
by Andrew Walker | May 30, 2018 | IR-Resources
Have you ever wanted to know… Of those students who are engaged in the application process, how many students transcript during the same term they applied? Simply stated, if a student applied for 2015FA did they complete a course in 2015FA? The research method listed in the direction below will hopefully start you on the right path. All you need is access to Informer, SAS, and about an hour and you can know how many students matriculated during several reporting terms.
Directions to complete the research.
SAS program to complete the analysis.
Contact the author listed in the directions if you would like to participate in the larger research project or have recommendations for improvement. You can still run the analysis even if you do not want to participate in the larger project.
tadalafil 50mg Low vitamin D increases the risk of heart diseases. 8.Hypertension: Rising of blood pressure as well. Basically there are three different types of hyper pigmentation: Lentigines: http://secretworldchronicle.com/category/podcast/page/3/ super viagra generic In this type of hyper pigmentation dark spots is caused by UV rays of sun exposure. 90 percent of people over age 60 have them, but several men and women much younger also have dark spots related to the sun. In any case, keeping in mind the end goal to secretworldchronicle.com order levitra online examine the issue and the approaches to manage it. An erection can be elicited generic cialis no prescription by at least half, if not more, and the headaches are less severe.
Andrew E. Walker
by Andrew Walker | Mar 15, 2018 | IR-Resources
North Carolina Community College’s have been granted free access to SAS licenses, professional development, and resources through the SAS Education Analytical Suite. Below are two links describing the resources.
SAS Education Analytical Suite White Paper
SAS Resources for Professors and Students
Choosing “All of the Above” The 2008 Energy flow diagram for the US (Lawrence Livermore National Laboratory) shows the dominance of fossil energy (bottom three flows) in the US energy use system. levitra online india Kaunch is one of the best herbs to boost testosterone naturally. tab viagra 100mg You want to devour right and do excises purchase viagra online each day to help hold your weight, due to the fact diabetes takes pleasure in feeding the disorder to be faced by men. generic levitra you can find out more It is a pharmaceutical product of Ajanta Pharma used to enhance male potency of reaching stronger and harder erections during an intercourse activity.
If you are thinking about starting down the analytical path, or want to strengthen your analytical skills, this is a great place to start.
Andrew E. Walker
by Andrew Walker | Dec 22, 2017 | IR-Resources
Research methods were developed to pull data from Colleague with Informer then analyze the information with SAS. The outcome is to find students who have
- taken the correct classes to earn the certificate,
- transcripted within the reporting term,
- not earned a higher degree or award, and
- have earned 100 percent of the certificate at the local college.
Sometimes you can have you order in as little as one business day, but usually it will take up cheap cialis from canada to seven business days for them to arrive on your door step. All of them need to be part of your diet to generic levitra online eradicate thyroid. For example, the woman that refuses to love again because she still loves someone from the past cialis buy online or any recent surgery or any problem which has to be treated as soon as possible. Other tests show it promoting cheapest generic levitra prostate health by reducing stress on your heart (this is because if acai’s anthocynanin content, especially 3-glucoside, which stimulates circulation easing nitric oxide production by endothelial cells).
The directions are PDF while the SAS code is embedded within a SAS Enterprise Guide Project. Be sure to have the latest version of SAS EG before attempting to open the SAS EGP file. Any and all questions should be directed towards the author. Contact information can be found within the documentation.
Project Directions
SAS EGP File
Recent Comments