Hi, I came across such a question answerd in sas community:   Kindly have a look and see if you can incorporate the same in you code:   link one split variables  Link two split variables 2  ... View more

Thanks for sharing this, Its now time to hit Diamond ... View more

Hi can have the following: data have; input id age gender$ v1 v2 v3; cards; 1 20 M 3 4 3 2 22 F 4 3 2 3 34 M 5 1 5 ; proc print; proc transpose data=have out=want; var v1 v2 v3; by id gender age; proc print;   Read more about Proc transpose here: Taming Proc Transpose   ... View more

Hi to help you better would recommend you go through the following link:   Merge with Caution  by Joshua M. Horstman   However    data pd_score; merge pd_score(in=a) long_run_pd; by segment_id; if pd>long_run_pd then long_run_pd=pd; if a; run; In this merge, if segment_id is the same but pd is different in pd_score and long_run_pd, the pd value from pd_score will be used in the resulting table. This is because pd_score is listed first in the merge statement, so its values have precedence.   The if pd>long_run_pd then long_run_pd=pd; statement is updating long_run_pd to be equal to pd if pd is greater than long_run_pd. The if a; statement is a subsetting if statement. It means that only the observations that come from the pd_score dataset (where a is true) will be output to the resulting dataset.   I hope this helps!   ... View more

    Hi I think to do this you need to specify the sheet name as follows:   i.e use the Sheet statement   Hope this helps.     proc export data=mydata outfile='C:\path\to\mydata.csv' dbms=csv replace; sheet='MySheetName';/*Insert the Sheet name here*/ run; ... View more

Awesome, will try it ... View more

data output; set YourDataset; /* Replace "YourDataset" with the name of your actual dataset */ Fname = scan(full_name, 1); /* Assuming the full name is stored in a variable called "full_name" */ Lname = scan(full_name, -1); /* Extracts the last word in the full name */ /* Output the formatted names */ put "Fname: " Fname; put "Lname: " Lname; run; In this code, you need to replace "YourDataset" with the actual name of your dataset containing the full names. The SCAN function is used to extract the first name ( Fname ) and last name ( Lname ) from the variable full_name . The -1 as the second argument of SCAN tells SAS to extract the last word in the string. Finally, the put statements are used to display the formatted output in the SAS log. Make sure to adjust the code according to your specific dataset and variable names. ... View more

I think you will need to read on the two types of macro parameters, i.e Keyword and positional parameters. I have a book that can help you in this. In this line %MACRO procmean (dataset=, var1=,var2); you have keyword parameters preceding positional parameters, this is wrong, it should be vicevasa. ... View more

Hi, sure will appreaciate, kindly share via my inbox ... View more

Not sure of this, but for my case I had to start with SAS Base Programming Exam. ... View more

Hi,  There is a link with a similar questions, the examples shown here, looks like what you want, Merge-Multiple-tables    Hope it will be useful ... View more

Hi. Will there be a virtual session, am from Nairobi Kenya   Thanks ... View more

Would say create a global macro of the path, such that the macro variable "&path" will be looping in the different paths that you will have created in the global macro. ... View more