About leonzheng

leonzheng · ‎01-08-2019

thank you, it worked, my mistake I didn't see the difference before. I marked the 1st answer about this as solution.

leonzheng · ‎01-03-2019

Thanks, now it seems libref is assigned and connection is established. However, there is a new error in proc append base = DB.existingdata data = have force; run; error: no database selected SQL statement: SELECT * FROM 'existingdata'. I used append locally before and there was never such an error be seen.

Kurt_Bremser · ‎10-25-2018

@leonzheng wrote: Thanks, my operation after query is quite complicated, so I am not sure if call execute will work It's actually very simple. Assume your code needs a macro variable &item to work for a single instance. Wrap it into a macro that handles one instance: %macro your_mac(item); /* lots of complicated code here */ %mend; Then call that macro off of your dataset: data _null_; set have; call execute('%nrstr(%your_mac(' !! strip(item) !! '));'); run; The single quotes and the %nrstr() prevent premature execution of macro logic when the code is pushed into the execution chain.

leonzheng · ‎08-16-2018

Thanks!

leonzheng · ‎08-01-2018

thx, let me try

leonzheng · ‎06-28-2018

The reason is part of my code works in server environment and part is in desktop environment. The macro variable defined on server is not recognized by my local machine.

leonzheng · ‎06-22-2018

thx, I will try this call execute function

leonzheng · ‎06-22-2018

got it, thx

Reeza · ‎06-17-2018

@leonzheng wrote: oh, my mistake, in real case my items in lists are numbers, that is why I miss '' in my example Well, I can only comment on what you show. If this doesn't resolve your problem you need to provide more details of what you want and what isn't working - and what not working means.

Reeza · ‎05-02-2018

Yes, or you can explicitly name them as desired. I usually try to have a common prefix since SAS works on prefixes not suffixes. output out=want mean(jun)= Avg_Jun mean(jul)=Avg_Jul .. etc;

leonzheng · ‎03-18-2018

thank you

leonzheng · ‎01-05-2018

Thank you, my real case is much more complicated to describe and contain company information. So I tried to use simple examples to describe my question. I think your suggestion is good. I will try to form a list file and get selection information from it with macro.

leonzheng · ‎01-03-2018

you are right, thank you!

leonzheng · ‎01-03-2018

you are right, I missed the ROW...

novinosrin · ‎12-29-2017

@leonzheng Requesting you to kindly mark the question as answered and close the thread. Thank you!

Online Status	Offline
Date Last Visited	‎01-10-2019 02:31 PM

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: append dataset to mysql server

Re: update column value in existing table with condition

Re: keep macro variable in dataset

Re: Sum by two groups

Re: append dataset to mysql server

Re: how to append dataset to mysql server

Re: do loop from observations of a dataset

Re: Fitting without outlier but calculate residual for outlier

Re: Can SAS do exclude/hide like JMP

Re: keep macro variable in dataset

Re: condition function for not so simple operation

Re: 4th order polynomial fit with two variables

Re: create a item list and use for entire code

Re: Sum by two groups

Re: update column value in existing table with condition

Re: how to do a new select by list in a existing dataset

Re: Merge datasets

Re: Format transpose

Re: transpose into new format