About forumsguy

Cynthia_sas · ‎04-21-2012

Hi: I don't actually SEE any output. I see a model of possible output with Excel-like column names where normally I would see numbers. Without any data, I can't run your TABULATE to see what you're seeing. And, yes, I see Total Net and Net, but I assumed those were coming from your data, since you do not have any ALL references in your TABLE statement. cynthia

Tom · ‎04-10-2012

Your code is doing the opposite of your request. You care creating one variable from many variables. To make many variables you would need many CASE statements. Assuming you want to split copy TPJNL into variables D2,D3,... then use something like this: select case when (NM='Medical') then TPJNL else . end as D2 ,case when (NM='Income') then TPJNL else . end as D3 ...

Linlin · ‎03-31-2012

Thank you Tom! I will try to remember that. - Linlin

Ksharp · ‎03-30-2012

Oh. That is not SAS datetime constant. you should use some syntax like '01jan2012:00:00:00'dt to pass it. FACT.INCEP_DT BETWEEN ( "&NEXT_REP_PERIOD_START"dt AND "&NEXT_REP_PERIOD_END"dt );

ballardw · ‎03-09-2012

Assuming the blanks were for clarity but that the ld1 and ld2 variables are actually in the data this produces data as your example. data junk (drop= count t); count=0; do ld1 = 1 to 3; ld2 = ld1; t= (ld2-1) * 1000; do ld3 = (t+100) to (t+600) by 100; count+1; ld4= cats('l',put(count,f2.0)); output; end; end; run;

Ddolic · ‎04-18-2012

Sorry, I just dump some code fragments: %macro procmeta(user=DWH, passwd={sas001}xxx, in=query, /* Filereferenz auf XML Datei mit Metadaten*/ out=tmpout); proc metadata SERVER = "sas-meta.corp.de" PORT = 8561 REPOSITORY = "KPI" USERID = "&user" PASSWORD = "&passwd" IN = &in OUT = &out ; run; %mend procmeta; This Macro can query the metadataserver. For IN use some TXT file like this one: data _null_; file query; input; put _infile_; datalines; <GetMetadataObjects> <Reposid>$METAREPOSITORY</Reposid> <Type>Tree</Type> <Objects> <Tree Name="KPI"/> </Objects> <Ns>SAS</Ns> <Flags/> <Options> <Templates> <Physicaltable/> </Templates> </Options> </GetMetadataObjects> ;; run;

forumsguy · ‎02-10-2012

Thank you very much.. it worked... now can somebody help me in integrating this in one job itself... because this is for loading csv files in table and we will have around 50 fact tables so this will create about 100 jobs which are difficult to maintain...... Please find attached snapshot of my outer and inner job... can we do both these things in same job is my question...

RMP · ‎02-10-2012

advice from @LinusH would be the preferred method in DI Studio. Loop Transform.

art297 · ‎02-06-2012

If you do a proc freq of the region variable in sashelp.shoes, you'll discover that there are 56 records that contain a region with the name Africa. As such, your code is send the "log is x" statement 56*6 times.

Peter_C · ‎01-21-2012

Have a look at the OUT2= option of PROC CONTENTS

forumsguy · ‎01-20-2012

Thanks a lot... it solved the purpose...

FriedEgg · ‎01-25-2012

Is the server you are connecting to through EG also Windows?

forumsguy · ‎01-16-2012

Superb.... thanks a ton .... I applied same logic to my code and it worked like wonders....

Linlin · ‎01-10-2012

Hi Art, I like your code. I replace "if First_col='00'" with "if _n_ =1"; if First_col='00' then total=Aseries; else total+-1*Aseries; output; if eof then do; Aseries=total; First_col='Sum'; Name='Final'; output; end; run; Linlin

Ksharp · ‎01-09-2012

Another way is to use merge statement. data one; input data1 data2 data3 position; cards; 102 204 305 1 403 507 609 4 707 806 904 3 ; run; data two; input data4 data5 data6 position; cards; 1100 1200 1600 1 1700 1900 200 2 4000 7000 8000 5 ; run; proc sort data=one;by position;run; proc sort data=two;by position;run; data want; merge one two; by position; drop position; run; Ksharp

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Email notification on table structure and values change

Re: Create multiple datasets from single dataset

Create multiple datasets from single dataset

ODBC SQL server libname issue

print all combinations of upper and lowercase of string

Transpose based on a group

sorting character values which contains date and time

Get filenames modified in current month

Re: Can SAS Read email inbox ?

Can SAS Read email inbox ?

Re: Macro loop problem

List out all files in all sub directories

Re: Report with one header for subgroup

Re: PROC SQL : Create many variables from one variable using case

Re: Macro with single quotes

Date in Macro Variable

Re: Nested Loop problem

Re: Query metadata repository to get information

Help needed with Loop transformation

Reading Multiple Files with File Reader

Looping problem with call execute

compare indexes of 2 tables

Where are SAS DI jobs saved

List out all files in all sub directories

Re: Template in ods pdf

Re: Add summary variable as last observation

Proc sql to create combined table