About belboy

belboy · ‎03-13-2018

THANKS ALL, Unfortunately these solutions didn't work for me, the solution that did work is posted below. @Cynthia_sas your solution allowed my variables to come in correctly, but I wasn't able to get the observations. Nevertheless, I wrote my own data step that is working. there may be a more efficient way of coding - but this works just fine so far 🙂 data do_&appname; set &folder; RACFID = scan(f1,1,","); 'Full name'n = scan(f1,2,","); Server = scan(f1,4,","); KFA = scan(f1,5,","); x=countw(kfa,"|"); do i = 1 to x; x1=scan(kfa,i,"|"); Privilege = catx("-",scan(f1,3,","),scan(f1,4,","),x1); drop i x; output; end; run;

belboy · ‎03-10-2018

That's what I was hoping for...but unfortunately, SAS imports everything into the header row. Although TERMSTR=CRLF , I still get everything into a header. Is there a way I can use SUBSTR to extract certain variables/header into observations instead of headers? Thanks for any help.

belboy · ‎03-10-2018

Nah, not a Mac. Using proc import wizard via Windows PC.

belboy · ‎03-10-2018

OK - thought the first post was in the wrong discussion board.

belboy · ‎03-10-2018

Thanks, Here is one of the CSV files... I have several just like this. It is very short and for some reason SAS imports every last one as 5+ headers and 0 obs.

belboy · ‎03-10-2018

HI, I'm using the import wizard with SAS to import a MS Excel CSV file. The problem is that SAS imports the entire file as a header with no observations. For example, SAS shows a 10 variable dataset with 0 observations: RSID FULLNAME Priv Date EMAIL Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com I need SAS to show me a 5 variable dataset with 1 observation: RSID, FULLNAME, Priv, Date, EMAIL Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com I couldn't find any documentation of how to do this. Maybe proc transpose with some other formula? Do I need to figure out a way to recreate the dataset with SAS code (i.e., SCAN, SUBSTR, etc)? Any help is very much appreciated.

belboy · ‎03-10-2018

HI, I'm using the import wizard with SAS to import a MS Excel CSV file. The problem is that SAS imports the entire file as a header with no observations. For example, SAS shows a 10 variable dataset with 0 observations: RSID FULLNAME Priv Date EMAIL Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com I need SAS to show me a 5 variable dataset with 1 observation: RSID, FULLNAME, Priv, Date, EMAIL Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com I couldn't find any documentation of how to do this. Maybe proc transpose with some other formula? Do I need to modify the import statement or figure out a way to recreate the dataset with SAS code (i.e., SCAN, SUBSTR, etc)? Any help is very much appreciated.

belboy · ‎03-07-2018

Thanks @Tom! Also thanks @RW9 for your input as well 🙂

belboy · ‎03-07-2018

here is a sample of dataset AcID, Menu 'Menu-File'n 'Menu-File-Open'n UGTER Y Y Y Y Y UeABC1 N N N N Y UAeCB269 N N N N Y UAwCG2 N N N N Y I just want the "Y" values to say Menu, 'Menu-File'n, 'Menu-File-Open'n, DNA, DNA2 - instead of "Y". @Tom correct - I used the drop statement to prevent inclusion of those variables.

belboy · ‎03-07-2018

Thanks, but unfortunately that still did not work. My values remained "Y".

belboy · ‎03-07-2018

Hi, I'm working with a dataset that contains 389 variables and 19 obs. Each variable has the value "Y" or "N". I want to replace the value "Y" with the actual variable name. Here is my code: data Doappname; set work.dna; drop 'User Name'n 'Date last on'n 'Change Days'n 'Expiration Date'n Allow Master User'n F1 F2 F3 F4 F5 F6 F7 F8 F9 F10; array test {*}_CHARACTER_ ; do i= 1 to dim(test); if test{i} eq "Y" then do; test{i} = vname(test{i}); output; output; end; end; run; SAS log: NOTE: There were 19 observations read from the data set WORK.DNA. NOTE: The data set WORK.DOAPPNAME has 50 observations and 389 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds Nothing changes except for an increase in observations and an added "i" column showing iterations. Every variable still has the value "Y" instead of a column name. I simply just want to replace all instances of "Y" with the actual variable name. Any help is appreciated.

belboy · ‎03-01-2018

@Reeza Thank you, thank you Reeza 🙂 That is what I needed to get me started. I didn't know where to start. thanks for helping 🙂

belboy · ‎03-01-2018

Gotcha - well here is the PROC Import code for it. DATA WORK.ABKSSYS; LENGTH F1 $ 8 F2 $ 21 F3 $ 10 F4 8 ; FORMAT F1 $CHAR8. F2 $CHAR21. F3 $CHAR10. F4 BEST32. ; INFORMAT F1 $CHAR8. F2 $CHAR21. F3 $CHAR10. F4 BEST32. ; INFILE 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx' LRECL=83 ENCODING="LATIN1" TERMSTR=CRLF DLM='7F'x MISSOVER DSD ; INPUT F1 : $CHAR8. F2 : $CHAR21. F3 : $CHAR10. F4 : ?? BEST32. ; RUN; As I said, it's an existing file and I didn't create it...so there is no code for it. I just need the end result to be as I previously mentioned:

belboy · ‎03-01-2018

@PaigeMiller Is there no way to extract one observation into multiple obs? I will try to get the import code for this if necessary.... but thought that someone in the community might have a simple solution (i.e., Role=Scan(1,"';") ) I don't know... I'm drawing a blank. I thought of maybe: where Role ? ";" then output; and perhaps infile / input the data back in correctly? Just curious if anyone has a more efficient manner....

belboy · ‎03-01-2018

The dataset already exists in my organization as I didn't create the file myself. It looks like some basic flat file imported from Excel. However, the real question is what code / function would I write to change the output of this old dataset into a new dataset: OLD USER ROLE abcde Admin;Test fghijk Mgr;Test wxyz Sr;Test;DBA NEW I need to convert the OLD data to look like this: USER ROLE abcde Admin abcde Test fghijk Mgr fghijk Test wxyz Sr wxyz Test wxyz DBA

Online Status	Offline
Date Last Visited	‎05-02-2019 10:56 AM

Multiple proc sql tables with same prefix

Re: Hash Object: How to count all non-missing and missing observations...

Re: Hash Object: How to count all non-missing and missing observations...

Hash Object: How to count all non-missing and missing observations?

Re: Proc Sql Error: Case When / Is Not Null

Proc Sql Error: Case When / Is Not Null

Re: Multiple Users Running Same SAS Macro

Re: Multiple Users Running Same SAS Macro

Multiple Users Running Same SAS Macro

Re: How to take multiple observations and reduce to a single observati...

Re: PROC SQL - Left Join Not Working

Re: SAS import entire file as a header - how do I resolve?

Re: SAS import entire file as a header - how do I resolve?

Re: proc import wizard problem...

Re: SAS import entire file as a header - how do I resolve?

Re: SAS import entire file as a header - how do I resolve?

proc import wizard problem...

SAS import entire file as a header - how do I resolve?

Re: Non-Indexed Arrays and Do Loops

Re: Non-Indexed Arrays and Do Loops

Re: Non-Indexed Arrays and Do Loops

Non-Indexed Arrays and Do Loops

Re: Extracting one observation into multiple observations...

Re: Extracting one observation into multiple observations...

Re: Extracting one observation into multiple observations...

Re: Extracting one observation into multiple observations...