About saslove

saslove · ‎05-10-2019

That was only an example of what I am trying to achieve and not the actual macro. I tried this way, but it still holds on to the pre-resolved macro. %macro drop (&dn); proc sql noprint; SELECT name INTO :dropMe SEPARATED BY ' ' FROM sashelp.vcolumn WHERE libname = 'TEMP' AND memname = upcase("&dn") AND INDEX(upcase(NAME,'DTC'))>0; quit; %if &sqlobs > 0 %then %do; data test; set temp.&dn; drop &dropme; run; %end; %mend drop; proc contents data=temp._all_ noprint out=contents; run; data _null_; set contents; by memname ; if first.memname; call execute(cats('%drop(',memname,')')); run;

saslove · ‎05-10-2019

I tried it the way you suggested, but I get this error The DROP and KEEP statements are not supported in procedure steps in this release of the SAS System. Therefore, these statements are ignored.

saslove · ‎05-10-2019

Thanks Tom and Reeza. This is the approach I am using in the macro. How would I do the same with proc datasets. %macro drop (&dn); proc sql noprint; SELECT name INTO :dropMe SEPARATED BY ' ' FROM sashelp.vcolumn WHERE libname = 'TEMP' AND memname = upcase('&dn') AND INDEX(NAME,'DTC')>0; %let numfiles = &sqlObs; quit; %mend drop; proc contents data=temp._all_ noprint out=contents; run; data _null_; set contents; by memname ; if first.memname; call execute(cats('%drop(',memname,')')); run; Thanks,

saslove · ‎05-10-2019

Thanks Reeza. I tried a similar approach. The problem happening is that when I use it in a macro loop to perform the operation for all datasets in the directory, the "&DROPME" list holds on to the previous dataset's variables that were executed. proc sql noprint; SELECT name INTO :dropMe SEPARATED BY ' ' FROM sashelp.vcolumn WHERE libname = 'TEMP' AND memname = 'TOX' AND INDEX(NAME,'DTC')>0; quit; data test; set temp.tox; drop &dropme; run;

saslove · ‎05-10-2019

I have about 50 datasets in my directory. This varies by study, so I need to apply the change I am asking to all the datasets in the directory. I want to delete columns that contain a string with "DTC" in it. The number of columns that contain this string could also vary. It's not consistent. There could be text before and after it, but what I want is all columns that contain "DTC" to be deleted. So, it is a two step process: 1. In each dataset, extract all "DTC" containing columns. (I know I can use index or prxmatch) 2. Delete it from all datasets in the directory (this holds on to the previous list of drop variables - so unable to achieve this). How do I go about this? Please let me know the best way. Thank you!

saslove · ‎04-12-2019

That worked very well. Thanks Reeza

saslove · ‎04-12-2019

I have a dataset that looks like this currentstudy Study1ID Study2ID Study3ID Study4ID 001 180 780 278 560 002 790 520 003 231 As you can see, each patient can be enrolled on multiple other studies. What I need is a dataset that looks like below. Basically, concatenate the column names/study names of the other studies that same patient is enrolled in. currentstudy Other_enrolled_studies 001 Study1,Study2,Study3,Study4 002 Study2,Study4 003 Study 3 and so on for several hundred patients across multiple studies. Thanks very much, Please help.

saslove · ‎03-28-2019

libname mylib '.' What does the "DOT" mean in the above libname statement? Even after I shut down SAS and re-open and re-run my code for another study, the mylib remembers the datasets from the previous study/run? Why does this happen? Thoughts?

saslove · ‎01-22-2019

Ok just an update on what I did. I used proc freq and did a 2x2 to output the flags and reasons . I used data step to concatenate.

saslove · ‎01-21-2019

Perfect! I just changed my code to ^newline. Thanks so much.

saslove · ‎01-21-2019

Solution that worked for me: I used ods escapechar='^'; I added ^n where I want my line break. It doesn't show in the listing or dataset but t works on the rtf file and html file. cat=catx(',^n',cat,death_reason);

saslove · ‎01-21-2019

I need to use it in an ODS RTF destination.

saslove · ‎01-21-2019

Adding the '0D0A'x didn't work for me. I am creating rtf destination, but its all in one big line separated by commas. It doesn't add a line after commas.

saslove · ‎01-21-2019

Thanks, I need it in the same cell. This puts a new row for each line, but I need everything in one cell.

saslove · ‎01-21-2019

Hello, I have this code to put the data I need separated by a comma. Now, what I need is a new line after the comma. Currently, I have this 1 due to symptom1,2 due to symptom2,1 due to symptom3,3 due to symptom4,1 due to symptom5, 1 due to symptom6, and so on.. What I need is 1 due to symptom1, 2 due to symptom12, 1 due to symptom3, 3 due to symptom4, 1 due to symptom5, 1 due to symptom6, and so on.. My code : data want; length cat $10000; do until (last.death_onstudy); set freqs; by death_onstudy notsorted; cat=catx(',',cat,death_reason); end; run; Please help get each symptom to a new line. Thanks very much in advance!!!

Online Status	Offline
Date Last Visited	Friday

FTP connection was reset by peer

Flyover of a number

PROC SQL max value with corresponding visit

Re: SAS Custom Sort

Re: SAS Custom Sort

Re: SAS Custom Sort

SAS Custom Sort

Re: Strip date stamp from 30 datasets

Re: Strip date stamp from 30 datasets

Re: Strip date stamp from 30 datasets

Re: SAS Custom Sort

Re: Consecutive Variable list Macro

Re: INSERT NEW LINE IN RTF

Re: MERGED TWO FILES BUT THE NEW FILE OMTING MANY OBSERVATIONS

Re: scatter plots

Re: Go through all datasets in a directory and delete columns that con...

Re: Go through all datasets in a directory and delete columns that con...

Re: Go through all datasets in a directory and delete columns that con...

Re: Go through all datasets in a directory and delete columns that con...

Go through all datasets in a directory and delete columns that contain...

Re: Extract VARIABLE NAME and concatenate with other variable names ba...

Extract VARIABLE NAME and concatenate with other variable names based ...

libname mylib '.'

Re: PROC SQL to concatenate distinct number and associated text

Re: INSERT NEW LINE IN RTF

Re: INSERT NEW LINE IN RTF

Re: CATX NEW LINE

Re: CATX NEW LINE

Re: CATX NEW LINE

INSERT NEW LINE IN RTF