Hi Im wondering if the Sas Help and Dcoumentation that is accesible in Sas 9.4 is stored offline? I often use SAS when im on the go and dont have internet access. I tend to have my own notes on how to use several functions, so is it possible to edit sas documentation if the files are stored in the program? I found that there are some files with .hlp extensions that would imply that they are used for the documentation. But so far i wasnt able to edit them. Any idea if that is possible? ... View more

I have a column in my tables that has observations like this:   Date 200601 200602 200603 ...   I want to convert them into a date format that can be used in proc forecast procedure ( so like 1JAN2006, 1FEB2006 etc.) How can i do that? ... View more

I'm trying to categorize variables in one tables based on the conditions coming from another table. Currently im using macro which assigns categories (by creating a new table and putting categories under the variables) to those values however it seems that it is assigining them even if the value doesnt not meet the conditions. For example 2nd value of first variable is 78 which should be category 2 but it still assigns it to category 1. With this post I'm providing the two datasets(tables)- one is for categorization conditions and the other one is containing all the variables with values. ... View more

I have dataset (table) that has over 300 column names, I would like to parse out all the column names which are of type=numeric and contain a specific string in name (like "app"). And then all those column names that meet the conditions I would put into a macro variable. (%let vars = [list of those column names]). How would should I do that?  ... View more

Hi I have a dataset consiting of large amount of variables (50+) Some of those variables are text and some of them are numeric. I want to categorize every of those variables into 2 or 3 categories. So lets say the second column of my dataset which is age would be categorized into young (age<25) older (25<age<40) oldest (age>40). Another variable which is gender would be categorized into male and female. And the third is number of cars (0=none, 1 car= 1, 2+ cars= multiple) and so on. So the thing is every variable woud require writing different categorization criteria which will result in a quite long code if done manually. I was thinking of creating a table where I would put a criteria how every variable should be split and then create conditions based on that. But I am not sure if it is the simplest approach and maybe you can give me some insight how to deal with this problem. BTW im on SAS 9.4. ... View more