About samirt

jljones · ‎07-18-2017

proc transpose data=tr out=trans_tr; by Name Name_of_unit; var answer; id new_optionid; run; proc print data=trans_tr; run; This is an old post but the last code was very helpful in transforming my data too (similar layout). Only problem is that I have duplicate persons on my by statement. I used the "let" in the procedure to test the code but I do not want the last observation. I want all of them in the wide format with numbers behind them (ethnic01 ethnic02, etc). Not sure how the code works to add this. Thanks in advance! J

RW9 · ‎01-19-2016

No, the real question here is why on earth are you doing numerical imputations in a textual code generation system? I mean do you use Word as a calculator? Let me explain: Macro language is a technique of generating text, it has some conditionals and what not, but it not itself compilable code, it is merely there to help generate compilable code to save you having to type things. Base SAS is the compilable code, it is there you would do all your computations, data manipulations etc. If for some unkown reason you do need a result in a macro variable, then @Kurt_Bremser has provided you with an answer, use Base SAS data _null_ and call symput to generate the macro variable.

Kurt_Bremser · ‎01-18-2016

data want; set have (rename=(B=oldB)); value_count = countw(oldB,','); do i = 1 to value_count; B = scan(oldB,i,','); output; end; keep A B; run;

samirt · ‎08-27-2015

Thanks for the reply Actually as EXCEPT operator perform vertically on the table. I was in dilemma is there any way of using SET statement in data step

Kurt_Bremser · ‎08-31-2015

You are encountering a bitness problem. Most probably the ODBC driver is still 32bit, while you are accessing it with 64 bit SW from SAS on a 64bit system. eg http://stackoverflow.com/questions/8895823/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-appli

Ksharp · ‎05-14-2015

data have; infile cards expandtabs truncover; input stock $ date : ddmmyy10. cat size; format date ddmmyy10.; cards; A 31/12/2010 1 30 A 31/12/2010 0 20 A 31/12/2010 1 40 A 27/11/2011 0 4 A 27/11/2011 1 6 A 27/11/2011 1 8 ; run; proc sql; create table want as select stock,date,mean(size) as mean_all, (select mean(size) from have where stock=a.stock and date=a.date and cat=1) as mean_1_cat from have as a group by stock,date; quit; Xia Keshan

ilikesas · ‎05-13-2015

Thanks, now I even realize the importance of Independently alliaceous!

LinusH · ‎03-02-2015

It's not unusual to have SAS to refresh tables in an external RDBMS. It could be a architectural decision to keep staing tables there. Refresh strategies could also apply to some data mart structures. But most DBA's don't like replacing tables, so a truncate/insert strategy would have a better chance to get you popular with those guys.

Online Status	Offline
Date Last Visited	‎02-11-2018 03:01 AM

Handling missing values in macro while performing arithmetic operation...

Splitting of column values based on number of values.

Re: SQL pass through facility

Re: SQL pass through facility

Re: trasform/rotate datasets using arrays

Re: Collapsing longitudinal data at the individual level to group leve...

Re: Alternative of EXCEPT operator in Data Step

Alternative of EXCEPT operator in Data Step

Re: SQL pass through facility

SQL pass through facility

Re: trasform/rotate datasets using arrays

Re: trasform/rotate datasets using arrays

Re: Handling missing values in macro while performing arithmetic opera...

Re: Splitting of column values based on number of values.

Re: Alternative of EXCEPT operator in Data Step

Re: SQL pass through facility

Re: calculating averages of a variable depending on another variable a...

Re: creating dummy variables based on string part

Re: How to update the table in sas which is from SQL Server?