About jammy

jammy · ‎07-07-2014

Many thanks..... so if you use the last variable the dataset was sorted by.... in the By statement, it will group it in all the preceeding variables e.g: proc sort data=test; by A B C D E; run; So in the following datastep, I just need: data test_2; set test: by E; ...... this will group the data -> A, B, C, D, E

jammy · ‎07-07-2014

Hi, I want to calculate the cumulative sum but I need to group the data by 2 variables, e.g: Area Month Value CumValue A 1 5 5 A 1 5 10 A 2 15 15 A 2 20 35 B 1 10 10 C 1 5 5 D 1 10 10 D 2 5 5 D 3 5 10 my code: proc sort data= test; by area month; run; data test_cum; set test; by area month; retain cumvalue; if first.area and first.month then cumvalue= value; else cumvalue=value+cumvalue; run; This will only group by the "area". How do I group it by both "area" & "month"? Thanks

jammy · ‎04-03-2014

there are a number of include statements which all contain macros. I was just seeing if I could bring up the code for one instead of hunting it down!

jammy · ‎04-03-2014

it's initialized through an %include statement

jammy · ‎04-03-2014

Hi, Is it possible view a macro's code when you have the name, without invoking it? Thanks

jammy · ‎02-10-2014

My bad..... I was trying to make it more complicated than it is! Cheers

jammy · ‎02-10-2014

Hi all, I need help with the following: I have a 2 variables in a dataset n= number label = string e.g. X!3.479!3.49902!3.43968!3.49919!3.5432!3.69513!3.52109!3.53714! What I need to do is - retrieve the 'n' th value (seperated by "!"). For example: n= 2 value= 3.49902 Im guessing I need to use a scan? Many thanks

jammy · ‎02-03-2014

thanks Tom, that's right - I was wondering why my new files had a time & some had the year (need to brush up on Unix)! I've just coded round it. cheers

jammy · ‎02-02-2014

i think so, as I'm using EG & need to read a directory not on a SAS server.

jammy · ‎02-02-2014

Hi, I'm trying to get all the filenames (.csv) in a directory & want the creation date of the file, like the unix command ls -l. I can get some details using list but it wont give me the year. This is what I have done: filename dir_lst ftp '' cd="&EMFTDIR" list user=&qemftname host="&host" pass= &qemftpwd; data files_list; attrib a b c d e f g h i length=$30; infile dir_lst dlm=' ' firstobs=1; input a b c d e f g h i ; run; Is there something else I can use to return the filename & creation date? Thanks

jammy · ‎04-23-2013

I have tried using the wildcard, if you mean: PROC IMPORT OUT= WORK.All_ERCH DATAFILE= "\beacon_data\sas\*.txt" dbms=dlm replace; delimiter= ';' getnames=yes; run; This does import all the tables, it includes all the headers from each table. I can clean the data, but I'd like a more efficient way to do the import.

jammy · ‎04-22-2013

Hi, Due to my lack / limited use of macro's, I'm hoping someone would be kind enough to help me out. I have a number of files saved in a folder: Folder: Beacon_Data\data\sas\ Files: ERCH_1.txt ERCH_2.txt ::::::::::::::::: ::::::::::::::::: ERCH_50.txt I have used a basic proc input to bring in one file (I can format after) but I've searched the web on how to read all the files in & I fail when I get to reading the what files are in the directory.. PROC IMPORT OUT= WORK.All_ERCH DATAFILE= "\data\sas\ERCH_1.txt" dbms=dlm replace; delimiter= ';' getnames=yes; run; Instead of confusing matters with the code I have copied from various sites, I hope this is a easy program to help with. Many thaanks

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

Re: Cumulative Sum by 2 Groups

Cumulative Sum by 2 Groups

Re: How view macro code, without invoking?

Re: How view macro code, without invoking?

How view macro code, without invoking?

Re: Retrieve Value from a string

Retrieve Value from a string

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l...

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l...

Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

Re: Cumulative Sum by 2 Groups

Cumulative Sum by 2 Groups

Re: How view macro code, without invoking?

Re: How view macro code, without invoking?

How view macro code, without invoking?

Re: Retrieve Value from a string

Retrieve Value from a string

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l...

Re: Returning Filenames & Creation Date in a directory (i.e unix ls -l...

Returning Filenames & Creation Date in a directory (i.e unix ls -l)?

Re: Importing multiple txt files - using a Macro? Help

Importing multiple txt files - using a Macro? Help