Hi do you mind sharing a shell of what you anticipate to achieve , I think this might be easier ... View more

LOOKING FORWARD TO ATTEND, #longliveWUSS ... View more

Hi, I missed this, was there a recording on the same.   ... View more

Hi there! It appears that you are attempting to edit and save a dataset in SAS. Save is not a valid statement in the proc datasets procedure, and even if it weren't commented out, the save statement you're using is. To save the altered dataset in an everlasting library, you must establish a library reference to a physical location to which you possess write access. Here's an illustration of how to achieve this: libname mylib "/folders/myfolders/"; /* Specify your directory path */ data mylib.final; /* This will create a new dataset in the mylib library */ set work.final; run; The path /folders/myfolders/ is referenced by the library mylib in this code. The data phase generates a new dataset in the mylib library called final, which is equivalent to a physical file in the /folders/myfolders/ directory. The dataset work's set statement is read.last.   Kindly substitute "/folders/myfolders/" with the real path to the dataset location. The changed dataset will be stored to the designated directory following the execution of this code and will remain there even after your SAS session has ended.   Let me know if you have any other questions! ... View more

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