About 1239

1239 · ‎04-04-2012

Sometimes column names will be more than what I specified in real time. Is there any way to capture the first rows values and renaming the column names automatically instead of explicity specifying in the code? ABC F1 F2 FDG F3 GH KL OI..... Thanks

1239 · ‎04-04-2012

I got below error. ERROR: File _IMEX_.'Invoice$A2:D6'n.DATA does not exist. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.35 seconds cpu time 0.04 seconds I think small confusion has created. My .xlsb data structure will be different. If you look at my orginal post after importing .xlsb, I will create one dataset called "test". Test dataset structure will be as shown below. From test dataset variable names to be renamed. PROC IMPORT OUT= test DATAFILE= "C:\Book1.xlsb" DBMS=EXCEL REPLACE; RANGE="sheet1$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; --test dataset data structure (After Importing structure will be as shown below) ABC F1 F2 FDG ID Name Sex Country 1 ABC M IND 2 BCD F USA 3 CDE M GER 4 DGE M UK --Desired Data (from the test dataset how to achieve as shown below) ID Name Sex Country 1 ABC M IND 2 BCD F USA 3 CDE M GER 4 DGE M UK

1239 · ‎04-04-2012

I got the below error: NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 179 namerow=2; ------- 180 180 startrow=3; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 181 getnames=yes; 182 run; NOTE: The SAS System stopped processing this step because of errors.

1239 · ‎04-04-2012

Thanks for the code but I got the below error. Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. Please help me.

1239 · ‎04-04-2012

Hi, I have .xlsb raw data and once it is imported in SAS, the data structure will be as shown below. My requirement is to rename the column names automatically from the First row values as showin in Desired data. Please help me in achieving this. PROC IMPORT OUT= test DATAFILE= "C:\Book1.xlsb" DBMS=EXCEL REPLACE; RANGE="sheet1$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; --test dataset data structure (After Importing structure will be as shown below) ABC F1 F2 FDG ID Name Sex Country 1 ABC M IND 2 BCD F USA 3 CDE M GER 4 DGE M UK --Desired Data (from the test dataset how to achieve as shown below) ID Name Sex Country 1 ABC M IND 2 BCD F USA 3 CDE M GER 4 DGE M UK Thanks in Advance.

1239 · ‎02-24-2012

Hi, Please find the below sample dataset. I want for each Test whenever Visit = 1 then Visit_order to be as if Visit 1 then Visit_order = 1 if Visit 14 then Visit_order = 2 if Visit 28 then Visit_order = 3 and if Visit 2 then Visit_order = 4 if Visit 14 then Visit_order = 5 if Visit 28 then Visit_order = 6. Could any please help me in achieving this? I have attached expected output for reference. data test; input Test $1 Visit 8.; datalines; A 1 A 14 A 28 B 2 B 14 B 28 C 2 C 14 C 28 D 1 D 14 D 28 run;

1239 · ‎11-23-2011

Hi, Thanks for your code.

1239 · ‎11-21-2011

Hi, Please find the below code for the graph. I need subgroup in this order if prodnum >=40 then this should come first and if prodnum <40 then second. Currently prodnum in subgroup is ordered that is 2 14 18 40 44 50 60 70 Desired Output: 40 44 50 60 70 2 14 18 Also note that prodnum is dynamic after 18 you may expect 28 30 35 or any another value which is in chronological order. Please help me in getting the desired output. Thanks in Advance. /* Set the graphics environment */ goptions reset=all cback=white border htitle=12pt htext=10pt; /* Define the title */ title1 "Side-by-Side Subgrouped Bar Chart"; /* Define the axis characteristics */ axis1 value=none label=none; axis2 label=(angle=90 "Actual Sales"); axis3 label=none; /* Define the legend options */ legend1 frame; /* Generate the graph */ proc gchart data=prodsale1; vbar prodnum / subgroup=prodnum group=country sumvar=actual legend=legend1 space=0 gspace=4 maxis=axis1 raxis=axis2 gaxis=axis3; run; quit;

1239 · ‎11-14-2011

