BookmarkSubscribeRSS Feed
Patelbb
Fluorite | Level 6

Hi,

 

I was wondering if anyone could help me with my code. My input function isn't working for some reason and I can't figure out why. Any help is appreciated. Thank you!

 

27  set dbsdtm.vs;
228  by usubjid;
229
230  length ftemp 8;
231  label ftemp = ?Temperature (F)?;
232
233  vsorresx = input(vsorres , best.);
234
235  if vsorresu = 'C' then ftemp = (vsorresx * 9 / 5) + 32;
236  if vsorresu = 'F' then ftemp = vsorresx;
237  else ftemp = .;
238
239  run;
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2508 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-25
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=12
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2576 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-14
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=62
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2577 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-14
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=112
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2578 VSSEQ=11 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-14
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=161
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2579 VSSEQ=11 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-18
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=206
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2581 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-18
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=252
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2582 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-25
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=302
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2583 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-25
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=352
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2585 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-28
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=402
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2586 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-03-25
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=452
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1160-2587 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-04-01
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=502
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3626 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2012-11-12
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=552
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3627 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2012-12-18
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=602
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3628 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-07
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=652
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3629 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-15
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=702
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3630 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-17
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=752
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3631 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-28
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=802
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3632 VSSEQ=11 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-01-30
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=851
NOTE: Invalid argument to function INPUT at line 233 column 12.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3633 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-02-13
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=898
NOTE: Invalid argument to function INPUT at line 233 column 12.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
STUDYID=ABC-123 DOMAIN=VS USUBJID=1251-3634 VSSEQ=12 VSTESTCD=HNDDOM VSTEST=Hand Dominance VSORRES=RIGHT VSORRESU=
VSSTRESC=RIGHT VSSTRESN=. VSSTRESU=  VSSTAT=  VSREASND=  VSBLFL=Y VISITNUM=-1 VISIT=SCREENING EPOCH=SCREENING VSDTC=2013-02-20
VSTPT=  VSTPTNUM=. FIRST.USUBJID=0 LAST.USUBJID=0 ftemp=. vsorresx=. _ERROR_=1 _N_=948
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
      missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      77 at 233:12
NOTE: There were 3821 observations read from the data set DBSDTM.VS.
NOTE: The data set WORK.VITALS has 3821 observations and 21 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.09 seconds
 
1 REPLY 1
ChrisBrooks
Ammonite | Level 13

Hi @Patelbb - as best as I can tell from the log text the variable VSORRES is character so you cannot read it into the new variable VSORRESX using a numeric informat, it just doesn't make sense hence the invalid argument reference you're seeing in your log.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1385 views
  • 0 likes
  • 2 in conversation