About rajeshm

rajeshm · ‎08-17-2020

length of the variable is 14 only. I read the best12. but forget while applying that logic here. Thanks a lot for letting me know quickly.

PaigeMiller · ‎08-16-2020

I don't know, buy you can find the answer easily enough. Create data sets where the variable of interest is numeric and a similar data set where the variable of interest is character. Then compare by converting to character to numeric. Then compare by converting numeric to character. Which one runs faster?

rajeshm · ‎08-14-2020

Thanks a lot. Oracle has Date datatype. helpful: Yes, Your solution is working as expected. combined 2steps: month(datepart(post_date)) as month, is also working fine.

s_lassen · ‎09-14-2018

Two reasons: Actually, your SET statement IS executed. SAS interpretes anything not zero or missing as a TRUE boolean value, so "if -2" is equivalent to "if 1" The NOBS option sets the variable at compile time, as @PeterClemmensen already remarked. The last reason is why you can get away with stuff like this: data test; do i=1 to n; set x.data1 nobs=n; output; end; run; So the N variable is defined and set before the loop which contains the SET statement begins execution.

stat_sas · ‎10-08-2014

Hi, Yes, this is a better way to do that. I think notalpha(substr(name,1,1)) will be used instead of notdigit(substr(name,1,1)) to get the desired results.

Tom · ‎10-08-2014

You cannot dynamically generate the name of the output dataset during data step execution. You need to use macro code to generate separate OUTPUT statement for each table and then dynamically decide which output statement to execute. So either you generate code like data Acura Audi .... ; set sashelp.cars ; do select (make); when('Acura') output acura; when('Audi') output audi; .... end; run; Or you could use one of the HASH object solutions. With those you can output a hash object to a table name that is generated dynamically (that is the vlaue of a run time variable).

Reeza · ‎10-07-2014

The code is correct, the colour is due to text strings which the editor colours. If you don't want the colours don't use the enhanced editor.

AndrewHowell · ‎09-29-2014

It depends on how you compiled/stored the macro. "session compiled macro" is not specific enough for us to tell how you compiled it: Did you just compile the macro (without the /store option) to the WORK.SASMACR catalog? If so, you might be in trouble. Did you store it in a non-WORK catalog, using the MSTORED option, and %macro xyz / store option? If so you might be in luck. Another thought - why did the Enhanced Editor close suddenly? If SAS crashed, it may not have cleared your WORK folder, so you might at least be able to retrieve the sasmacr.sasb7cat file and stick it somewhere where you could re-invoke the macro and examine the log (as explained in 's reply. Other suggestions to avoid future repetition: Set your SAS startup options to have an ALTLOG keep a copy of everything you generate. (But remember to purge it periodically..) Keep your macros as *.sas files somewhere whilst developing Anyone with other macro best-practice suggestions?

PGStats · ‎09-21-2014

Question 2: These two syntaxes are equivalent. SQL queries describe what you want. SQL processors (part of the DBMS) try to find the optimal way of answering your query. Only testing, within your own configuration, will tell you which is best. PG

RW9 · ‎09-22-2014

I wouldn't recommend the use of proc import if your data is CSV. Write a datastep with an infile statement, you then have full control of what, how long, where from etc. is imported. There are many posts about importing CSV files using differing methods, here is one: https://communities.sas.com/thread/60923

rajeshm · ‎09-17-2014

thanks for the reply. I understood. the interviewer asked me this question

rajeshm · ‎08-29-2014

sorry. could u pls provide me the logic

rajeshm · ‎09-21-2014

hi, As per my understand, if we are not mentioning type column it will create format default(numeric/character name depnds on the fmtname ) But if we mention (i,j) as types then it will create informats. if my assumption is wrong,let me know.

rajeshm · ‎08-28-2014

thanks a lot. you understood my problem. several times I executed that code,sometimes it is hanging but sometimes it is not. I ran separately those statements also(dm and proc). then also can't identify when sas is hanging or when command is working fine. anyhow I wont use those commands from now onwards and thanks again.

rajeshm · ‎08-29-2014

hi, could u please answer this one. question: sas has to create a value/invalue statements for the given dataset (cntlin option for dataset2format convertion).based on what, it is creating value/invalue statements or sas creating both value/invalue statements for the given dataset? thanks in advance

Online Status	Offline
Date Last Visited	‎04-07-2023 11:04 AM

Re: Zipping xlsx files

Re: list input missing varible values reason2

Re: list input missing varible values reason2

Re: list input missing varible values reason2

Re: list input missing varible values reason2

Re: list input missing varible values reason2

Re: list input missing varible values reason2

Re: list input missing varible values reason

list input missing varible values reason2

Re: list input missing varible values reason

Re: Transpose two variables at the same time

Re: list input missing varible values reason

Re: syntax highlight steps within macros and %do loops

Re: FORMATTING DIFFERENCES WITH proc sql vs datastep

Re: dataset differences //Both,exclusiveA,exclusiveB

Re: length of varible in sas

Re: ERROR: Expression using equals (=) has components that are of diff...

Re: getting date month from oracle table with proc sql in sas

Re: if condition dataset

Re: sql query

Re: source code for macros

Re: creating datasets based on the varible values

Re: source code for session compiled macro

Re: min salary employee details

Re: proc import but varible values truncated

Re: rename and label

Re: reading file random without point

Re: converting dataset2formats

Re: pc sas hangs

Re: first.last and last.id