cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Fersal
‎07-06-2018
  • 10 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: rename variables automatically before merge datasets

by Calcite | Level 5 in SAS Programming
‎04-08-2016 01:18 PM
‎04-08-2016 01:18 PM
Hi, I also have tried this, but it doesn't work ... View more

Re: rename variables automatically before merge datasets

by Calcite | Level 5 in SAS Programming
‎04-08-2016 11:23 AM
‎04-08-2016 11:23 AM
Thanks for your comment, the reason I want to use a macro is because I have a lot of data set which I want to merge and the name of the most variables are the same but can be different values in each of them. ... View more

Re: rename variables automatically before merge datasets

by Calcite | Level 5 in SAS Programming
‎04-08-2016 11:22 AM
‎04-08-2016 11:22 AM
but it works when it is out of the macro which I don't understand why... What I did is add WHERE upcase(name) ne "PLOT" after the last query, now it works but I still get the following warning message   WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.   Thanks     ... View more

rename variables automatically before merge datasets

by Calcite | Level 5 in SAS Programming
‎04-08-2016 08:16 AM
‎04-08-2016 08:16 AM
Hi all,   I have made the following macro but I am getting a error message in the end, someone could help me to know what I'm doing wrong?   %MACRO RENAME (dataset1=, dataset2=); PROC SQL; DESCRIBE TABLE LeafL LeafW dictionary.columns; QUIT; PROC SQL; SELECT libname, memname, name FROM dictionary.columns WHERE libname= "WORK" and memname= "&dataset1"; QUIT; PROC SQL; SELECT libname, memname, name FROM dictionary.columns WHERE libname= "WORK" and memname= "&dataset2"; QUIT; PROC SQL; SELECT trim(name) || "=" || "&dataset2" || "_" || name INTO :renamevar separated by " " FROM ( SELECT name FROM dictionary.columns WHERE libname= "WORK" and memname= "&dataset2" and upcase(name) in ( SELECT upcase(name) FROM dictionary.columns WHERE libname= "WORK" and memname= "&dataset1" and upcase(name) ne "PLOT" ) ); QUIT %PUT &renamevar; DATA Land; MERGE LeafL LeafW(rename=(&renamevar)); BY plot; RUN; %MEND; %RENAME (dataset1= LeafL, dataset2= LeafW); RUN;   From the log windows (below) seem like there is something wrong with the macro variable but I don't know exactly what happen.   WARNING: Apparent symbolic reference RENAMEVAR not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "RENAME". 7 BY plot; -- 180 ERROR 180-322: Statement is not valid or it is used out of proper order.   Thanks ... View more

Using values from a dataset as macro variables

by Calcite | Level 5 in SAS Programming
‎03-29-2016 04:06 PM
‎03-29-2016 04:06 PM
Hi all, I want to use the values of a variable in a dataset as macro variables in other procedure. I'm using the CALL SYMPUT option but something is wrong. Consider the follow example. DATA nowanted; infile datalines truncover; input variables $ freq :$10.; datalines; Var3 100 Var6 100 Var8 100 run; DATA fulldata; INFILE datalines truncover; INPUT (Var1 - Var8) ($); datalines; 20 50 20 80 45 50 20 60 20 20 20 80 50 50 30 60 50 50 20 50 45 50 30 60 50 30 20 50 50 50 50 60 30 30 20 80 50 50 30 60 run;   DATA _null_; SET nowanted; CALL SYMPUT ("macrovar", variables); run; %put variables to drop from the fulldata are &macrovar; DATA datahold; RUN; *empty data set to hold results; DATA Final; SET datahold fulldata(DROP=&macrovar); RUN; In the results,the Final dataset the var8 is dropped but not the Var3 and Var6 variables as is expected.   Any suggestion?   Thanks ... View more

Re: dropping data with low freq

by Calcite | Level 5 in SAS Programming
‎03-29-2016 08:45 AM
‎03-29-2016 08:45 AM
  Hi FreelanceReinhard, Thanks for your comments, actually the original dataset is pretty big, and the number of observation is much higher than number of variables (not like the example I showed). I have had a convergence problem with this data when I try to fit them to a logit model (even after apply the Firth option), so there is not likelihood estimates for these variables, for that reason I want to know what happen if I remove those classes.   Regards     ... View more

Re: dropping data with low freq

by Calcite | Level 5 in SAS Programming
‎03-29-2016 08:10 AM
‎03-29-2016 08:10 AM
Hi Loko, thank you for your macro, it worked well, one more thing, if I want to remove those variable with only one class, e.g. suppose a variable (look below) with only two classes, this one is going to stay with an unique class (170/170) after running the macro, how I could drop those variables from my data using the same macro?   Var4 170/170 170/170 170/170 178/178 170/170 170/170 170/170 170/170 170/170 170/170 170/170 170/170 170/170 170/170 170/170 ... View more

dropping data with low freq

by Calcite | Level 5 in SAS Programming
‎03-28-2016 06:06 AM
‎03-28-2016 06:06 AM
Hi all, I have a dataset from which I wish to drop (for subsequent analysis) those values of the variables with only one observation, that is with a Freq count of 1. In following table there is a similar example. The values in bold are those I do not want to consider in my analysis. I appreciate any suggestion. Thanks   Trait Var1 Var2 ...Var300 1 200/200 120/120 100/100 1 150/150 140/140 99/99 1 100/100 180/180 135/135 1 150/150 120/120 100/100 1 100/100 180/180 160/160 1 150/150 119/119 160/160 1 200/200 140/140 135/135 0 150/150 180/180 0 149/149 140/140 160/160 0 100/100 120/120 133/133 0 100/100 140/140 100/100 0 200/200 180/180 135/135 0 150/150 140/140 160/160 0 200/200 180/180 100/100 0 100/100 120/120 135/135 ... View more

Re: Combining data set into a macro

by Calcite | Level 5 in SAS Programming
‎03-28-2016 05:25 AM
‎03-28-2016 05:25 AM
Thanks, even with my bad explanation of the issue, you were able to understand the essence what I wanted to do, finally I got to combine the datasets using ":" and using some conditional statements, I tried with the append procedure but it doesn't work since the structure of some datasets were not exactly the same (eg. length of some variables). ... View more

Combining data set into a macro

by Calcite | Level 5 in SAS Programming
‎03-25-2016 03:11 PM
‎03-25-2016 03:11 PM
Hi all, I want to reuse the text from a macro to combine some data set using the SET statement but the name of the datasets I want to combine are macro variables (see the example below), therefore the only result in the data set "Lis_prob_&variable" is the information of the last data set "prob_mar130". Any suggestion?   %MACRO example (variable=); SAS statements ; ODS OUTPUT ModelANOVA = prob_&variable; DATA List_prob_&variable; SET prob_▮ IF effect = "&variable"; RUN; %MEND example;   %example (variable = mar1); %example (variable = mar2); ; %example (variable = mar130);   Thank you in advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-06-2018 11:39 AM
Likes given to
View All
Quick links