sas
Substituting the values of a variable in sas
I have a column in my sas file as age and another column as finalage. I want to substitute the values in age column by values in agefinal column for just one ID (that is 5)[详细]
2023-03-16 19:04 分类:问答How do I create SAS fixed-format output containing end-of-line control characters?
I am using SAS\'s FILE statement to output a text file having fixed format (RECFM=F). I would like each row to end in a end-of-line control character(s) such as linefeed/carriage return. I tried the[详细]
2023-03-16 07:20 分类:问答How can I pick the latest week file from a folder with sas macro?
I need to pick the latest week file from a folder, but I don\'t want to enter the week every time. It\'s a weekly report which I want to make as easy as pressing F3 and having it run.[详细]
2023-03-16 02:05 分类:问答How does SAS macro quoting interact with format literals?
Executing locally in a clean sess开发者_如何学Goion: %let x = %str(put(age, best.)); proc sql; select &x from sashelp.class;[详细]
2023-03-14 14:50 分类:问答SAS proc SQL and arrays
This is a newbie SAS question. I have a dataset with nu开发者_如何学JAVAmerical variables v1-v120, V and a categorical variable Z(with say three possible values). For each possible value of Z, I would[详细]
2023-03-13 09:45 分类:问答How to find out variables with no observations in a large data set?
I have a SAS dataset with more than 1300 variables in it. There are about 200-300 variables that have no observations at all. Is there any way to get a list o开发者_运维百科f these variables that have[详细]
2023-03-13 06:56 分类:问答How can SAS be used to determine the size of a directory in MBs (Windows)?
Am looking for some (efficient) code to determine the size of a di开发者_开发技巧rectory / folder in Windows XP using SAS 9.1.3.If you are not constrained by the SAS NOXCMD option (such as SAS Enterpr[详细]
2023-03-12 05:56 分类:问答How can I perform a piece of macro for each observation in sas data step?
Suppose I allow user to write his own variable calculation macro using a common user interface: %macro calculate(var_name, var_value);[详细]
2023-03-11 20:33 分类:问答Apply format to null string
I\'d like to apply a label to nulls in a character variable. I can do this quite fine with numeric variables, but am unsuccessful with character vars. I\'d like to apply the label \'Both Groups\' to[详细]
2023-03-11 09:06 分类:问答What would it mean when a variable is highly correlated with intercept in proc logistic in SAS?
I found from one of my proc logistic report that a certain variable is highly correlated with the intercept. How can I interpret it? What should I change to amend this correlation?[详细]
2023-03-11 07:52 分类:问答