Thanks a lot for your code Ksharp . Its working as per the requirement.

1239 · ‎11-07-2011

Hi Ksharp, Will you please help me to achieve through Dictionary tables? Thanks

1239 · ‎11-05-2011

Hi All, I have worked around my own requirement and I got the solution myself I request at least somebody let me know whether this code can be written in more efficient way? or this is correct? data test; infile cards delimiter = '|' MISSOVER DSD firstobs=2; input Country :$7. Number Test :$8. Result :$3.; cards; Country|Number|Test|Result| CONT|1|TEST2|80| CONT|1|TEST6|86| RI|2|TEST2|58| SI|3|TEST2|94| SI|3|TEST6|99| SI|3|TEST10|78| SI|3|TEST18|88| WI|4|TEST2|94| XI|5|TEST2|99| XI|5|TEST24|| ZI|6|TEST2|77| ZI|6|TEST6|55| ZI|6|TEST10|44| ZI|6|TEST14|34| ZI|6|TEST18|33| ZI|6|TEST24|| ZZI|7|VISIT43|99| ZZI|7|VISIT44|123| ZZI|7|VISIT45|44| ZZI|7|VISIT46|12| ;;;; run; data test1 ; set test ; length testnum 8; testnum = compress(TRANSLATE(upcase(test),' ','ABCDEFGHIJKLMNOPQRSTUVWXYZ/- ')); run; proc sort data = test1; by number testnum; run; proc transpose data= test1 out= test2 (drop = _name_) LET; by country number; var result; id testnum; idlabel test; run; proc sql; create table test_visit as select distinct test, testnum from test1 order by testnum; quit; proc sql; create table visit as select min(testnum), max(testnum) into :min, :max from test_visit; quit; proc sql noprint; select min(testnum), max(testnum) into :min, :max from test_visit; quit; %put min &min; %put max &max; data min; mina = '_'||strip( put(&min., 8.)) ; maxa = '_'||strip( put(&max., 8.)); run; proc sql noprint; select mina, maxa into :mina, :maxa from min; quit; %put mina &mina; %put maxa &maxa; data test5; retain Country Number &mina-&maxa; set test2; run;

1239 · ‎11-05-2011

Hi, Please anyone help. Its very urgent. Thanks in Advance.

1239 · ‎11-02-2011

Hi, The below code is working fine as per the requirement. The only thing is everytime hardcoding cannot be done. How do I write the below code in Macro so that dynamically variables are selected? why because test2-test24 variable names will not remain for same in real time situation, it will be varying. Example: test2-test24, T2-T24, VT2-VT24 so on... data test2; retain Country Number test2-test24; set test2; run;

1239 · ‎10-20-2011

Hi data_null, I tried your code, its working in windows environment but its not working in Unix environment. In realtime I will be running in Unix environment, please find the below error and help me to solve the same. proc sort data=test(keep=test) out=testord SORTSEQ=LINGUISTIC(NUMERIC_COLLATION=on) nodupkey; - 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, DUPOUT, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, OSA, OUT, OVERWRITE, PAGESIZE, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, WKNO, WORKNO. ERROR 76-322: Syntax error, statement will be ignored. 27 by test; 28 run;

1239 · ‎10-19-2011

Hi, I have attached the file and Test varaibles are dynamic. Please help me.

Online Status	Offline
Date Last Visited	‎04-12-2023 03:15 AM

Re: sorting value within a variable

sorting value within a variable

Re: Search matching character values

Search matching character values

How to filter exponentiation values in sas dataset

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

how to apply delimiter based on condition

rename the column attributes from the first row values

rename the column attributes from the first row values

rename the column attributes from the first row values

rename the column attributes from the first row values

rename the column attributes from the first row values

Populating the sequence

SAS/GRAPH: Subgroup ordering

SAS/GRAPH: Subgroup ordering

SAS Transpose: Variables ordering

Re: SAS Transpose: Variables ordering

Re: SAS Transpose: Variables ordering

SAS Transpose: Variables ordering

SAS Transpose: Variables ordering

SAS Transpose: Variables ordering

SAS Transpose: Variables ordering