An Idea Exchange for SAS software and services

by Respected Advisor
on ‎01-23-2013 02:53 PM
I'm waiting for an answer from a collegue about the validity of some data. Besides, I can't resist for too long the urge to answer an easy question on the Forum.
by Super Contributor
on ‎01-23-2013 02:59 PM
The question you answered is not easy for me. I have looked at it but could not figure out what the OP wants.
by Respected Advisor
on ‎01-23-2013 03:10 PM
It is not clear indeed but I made a guess. That is often the problem.
by Super Contributor
on ‎01-23-2013 03:29 PM
I was interested in learning hash sometime ago. How about your hash skill?
by Respected Advisor
on ‎01-23-2013 04:16 PM
I was too. I managed to find a problem where a hash object would be almost essential (a tree structure problem). I find the so-called SAS objects very limited and not very useful. In short: they are solutions in search of a problem.
by Super Contributor
on ‎01-23-2013 04:29 PM
I knew you posted a hash question. So you don't want to learn hash anymore? If I don't learn something new I feel time wasted. What should I do? any suggestions? I thought of leanring proc report by following Cynthia's posts. What do you do in your free time? I once tried learn cook then gave up quickly.
by Respected Advisor
on ‎01-23-2013 04:46 PM
How about photography? You could use your long walks to get to things or places that you want to photograph. Some photographers go back to the same place for months before they can get the perfect temperature, atmosphere, lighting, etc. Having such a project makes you more alert about your surroundings. If on the other hand you try portrait, then you have to work on your people skills. That's even more difficult.
by Super Contributor
on ‎01-23-2013 05:01 PM
That is too difficult for me. I am not good at the detailed things and don't have enough patient. But I will try.
by Super User
on ‎04-23-2014 12:28 PM

That is not really needed as a simple %LET will strip them for you.

Try this code:

%let x=%sysfunc(putn(3,F6.));

%put |&x|;

If you want to PRESERVE the leading and trailing spaces then use %Qsysfunc().

by Super Contributor
on ‎04-23-2014 12:31 PM

Sure, but if it's an argument inside a longer macro variable, that doesn't work.  This came up on the SAS-L earlier today.

%let fname=&ReportsFolder.%sysfunc(putn("&ddate."d,worddate.))_Summary.csv;

generates something like C:\yourdir\       June 10, 2013_Summary.csv

Removing the space requires either a second SYSFUNC, or a second macro variable - both really unneeded.

Idea Statuses
Top Liked Authors