About Manu_SAS

Sir_Highbury · ‎05-25-2016

LinusH · ‎05-03-2016

Why store it as char? Use format=datetime 18 Also, using automatic macro variable may be more efficient than using functions: "&sysdate:&systime"dt One drawback with thus this will only give you the minute.

Manu_SAS · ‎04-20-2016

In that case, it will not work. Even i thought the same. We can do one thing, capture the salary in macro variable and using it in the datastep. data m1; input type $ amount; cards; sal 10000 cheq 2000 teller 5000 ; proc sql noprint; select amount into : amt from m1 where type='sal'; quit; data m2; set m1; x=&amt.; if amount/x > 0.20 then flag=1; else flag=0; run; ~Manohar

elwayfan446 · ‎01-22-2016

Ok, I see. I found it somewhere in a google search I stumbled upon. I have sense left the page. So the way that @Manu_SAS has described it is the proper and only way then? Looks like I might be stuck with what Lotus Notes is giving me in the first example.

imdickson · ‎01-20-2016

Thx man, u helped me. This is exactly what i want. Meaning i shouldn't use "List Report". Thx again.

RahulG · ‎12-27-2015

Your dataset should be populated before prompt ask for user to enter. One of the ways I know is 'Submit code when server is connected'. Here, you write sas code that creates dataset which is needed in dynamic prompt. Before EG show you the prompt, the required dataset would be ready and you will get the updated prompt values. Go to Tool --> Options --> SAS programs --> Submit code when server is connected Click Edit and enter your code here. I have also attached a snapshot with this reply. The only problem with this approach is - this change would be applied to your SAS EG setting, so it would run for every EG project.

Kurt_Bremser · ‎05-13-2015

AFAIK, a view is always read-only.

nash_sas · ‎03-09-2015

Just have double/single quotes qualfiers for all the variables and do a simple proc export. Why the equal sign ("= 0...") instead of just double/single quotes, if it's OK to have output .csv files be opened with text editors like notepad or wordpad ?

Tom · ‎02-10-2015

You need to use %COPY to view the source code of a macro if the macro was delivered in a compiled catalog. But DS2CSV and other supplied SAS macro are delivered as source files. So you don't need to se %COPY, just read the file. data _null_; infile sasautos('ds2csv.sas'); input; put _infile_; run;

Online Status	Offline
Date Last Visited	‎11-13-2017 10:18 AM

Re: proc sql generate timestamp

Re: debug macro call execute, no error, no results

Re: comparing 2 amount values

Re: comparing 2 amount values

Re: How to embed file in email instead of attach?

Re: Problem When doing "List Report" with duplication values in every ...

Re: Prompt using generated dataset in the a project

Load SAS dataset/View into Teradata View

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

PROC SQL - is overwriting generation datasets totally safe (so that no...

Re: comparing 2 amount values

Re: what can be used instead of proc update for a big data set?

Re: enterprise guide export data to excel

How to embed file in email instead of attach?

Re: proc sql generate timestamp

Re: debug macro call execute, no error, no results

Re: proc sql generate timestamp

Re: comparing 2 amount values

Re: How to embed file in email instead of attach?

Re: Problem When doing "List Report" with duplication values in every ...

Re: Prompt using generated dataset in the a project

Re: Load SAS dataset/View into Teradata View

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Re: Is there any way to store the source code of SAS Utility Macro(%DS...